A compound key
The distinguishable parts of a record are called
Large collections of files are called
The index consists of
A _____ means that one record in a particular record type may be related to more than one record of another record type.
Which command(s) is(are) used to redefine a column of the table in SQL ?
Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL?
In SQL, the ALTER TABLESPACE command is used
The language used in application programs to request data from the DBMS is referred to as the
In SQL, which command(s) is(are) used to create a synonym for a schema object?
If you want your database to include methods, you should use a _____ database.
In SQL, which of the following is not a data Manipulation Language Commands?
Which of the following is not characteristic of a relational database model?
A computer file contains several records. What does each record contain?
In SQL, the CREATE VIEW command is used
A ____ Contains the smallest unit of meaningful data, so you might call it the basic building block for a data file.
In the DBM approach, application programs perform the
In SQL, which command is used to create a database user?
When performing a look-up operation using a form
A _____ means that one record in a particular record type is related to only one record of another record type.
A _____ database does not use pointers or physical links, but instead finds related records by examining the contents of fields.
In SQL, which command(s) is(are) used to redefine an index's future storage allocation
Which of the following is a serious problem of file management systems?
With respect to data input, the most accurate description of batch control is
The model for a _____ resembles the hierarchical model in many respects.
A set of programs that handle a firm's data base responsibilities is called a
In any hierarchy of data organization, the smallest entity to be processed as a single unit is called
Long-range planning report produced in an MIS are primarily designed for
The model for a record management system might be
The designer of a form includes
Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?
Two files may be joined into a third file if
Characteristic(s) of a distributed MIS structure is
The data-base environment has all of the following components except:
Data security threats include
An operation that will increase the length of a list is
In SQL, which command is used to add a column/integrity constraint to a table
In a relational schema, each tuple is divided into fields called
In SQL, the CREATE TABLESPACE is used
In SQL, which command is used to remove a stored function from the database?
The database administration function includes
A relational database management (RDBM) package manages data in more than one file at once. How does it organize these file? As
A command that lets you change one or more fields in a record is
If you want to organize a file in multiple ways, it is better to _____ the data rather than to sort it.
The modify operation is likely to be done after
One data dictionary software package is called
One approach to standardizing storing of data
What software packages are commonly used for businesses that have to track extensive lists of clients and inventory?
A multiple-form file management system
The term _____ is sometimes used to refer to a data file in which all the records have the same record format, that is, the same field names, field lengths, and data types.
A _____ Contains fields of data about one entity.
A condition that led to the development of databases was
The _____ command is used to allocates an extent for the table in SQL
Embedded pointer provide
Which of the following is a type of DBMS software?
Data items grouped together for storage purposes are called a
The activity of a file
Versatile report generators can provide
Related fields in a data base are grouped to form
A _____ means that one record in a particular record type can be related to many records in another record type and vice-versa.
In SQL, the _____ command is used to recompile a view
A list in alphabetical order
If a piece of data is stored in two places in the database, then
A data dictionary is a special file that contains
A file that is organized in uniform format is formally referred to as a _____ or a database file.
A form can be used to
Which language has recently become the de-facto standard for interfacing application programs with relational database system?
In SQL, the CREATE TABLE is used
Which of the following is not true of the traditional approach to information processing?
Batch processing is appropriate if
What is the abbreviation used for a software package that permits the users to create, retrieve and maintain records in a database?
Which of the following is not an advantage of the data-base approach?
A data dictionary doesn't provide information about:
Data encryption techniques are particularly useful for
It is more accurate to define a _____ as a variety of different record types that are treated as a single unit
A logical schema
Queries to a database
In order to use a record management system
In SQL, which command is used to select only one copy of each set of duplicable rows
The physical location of a record is determined by a mathematical formula that transforms a file key into a record location in
Which command is used to select distinct subject (SUB) from the table (BOOK)?
The master list of an indexed file
Which of the following is not the responsibility of the utilities component of DBMS software?
In SQL, which command is used to select data in rows and column from one or more tables?
A scheme describes
A report form
A computer file can be best described as
A good query system
In order to use a DBMS, it is important to understand
In SQL, which command(s) is(are) used to recompile a stored function?
Report generators are used to
Administrate supervision of database activities is the responsibility of the
Goals for the design of the logical schema include
In SQL, which command(s) is(are) used to change a table's storage characteristics?
In SQL, which of the following is not a data definition language commands?
Subschema can be used to
Database management systems are intended to:
In SQL, which command(s) is(are) used to issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements in a single transaction?
In SQL, the command(s) is(are) used to create an index for a table or cluster
There are certain packages that allow people to define data items, place these items in particular records, combine the records into designated files and then manipulate and retrieve the stored data. What are they called?
A _____ DBMS distributes data processing tasks between the workstation and a network server.
Information can be transferred between the DBMS and a
Data integrity control
Which of the following is one of the basic approaches for joining tables?
Which of the following is true concerning systems information in an RDBMS?
The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID
Embedded SQL is which of the following?
A UNION query is which of the following?
Which of the following statements is true concerning subqueries?
Which of the following is a correlated subquery?
How many tables may be included with a join?
The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T ;
Which of the following is true concerning triggers?
What type of join is needed when you wish to include rows that do not have matching values?
What type of join is needed when you wish to return rows that do have matching values?
Which of the following is true concerning a procedure?
A CASE SQL statement is which of the following?
Which of the following statements is true concerning routines and triggers?
The transaction log includes which of the following?
Which of the following could cause data to be unavailable?
A shared lock allows which of the following types of transactions to occur?
Locking may cause which of the following problems?
Performance analysis and tuning is which of the following?
Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?
Which of the following is true concerning open-source DBMS?
Concurrency control is important for which of the following reasons?
Which of the following is the preferred way to recover a database after a system failure?
A data warehouse administrator is concerned with which of the following?
Poor data administration can lead to which of the following?
A traditional data administrator performs which of the following roles?
If both data and database administration exist in an organization, the database administrator is responsible for which of the following?
Which of the following is part of an administrative policy to secure a database?
Backward recovery is which of the following?
Which of the following indicates the minimum number of entities that must be involved in a relationship?
Which of the following refers to something that can be identified in the users' work environment, something that the users want to track?
In which of the following is a single-entity instance of one type related to many entity instances of another type?
Which of the following refers to an entity in which the identifier of one entity includes the identifier of another entity?
Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity?
An attribute that names or identifies entity instances is a(n):
Properties that describe the characteristics of entities are called:
In which of the following can many entity instances of one type be related to many entity instances of another type?
Entities of a given type are grouped into a(n):
Which of the following is NOT a basic element of all versions of the E-R model?
In which of the following is a single-entity instance of one type of related to a single-entity instance of another type?
Entities can be associated with one another in which of the following?
Which type of entity has its relationship to another entity determined by an attribute in that other entity called a discriminator?
Which type of entity represents a logical generalization whose actual occurrence is represented by a second, associated entity?
In a one-to-many relationship, the entity that is on the many side of the relationship is called a(n) ________ entity.
Which of the following indicates the maximum number of entities that can be involved in a relationship?
Which type of entity cannot exist in the database unless another type of entity also exists in the database, but does not require that the identifier of that other entity be included as part of its own identifier?
In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) ________ entity.
Which type of entity represents an actual occurrence of an associated generalized entity?
A recursive relationship is a relationship between an entity and ________ .
Which of the following situation requires the use of ID-dependent entities?
A foreign key is:
Which of the following columns is(are) are required in a table?
In a 1:1 relationship, the foreign key is placed in:
Which of the following column properties would be used to specify that cells in a column must be immediately filled with a monetary value of $10,000?
The identifier of an entity will become the ________ of the new table.
Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table?
A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):
Which is not true about surrogate keys?
For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?
Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?
Each entity is represented as a(n):
For every relationship, how many possible sets of minimum cardinalities are there?
If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.
Which of the following column properties would be used to specify that cells in a column must contain a monetary value that is less than another monetary value in the same row?
Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values?
In a 1:N relationship, the foreign key is placed in:
Which of the following column properties specifies whether or not cells in a column must contain a data value?
A primary key should be defined as:
Which of the following column properties would be used to specify that cells in a column must contain a monetary value?
A snowflake schema is which of the following types of tables?
The generic two-level data warehouse architecture includes which of the following?
Fact tables are which of the following?
Data transformation includes which of the following?
Reconciled data is which of the following?
The load and index is which of the following?
The extract process is which of the following?
A star schema has what type of relationship between a dimension and fact table?
Transient data is which of the following?
A multifield transformation does which of the following?
Data scrubbing is which of the following?
The @active data warehouse architecture includes which of the following?
A goal of data mining includes which of the following?
An operational system is which of the following?
A data warehouse is which of the following?
When assessing the table structure of an acquired set of tables with data, determining foreign keys is (part of) the:
Creating a read-only database is a task that is ________ assigned to beginning database professionals.
Each answer below shows example data from a table. Which answer is an example of the general-purpose remarks column problem?
For a number of reasons, normalizations is not often an advantage for a(n) ________ database.
Most of the time, modification anomalies are serious enough that tables should be normalized into:
Each answer below shows example data from a table. Which answer is an example of the missing values problem?
When assessing the table structure of an acquired set of tables with data, determining functional dependencies is (part of) the:
Each answer below shows example data from a table. Which answer is an example of the multivalue, multicolumn problem?
When assessing the table structure of an acquired set of tables with data, counting the number of table rows is (part of) the:
If a table has been normalized so that all determinants are candidate keys, then that table is in:
Read-only databases are ________ updated.
Needing to assess the validity of assumed referential integrity constraints on foreign keys is a(n) ________ of normalization.
When assessing the table structure of an acquired set of tables with data, determining primary keys is (part of) the:
Normalization ________ data duplication.
Each answer below shows example data from a table. Which answer is an example of the inconsistent values problem?
Needing to using more complicated SQL in database applications is a(n) ________ of normalization.
Eliminating modification anomalies is a(n) ________ of normalization.
Multivalued dependencies should ________ be eliminated.
When assessing the table structure of an acquired set of tables with data, accessing the validity of possible referential integrity constraints on foreign keys is (part of) the:
Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?
RFM analysis uses customers' purchasing patterns to ________ .
The "F" in RFM analysis stands for ________ .
We have Market Basket data for 1,000 rental transactions at a Video Store. There are for videos for rent -- Video A, Video B, Video C and Video D. The probability that both Video C and Video D are rented at the same time is known as ________ .
Business Intelligence (BI) reporting systems cannot do which of the following operations?
Which of the following is not a component of a data warehouse?
Business Intelligence (BI) reporting analyses can be performed using ________ .
We have been given access to the company's operational data, and have been asked to produce a report. We discover that some of the data we need are in an SQL server database while other needed data are in a separate Oracle database. This is an example of ________ .
The reports generated by a reporting system are usually not delivered in which of the following media?
Data mining applications are used accomplish which of the following tasks?
Which of the following is an unsupervised data mining technique?
In OLAP, we are interested in ________ .
Which of the following is not a reason that operational data are difficult to read?
We have Market Basket data for 1,000 rental transactions at a Video Store. There are four videos for rent -- Video A, Video B, Video C and Video D. The probability that Video D will be rented given that Video C has been rented is known as ________ .
One popular classification technique in Business Intelligence (BI) reporting is ________ .
We have done an RFM analysis on our customer data. Mary Jones has a score of "1 1 5". This series means that Mary ________ .
A BI reporting system does not ________ .
Which of the following are not done by Business Intelligence (BI) systems?
Business Intelligence (BI) systems do not obtain their data by which of the following means?
The "curse of dimensionality" relates to which problem of using operational data for BI reporting?
A report generated by a reporting system is delivered to the appropriate users via a user-accessed Web site. This system uses which of the following report modes?
Before any changes to database structure are attempted one should first:
Which of the following modifications may not succeed?
How can you find rows that do not match some specified condition?
A regular subquery can be processed:
What SQL command can be used to add columns to a table?
The EXISTS keyword will be true if:
Changing cardinalities in a database is:
The NOT EXISTS keyword will be true if:
The data model that is produced from reverse engineering is:
To drop a column that is used as a foreign key, first:
What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?
Which is not true of a correlated subquery?
A tool that can help designers understand the dependencies of database structures is a:
How many copies of the database schema are typically used in the redesign process?
Because of the importance of making data model changes correctly, many professionals are ________ about using an automated process for database redesign.
Which of the following SQL statements are helpful in database redesign?
What SQL command can be used to delete columns from a table?
Database redesign is not terribly difficult if the:
Which SQL-92 standard SQL command can be used to change a table name?
The process of reading a database schema and producing a data model from that schema is known as:
Some of the columns of a relation are at different sites is which of the following?
Which of the following is true concerning a global transaction?
A homogenous distributed database is which of the following?
Replication should be used when which of the following exist?
Storing a separate copy of the database at multiple locations is which of the following?
A distributed database is which of the following?
A semijoin is which of the following?
Which of the following is a disadvantage of replication?
A distributed database can use which of the following strategies?
Which of the following is not one of the stages in the evolution of distributed DBMS?
A distributed database has which of the following advantages over a centralized database?
An autonomous homogenous environment is which of the following?
A transaction manager is which of the following?
Location transparency allows for which of the following?
A heterogeneous distributed database is which of the following?
A rectangle represents which of the following in an EER?
Which one of the following symbols is not used in an ERD?
Specialization is which of the following processes?
Which of the following statements concerning business rules is true?
A supertype/subtype hierarchy has which of the following features?
A subtype discriminator is which of the following?
When an entity instance may be a member of multiple subtypes or it does not have to be a member of a subtype, it is which of the following?
A subtype entity name should be which of the following?
Use of a supertype/subtype relationship is necessary when which of the following exists?
Which of the following is not one of the three ways to classify an action assertion?
An action assertion must include which of the following?
An oval represents which of the following in an EER?
Inheritance is which of the following?
When an entity instance must be a member of only one subtype, it is which of the following?
A supertype/subtype hierarchy is which of the following?
Which of the following products was the first to implement true relational algebra in a PC DBMS?
SQL stands for ________ .
Because it contains a description of its own structure, a database is considered to be ________ .
The following are functions of a DBMS except ________ .
Helping people keep track of things is the purpose of a(n) ________ .
Which of the following products implemented the CODASYL DBTG model?
An Enterprise Resource Planning application is an example of a(n) ________ .
A DBMS that combines a DBMS and an application generator is ________ .
You have run an SQL statement that asked the DBMS to display data in a table named USER_TABLES. The results include columns of data labeled "TableName," "NumberOfColumns" and "PrimaryKey." You are looking at ________ .
Which of the following is not considered to be a basic element of an enterprise-class database system?
The DBMS that is most difficult to use is ________ .
The DBMS acts as an interface between what two components of an enterprise-class database system?
Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM?
The following are components of a database except ________ .
An application where only one user accesses the database at a given time is an example of a(n) ________ .
An on-line commercial site such as Amazon.com is an example of a(n) ________ .
A view is which of the following?
The command to eliminate a table from a database is:
ON UPDATE CASCADE ensures which of the following?
SQL data definition commands make up a(n) ________ .
Which of the following is valid SQL for an Index?
The SQL keyword(s) ________ is used with wildcards.
Which of the following is the correct order of keywords for SQL SELECT statements?
A subquery in an SQL SELECT statement is enclosed in:
The result of a SQL SELECT statement is a(n) ________ .
Which of the following are the five built-in functions provided by SQL?
In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
The HAVING clause does which of the following?
The SQL -92 wildcards are ____ and ____ .
To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.
The benefits of a standard relational language include which of the following?
Which of the following do you need to consider when you make a table in SQL?
SQL query and modification commands make up a(n) ________ .
When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
The Microsoft Access wildcards are ____ and ____ .
Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';
Which one of the following sorts rows in SQL?
To sort the results of a query use:
To define what columns should be displayed in an SQL SELECT statement:
SQL can be used to:
The SQL statement that queries or reads data from a table is ________ .
The SQL keyword BETWEEN is used:
A subquery in an SQL SELECT statement:
________ was adopted as a national standard by ANSI in 1992.
SQL is:
You can add a row using SQL in a database with which of the following?
The command to remove rows from a table 'CUSTOMER' is:
The SQL WHERE clause:
Which of the following is the original purpose of SQL?
The wildcard in a WHERE clause is useful when?
________ is an open source DBMS product that runs on UNIX, Linux and Windows.
What is sent to the user via HTTP, invoked using the HTTP protocol on the user's computer, and run on the user's computer as an application?
What MySQL property is used to create a surrogate key in MySQL?
What is not true of a Java bean?
A JSP is transformed into a(n):
Which JDBC driver Type(s) can you use in a three-tier architecture and if the Web server and the DBMS are running on the same machine?
What programming language(s) or scripting language(s) does Java Server Pages (JSP) support?
What servlet processor was developed by Apache Foundation and Sun?
What is bytecode?
What is invoked via HTTP on the Web server computer when it responds to requests from a user's Web browser?
Which JDBC driver Type(s) is(are) the JDBC-ODBC bridge?
How many copies of a JSP page can be in memory at a time?
Which JDBC driver Types are for use over communications networks?
JDBC stands for:
How does Tomcat execute a JSP?
How many JDBC driver types does Sun define?
Where is metadata stored in MySQL?
Who invented Java?
To run a compiled Java program, the machine must have what loaded and running?
Which JDBC driver Type(s) can be used in either applet or servlet code?
When mapping a multivalued attribute into a relation which of the following is true?
If no multivalued attributes exist in a relation, then the relation is in what normal form?
A primary key is which of the following?
The relational model consists of:
When mapping a binary many-to-many relationship into a relation which of the following is true?
A relation has which of the following properties?
When mapping a ternary relationship with an associative entity into a relation which of the following is true?
When mapping a regular entity into a relation which of the following is true?
When mapping a supertype/subtype relationship which of the following is true?
Relations are:
The entity integrity rule states that:
When mapping a many-to-many unary relationship into a relation which of the following is true?
If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?
A foreign key is which of the following?
A transitive dependency is which of the following?
Which of the following is not true of SQL views?
SQL*Plus will finish the statement and execute it when the user types in this:
Which of the following is NOT an Oracle-supported trigger?
After a table has been created, its structure can be modified using the SQL command:
Which of the following is not true about modifying table columns?
Of the three ways to create an Oracle database, which one is the easiest and most recommended?
What Oracle backup and recover file contains user and system data?
When using SQL*Plus, Oracle commands, column names, table names and all other database elements:
Which SQL phrase is not supported by Oracle?
What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?
You have linked SQL*Plus to an external text editor. To invoke the text editor for use within SQL*Plus, which command do you use?
The default extension for an Oracle SQL*Plus file is:
An Oracle System Change Number (SCN):
To obtain the structure of an Oracle table, the command to use is:
To see the contents of the SQL*Plus buffer, type:
What type of failure occurs when Oracle fails due to an operating system or computer hardware failure?
Which statement about sequences is not true?
Which prefixes are available to Oracle triggers?
In creating a procedure, you may get a message if you have compile errors. Which of the following is true?
Which of the following is not true about indexes?
Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction?
The advantage of optimistic locking is that:
Which of the following refers to a cursor type that when the cursor is opened, a primary key value is saved for each row in the recordset; when the application accesses a row, the key is used to fetch the current values of the row?
Which of the following refers to a cursor type where changes of any type and from any source are visible?
Which of the following disallows both dirty reads and nonrepeatable reads, but allows phantom reads?
Dirty read, nonrepeatable, and phantom reads are not possible in this instance.
A transaction in which either all of the database actions occur or none of them do is called:
A cursor type in which the application can only move forward through the recordset is called:
Which of the following occurs when one transaction reads a changed record that has not been committed to the database?
Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur?
Locks placed by command are called ________ .
Which of the following locks the item from change but not from read?
Which of the following occurs when a transaction rereads data and finds new rows that were inserted by a command transaction since the prior read?
A transaction for which all committed changes are permanent is called:
In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed.
A rectangle represents which of the following in an ERD?
An entity name should be which of the following?
An oval represents which of the following in an ERD?
When the minimum and maximum number of instances of an entity is one, you know which of the following?
An attribute name should be which of the following?
A composite attribute is which of the following?
A binary relationship cannot be which of the following?
A ternary relationship involves how many entities?
When the minimum number of instances of an entity is one, you know which of the following?
A good business rule is which of the following?
A binary relationship is which of the following?
If there are two entities with a relationship between them, and one of the entities is completely dependent on the other, then which of the following must exist?
A relationship is which of the following?
Which of the following conditions should exist if you want to convert a relationship to an associative entity?
A good identifier is which of the following?
The term Complete for a UML has the same meaning as which of the following for an EER diagram?
A UML diagram includes which of the following?
An object can have which of the following multiplicities?
Which of the following statement is true concerning objects and/or classes?
Which of the following applies to a class rather than an object?
The benefits of object-oriented modeling are which of the following?
The term Incomplete for a UML has the same meaning as which of the following for an EER diagram?
A constructor operation does which of the following?
Which of the following is a technique for hiding the internal implementation details of an object?
Aggregation is which of the following?
The fact that the same operation may apply to two or more classes is called what?
The object-oriented development life cycle is which of the following?
Multiplicity is the same as what concept for an ERD?
Composition is a stronger form of which of the following?
An abstract class is which of the following?
The object definition language (ODL) is which of the following?
An atomic literal is which of the following?
Which of the following is true concerning an ODBMS?
The reserved word enum is used for which of the following?
Which of the following is an unordered collection of elements that may contain duplicates?
Which of the following is true concerning the following statement: class Manager extends Employee
Which of the following is an ordered collection of elements of the same type?
A relationship should be specified how in the ODL?
Using OQL, you may do which of the following?
The Object Query Language is which of the following"?
ODL supports which of the following types of association relationships?
An extent is which of the following?
Identify the class name for the following code: ABC123 course();
Using ODL, you can define which of the following?
The keyword "inverse" is used in which of the following?
________ is considered to be one of the foundations of data access in the Microsoft world.
________ is an interface by which application programs can access and process SQL databases in a DBMS-independent manner.
Which of the following are goals of OLE DB?
An ODBC data structure that identifies a database and the DBMS that processes it is called a(n):
In OLE DB, actions that an object can perform are called:
In OLE DB, which of the following represents characteristics of the recordset abstraction?
In ODBC, a file that can be shared among database users is called a:
________ is an object-oriented interface that encapsulates data-server functionality.
When using ODBC, which of the following serves as an intermediary between the application and the DBMS drivers?
The ODBC Level 1 API contains which of the following functions?
In OLE DB, a service provider:
In OLE DB, a tabular data provider:
The ODBC Level 2 API contains which the following functions?
In ODBC, a data source that is local to a single computer is called a:
________ is a cover for utilizing OLE DB that is designed for use by almost any language.
ODBC minimum SQL grammar contains which of the following?
When using ODBC, which of the following processes ODBC requests and submits specific SQL statements to a given type of data source?
The ODBC core API consists of which of the following functions?
________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications.
ODBC core SQL grammar contains which of the following?:
The blocking factor is:
Which of the following improves a query's processing time?
Which of the following are integrity controls that a DBMS may support?
Which of the following is not a factor to consider when switching from small to large block size?
What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length?
A secondary key is which of the following?
The fastest read/write time and most efficient data storage of any disk array type is:
A rule of thumb for choosing indexes for a relational database includes which of the following?
Sequential retrieval on a primary key for sequential file storage has which of the following features?
A multidimensional database model is used most often in which of the following models?
To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:
Which of the following is NOT a type of SQL constraint?
A ________ is a program that performs some common action on database data and that is stored in the database.
For what purposes are views used?
What is an SQL virtual table that is constructed from other tables?
What SQL structure is used to limit column values of a table?
Which is NOT one of the most common types of SQL CHECK constraints?
What is an advantage of placing computations in SQL views?
Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:
The SQL command to create a table is:
A ________ is a stored program that is attached to a table or a view.
The DROP TABLE statement:
SQL views can be used to hide:
The SQL statement to create a view is:
Which of the following statements is true about symmetric multiprocessing?
Which of the following items are not necessary for client/server?
A benefit of the three-tier architecture is which of the following?
Which of the following statements is true concerning JDBC?
A characteristic of a file server is which of the following?
Stored procedures have which of the following advantages?
Which of the following statements is a true statement concerning the open database connectivity standard (ODBC)?
Which of the following is true concerning QBE?
Client/server security includes which of the following?
An application program interface (API) is which of the following?
Three-tier architecture includes which of the following?
Which of the following is true concerning the mainframe?
A server cannot serve on which of the following levels?
The three different application logic components are which of the following?
A database server is responsible for which of the following?
Which of the following database activities determines the entities, attributes, and relationships of data?
The use of packaged data models can offer which of the following benefits?
The Enterprise tier of the three-tiered database architecture includes:
An entity type is which of the following?
Strategic Planning factors do not include which of the following?
CASE tools do not include which of the following features?
In enterprise data modeling, which is incorrect?
Which of the following database activities require a specific knowledge of a DBMS?
User views are included as part of which schema?
Whose role is it to determine the requirements and design for a database?
A database application can perform which of the following activities?
An enterprise data model is:
A shared database should:
Data administrators are responsible for:
Which of the following types of databases are the most common?
Which of the following is true for a relational database?
Some advantages of the database approach include all, but:
An enterprise database is which of the following?
Structured data may include which of the following?
An extranet is which of the following?
A data warehouse uses:
Metadata enables database designers and users to do all of the following except:
Duplicate data often results in loss of data integrity because:
Legacy data is which of the following?
A database management system (DBMS) is a:
A server-side extension is needed to do what?
Which of the following is true about ColdFusion Markup Language (CFML)?
XML is which of the following?
An intranet provides which of the following?
Client-side extensions:
Which of the following is true about Microsoft Active Server Pages (ASP)?
Websites without a database attached to them have which of the following characteristics?
Web servers should be configured in which of the following ways?
A proxy server is used for which of the following?
Which of the following is true concerning the standard network protocol for connecting a client to a Web or database server via the Internet?
An intrusion detection system does not perform which of the following?
Features of XML include which of the following?
What is Hypertext Transfer Protocol (HTTP)?
The distinguishable parts of a record are called
Large collections of files are called
The index consists of
A _____ means that one record in a particular record type may be related to more than one record of another record type.
Which command(s) is(are) used to redefine a column of the table in SQL ?
Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL?
In SQL, the ALTER TABLESPACE command is used
The language used in application programs to request data from the DBMS is referred to as the
In SQL, which command(s) is(are) used to create a synonym for a schema object?
If you want your database to include methods, you should use a _____ database.
In SQL, which of the following is not a data Manipulation Language Commands?
Which of the following is not characteristic of a relational database model?
A computer file contains several records. What does each record contain?
In SQL, the CREATE VIEW command is used
A ____ Contains the smallest unit of meaningful data, so you might call it the basic building block for a data file.
In the DBM approach, application programs perform the
In SQL, which command is used to create a database user?
When performing a look-up operation using a form
A _____ means that one record in a particular record type is related to only one record of another record type.
A _____ database does not use pointers or physical links, but instead finds related records by examining the contents of fields.
In SQL, which command(s) is(are) used to redefine an index's future storage allocation
Which of the following is a serious problem of file management systems?
With respect to data input, the most accurate description of batch control is
The model for a _____ resembles the hierarchical model in many respects.
A set of programs that handle a firm's data base responsibilities is called a
In any hierarchy of data organization, the smallest entity to be processed as a single unit is called
Long-range planning report produced in an MIS are primarily designed for
The model for a record management system might be
The designer of a form includes
Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?
Two files may be joined into a third file if
Characteristic(s) of a distributed MIS structure is
The data-base environment has all of the following components except:
Data security threats include
An operation that will increase the length of a list is
In SQL, which command is used to add a column/integrity constraint to a table
In a relational schema, each tuple is divided into fields called
In SQL, the CREATE TABLESPACE is used
In SQL, which command is used to remove a stored function from the database?
The database administration function includes
A relational database management (RDBM) package manages data in more than one file at once. How does it organize these file? As
A command that lets you change one or more fields in a record is
If you want to organize a file in multiple ways, it is better to _____ the data rather than to sort it.
The modify operation is likely to be done after
One data dictionary software package is called
One approach to standardizing storing of data
What software packages are commonly used for businesses that have to track extensive lists of clients and inventory?
A multiple-form file management system
The term _____ is sometimes used to refer to a data file in which all the records have the same record format, that is, the same field names, field lengths, and data types.
A _____ Contains fields of data about one entity.
A condition that led to the development of databases was
The _____ command is used to allocates an extent for the table in SQL
Embedded pointer provide
Which of the following is a type of DBMS software?
Data items grouped together for storage purposes are called a
The activity of a file
Versatile report generators can provide
Related fields in a data base are grouped to form
A _____ means that one record in a particular record type can be related to many records in another record type and vice-versa.
In SQL, the _____ command is used to recompile a view
A list in alphabetical order
If a piece of data is stored in two places in the database, then
A data dictionary is a special file that contains
A file that is organized in uniform format is formally referred to as a _____ or a database file.
A form can be used to
Which language has recently become the de-facto standard for interfacing application programs with relational database system?
In SQL, the CREATE TABLE is used
Which of the following is not true of the traditional approach to information processing?
Batch processing is appropriate if
What is the abbreviation used for a software package that permits the users to create, retrieve and maintain records in a database?
Which of the following is not an advantage of the data-base approach?
A data dictionary doesn't provide information about:
Data encryption techniques are particularly useful for
It is more accurate to define a _____ as a variety of different record types that are treated as a single unit
A logical schema
Queries to a database
In order to use a record management system
In SQL, which command is used to select only one copy of each set of duplicable rows
The physical location of a record is determined by a mathematical formula that transforms a file key into a record location in
Which command is used to select distinct subject (SUB) from the table (BOOK)?
The master list of an indexed file
Which of the following is not the responsibility of the utilities component of DBMS software?
In SQL, which command is used to select data in rows and column from one or more tables?
A scheme describes
A report form
A computer file can be best described as
A good query system
In order to use a DBMS, it is important to understand
In SQL, which command(s) is(are) used to recompile a stored function?
Report generators are used to
Administrate supervision of database activities is the responsibility of the
Goals for the design of the logical schema include
In SQL, which command(s) is(are) used to change a table's storage characteristics?
In SQL, which of the following is not a data definition language commands?
Subschema can be used to
Database management systems are intended to:
In SQL, which command(s) is(are) used to issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements in a single transaction?
In SQL, the command(s) is(are) used to create an index for a table or cluster
There are certain packages that allow people to define data items, place these items in particular records, combine the records into designated files and then manipulate and retrieve the stored data. What are they called?
A _____ DBMS distributes data processing tasks between the workstation and a network server.
Information can be transferred between the DBMS and a
Data integrity control
Which of the following is one of the basic approaches for joining tables?
Which of the following is true concerning systems information in an RDBMS?
The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID
Embedded SQL is which of the following?
A UNION query is which of the following?
Which of the following statements is true concerning subqueries?
Which of the following is a correlated subquery?
How many tables may be included with a join?
The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T ;
Which of the following is true concerning triggers?
What type of join is needed when you wish to include rows that do not have matching values?
What type of join is needed when you wish to return rows that do have matching values?
Which of the following is true concerning a procedure?
A CASE SQL statement is which of the following?
Which of the following statements is true concerning routines and triggers?
The transaction log includes which of the following?
Which of the following could cause data to be unavailable?
A shared lock allows which of the following types of transactions to occur?
Locking may cause which of the following problems?
Performance analysis and tuning is which of the following?
Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?
Which of the following is true concerning open-source DBMS?
Concurrency control is important for which of the following reasons?
Which of the following is the preferred way to recover a database after a system failure?
A data warehouse administrator is concerned with which of the following?
Poor data administration can lead to which of the following?
A traditional data administrator performs which of the following roles?
If both data and database administration exist in an organization, the database administrator is responsible for which of the following?
Which of the following is part of an administrative policy to secure a database?
Backward recovery is which of the following?
Which of the following indicates the minimum number of entities that must be involved in a relationship?
Which of the following refers to something that can be identified in the users' work environment, something that the users want to track?
In which of the following is a single-entity instance of one type related to many entity instances of another type?
Which of the following refers to an entity in which the identifier of one entity includes the identifier of another entity?
Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity?
An attribute that names or identifies entity instances is a(n):
Properties that describe the characteristics of entities are called:
In which of the following can many entity instances of one type be related to many entity instances of another type?
Entities of a given type are grouped into a(n):
Which of the following is NOT a basic element of all versions of the E-R model?
In which of the following is a single-entity instance of one type of related to a single-entity instance of another type?
Entities can be associated with one another in which of the following?
Which type of entity has its relationship to another entity determined by an attribute in that other entity called a discriminator?
Which type of entity represents a logical generalization whose actual occurrence is represented by a second, associated entity?
In a one-to-many relationship, the entity that is on the many side of the relationship is called a(n) ________ entity.
Which of the following indicates the maximum number of entities that can be involved in a relationship?
Which type of entity cannot exist in the database unless another type of entity also exists in the database, but does not require that the identifier of that other entity be included as part of its own identifier?
In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) ________ entity.
Which type of entity represents an actual occurrence of an associated generalized entity?
A recursive relationship is a relationship between an entity and ________ .
Which of the following situation requires the use of ID-dependent entities?
A foreign key is:
Which of the following columns is(are) are required in a table?
In a 1:1 relationship, the foreign key is placed in:
Which of the following column properties would be used to specify that cells in a column must be immediately filled with a monetary value of $10,000?
The identifier of an entity will become the ________ of the new table.
Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table?
A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):
Which is not true about surrogate keys?
For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?
Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?
Each entity is represented as a(n):
For every relationship, how many possible sets of minimum cardinalities are there?
If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.
Which of the following column properties would be used to specify that cells in a column must contain a monetary value that is less than another monetary value in the same row?
Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values?
In a 1:N relationship, the foreign key is placed in:
Which of the following column properties specifies whether or not cells in a column must contain a data value?
A primary key should be defined as:
Which of the following column properties would be used to specify that cells in a column must contain a monetary value?
A snowflake schema is which of the following types of tables?
The generic two-level data warehouse architecture includes which of the following?
Fact tables are which of the following?
Data transformation includes which of the following?
Reconciled data is which of the following?
The load and index is which of the following?
The extract process is which of the following?
A star schema has what type of relationship between a dimension and fact table?
Transient data is which of the following?
A multifield transformation does which of the following?
Data scrubbing is which of the following?
The @active data warehouse architecture includes which of the following?
A goal of data mining includes which of the following?
An operational system is which of the following?
A data warehouse is which of the following?
When assessing the table structure of an acquired set of tables with data, determining foreign keys is (part of) the:
Creating a read-only database is a task that is ________ assigned to beginning database professionals.
Each answer below shows example data from a table. Which answer is an example of the general-purpose remarks column problem?
For a number of reasons, normalizations is not often an advantage for a(n) ________ database.
Most of the time, modification anomalies are serious enough that tables should be normalized into:
Each answer below shows example data from a table. Which answer is an example of the missing values problem?
When assessing the table structure of an acquired set of tables with data, determining functional dependencies is (part of) the:
Each answer below shows example data from a table. Which answer is an example of the multivalue, multicolumn problem?
When assessing the table structure of an acquired set of tables with data, counting the number of table rows is (part of) the:
If a table has been normalized so that all determinants are candidate keys, then that table is in:
Read-only databases are ________ updated.
Needing to assess the validity of assumed referential integrity constraints on foreign keys is a(n) ________ of normalization.
When assessing the table structure of an acquired set of tables with data, determining primary keys is (part of) the:
Normalization ________ data duplication.
Each answer below shows example data from a table. Which answer is an example of the inconsistent values problem?
Needing to using more complicated SQL in database applications is a(n) ________ of normalization.
Eliminating modification anomalies is a(n) ________ of normalization.
Multivalued dependencies should ________ be eliminated.
When assessing the table structure of an acquired set of tables with data, accessing the validity of possible referential integrity constraints on foreign keys is (part of) the:
Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?
RFM analysis uses customers' purchasing patterns to ________ .
The "F" in RFM analysis stands for ________ .
We have Market Basket data for 1,000 rental transactions at a Video Store. There are for videos for rent -- Video A, Video B, Video C and Video D. The probability that both Video C and Video D are rented at the same time is known as ________ .
Business Intelligence (BI) reporting systems cannot do which of the following operations?
Which of the following is not a component of a data warehouse?
Business Intelligence (BI) reporting analyses can be performed using ________ .
We have been given access to the company's operational data, and have been asked to produce a report. We discover that some of the data we need are in an SQL server database while other needed data are in a separate Oracle database. This is an example of ________ .
The reports generated by a reporting system are usually not delivered in which of the following media?
Data mining applications are used accomplish which of the following tasks?
Which of the following is an unsupervised data mining technique?
In OLAP, we are interested in ________ .
Which of the following is not a reason that operational data are difficult to read?
We have Market Basket data for 1,000 rental transactions at a Video Store. There are four videos for rent -- Video A, Video B, Video C and Video D. The probability that Video D will be rented given that Video C has been rented is known as ________ .
One popular classification technique in Business Intelligence (BI) reporting is ________ .
We have done an RFM analysis on our customer data. Mary Jones has a score of "1 1 5". This series means that Mary ________ .
A BI reporting system does not ________ .
Which of the following are not done by Business Intelligence (BI) systems?
Business Intelligence (BI) systems do not obtain their data by which of the following means?
The "curse of dimensionality" relates to which problem of using operational data for BI reporting?
A report generated by a reporting system is delivered to the appropriate users via a user-accessed Web site. This system uses which of the following report modes?
Before any changes to database structure are attempted one should first:
Which of the following modifications may not succeed?
How can you find rows that do not match some specified condition?
A regular subquery can be processed:
What SQL command can be used to add columns to a table?
The EXISTS keyword will be true if:
Changing cardinalities in a database is:
The NOT EXISTS keyword will be true if:
The data model that is produced from reverse engineering is:
To drop a column that is used as a foreign key, first:
What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?
Which is not true of a correlated subquery?
A tool that can help designers understand the dependencies of database structures is a:
How many copies of the database schema are typically used in the redesign process?
Because of the importance of making data model changes correctly, many professionals are ________ about using an automated process for database redesign.
Which of the following SQL statements are helpful in database redesign?
What SQL command can be used to delete columns from a table?
Database redesign is not terribly difficult if the:
Which SQL-92 standard SQL command can be used to change a table name?
The process of reading a database schema and producing a data model from that schema is known as:
Some of the columns of a relation are at different sites is which of the following?
Which of the following is true concerning a global transaction?
A homogenous distributed database is which of the following?
Replication should be used when which of the following exist?
Storing a separate copy of the database at multiple locations is which of the following?
A distributed database is which of the following?
A semijoin is which of the following?
Which of the following is a disadvantage of replication?
A distributed database can use which of the following strategies?
Which of the following is not one of the stages in the evolution of distributed DBMS?
A distributed database has which of the following advantages over a centralized database?
An autonomous homogenous environment is which of the following?
A transaction manager is which of the following?
Location transparency allows for which of the following?
A heterogeneous distributed database is which of the following?
A rectangle represents which of the following in an EER?
Which one of the following symbols is not used in an ERD?
Specialization is which of the following processes?
Which of the following statements concerning business rules is true?
A supertype/subtype hierarchy has which of the following features?
A subtype discriminator is which of the following?
When an entity instance may be a member of multiple subtypes or it does not have to be a member of a subtype, it is which of the following?
A subtype entity name should be which of the following?
Use of a supertype/subtype relationship is necessary when which of the following exists?
Which of the following is not one of the three ways to classify an action assertion?
An action assertion must include which of the following?
An oval represents which of the following in an EER?
Inheritance is which of the following?
When an entity instance must be a member of only one subtype, it is which of the following?
A supertype/subtype hierarchy is which of the following?
Which of the following products was the first to implement true relational algebra in a PC DBMS?
SQL stands for ________ .
Because it contains a description of its own structure, a database is considered to be ________ .
The following are functions of a DBMS except ________ .
Helping people keep track of things is the purpose of a(n) ________ .
Which of the following products implemented the CODASYL DBTG model?
An Enterprise Resource Planning application is an example of a(n) ________ .
A DBMS that combines a DBMS and an application generator is ________ .
You have run an SQL statement that asked the DBMS to display data in a table named USER_TABLES. The results include columns of data labeled "TableName," "NumberOfColumns" and "PrimaryKey." You are looking at ________ .
Which of the following is not considered to be a basic element of an enterprise-class database system?
The DBMS that is most difficult to use is ________ .
The DBMS acts as an interface between what two components of an enterprise-class database system?
Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM?
The following are components of a database except ________ .
An application where only one user accesses the database at a given time is an example of a(n) ________ .
An on-line commercial site such as Amazon.com is an example of a(n) ________ .
A view is which of the following?
The command to eliminate a table from a database is:
ON UPDATE CASCADE ensures which of the following?
SQL data definition commands make up a(n) ________ .
Which of the following is valid SQL for an Index?
The SQL keyword(s) ________ is used with wildcards.
Which of the following is the correct order of keywords for SQL SELECT statements?
A subquery in an SQL SELECT statement is enclosed in:
The result of a SQL SELECT statement is a(n) ________ .
Which of the following are the five built-in functions provided by SQL?
In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
The HAVING clause does which of the following?
The SQL -92 wildcards are ____ and ____ .
To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.
The benefits of a standard relational language include which of the following?
Which of the following do you need to consider when you make a table in SQL?
SQL query and modification commands make up a(n) ________ .
When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
The Microsoft Access wildcards are ____ and ____ .
Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';
Which one of the following sorts rows in SQL?
To sort the results of a query use:
To define what columns should be displayed in an SQL SELECT statement:
SQL can be used to:
The SQL statement that queries or reads data from a table is ________ .
The SQL keyword BETWEEN is used:
A subquery in an SQL SELECT statement:
________ was adopted as a national standard by ANSI in 1992.
SQL is:
You can add a row using SQL in a database with which of the following?
The command to remove rows from a table 'CUSTOMER' is:
The SQL WHERE clause:
Which of the following is the original purpose of SQL?
The wildcard in a WHERE clause is useful when?
________ is an open source DBMS product that runs on UNIX, Linux and Windows.
What is sent to the user via HTTP, invoked using the HTTP protocol on the user's computer, and run on the user's computer as an application?
What MySQL property is used to create a surrogate key in MySQL?
What is not true of a Java bean?
A JSP is transformed into a(n):
Which JDBC driver Type(s) can you use in a three-tier architecture and if the Web server and the DBMS are running on the same machine?
What programming language(s) or scripting language(s) does Java Server Pages (JSP) support?
What servlet processor was developed by Apache Foundation and Sun?
What is bytecode?
What is invoked via HTTP on the Web server computer when it responds to requests from a user's Web browser?
Which JDBC driver Type(s) is(are) the JDBC-ODBC bridge?
How many copies of a JSP page can be in memory at a time?
Which JDBC driver Types are for use over communications networks?
JDBC stands for:
How does Tomcat execute a JSP?
How many JDBC driver types does Sun define?
Where is metadata stored in MySQL?
Who invented Java?
To run a compiled Java program, the machine must have what loaded and running?
Which JDBC driver Type(s) can be used in either applet or servlet code?
When mapping a multivalued attribute into a relation which of the following is true?
If no multivalued attributes exist in a relation, then the relation is in what normal form?
A primary key is which of the following?
The relational model consists of:
When mapping a binary many-to-many relationship into a relation which of the following is true?
A relation has which of the following properties?
When mapping a ternary relationship with an associative entity into a relation which of the following is true?
When mapping a regular entity into a relation which of the following is true?
When mapping a supertype/subtype relationship which of the following is true?
Relations are:
The entity integrity rule states that:
When mapping a many-to-many unary relationship into a relation which of the following is true?
If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?
A foreign key is which of the following?
A transitive dependency is which of the following?
Which of the following is not true of SQL views?
SQL*Plus will finish the statement and execute it when the user types in this:
Which of the following is NOT an Oracle-supported trigger?
After a table has been created, its structure can be modified using the SQL command:
Which of the following is not true about modifying table columns?
Of the three ways to create an Oracle database, which one is the easiest and most recommended?
What Oracle backup and recover file contains user and system data?
When using SQL*Plus, Oracle commands, column names, table names and all other database elements:
Which SQL phrase is not supported by Oracle?
What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?
You have linked SQL*Plus to an external text editor. To invoke the text editor for use within SQL*Plus, which command do you use?
The default extension for an Oracle SQL*Plus file is:
An Oracle System Change Number (SCN):
To obtain the structure of an Oracle table, the command to use is:
To see the contents of the SQL*Plus buffer, type:
What type of failure occurs when Oracle fails due to an operating system or computer hardware failure?
Which statement about sequences is not true?
Which prefixes are available to Oracle triggers?
In creating a procedure, you may get a message if you have compile errors. Which of the following is true?
Which of the following is not true about indexes?
Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction?
The advantage of optimistic locking is that:
Which of the following refers to a cursor type that when the cursor is opened, a primary key value is saved for each row in the recordset; when the application accesses a row, the key is used to fetch the current values of the row?
Which of the following refers to a cursor type where changes of any type and from any source are visible?
Which of the following disallows both dirty reads and nonrepeatable reads, but allows phantom reads?
Dirty read, nonrepeatable, and phantom reads are not possible in this instance.
A transaction in which either all of the database actions occur or none of them do is called:
A cursor type in which the application can only move forward through the recordset is called:
Which of the following occurs when one transaction reads a changed record that has not been committed to the database?
Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur?
Locks placed by command are called ________ .
Which of the following locks the item from change but not from read?
Which of the following occurs when a transaction rereads data and finds new rows that were inserted by a command transaction since the prior read?
A transaction for which all committed changes are permanent is called:
In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed.
A rectangle represents which of the following in an ERD?
An entity name should be which of the following?
An oval represents which of the following in an ERD?
When the minimum and maximum number of instances of an entity is one, you know which of the following?
An attribute name should be which of the following?
A composite attribute is which of the following?
A binary relationship cannot be which of the following?
A ternary relationship involves how many entities?
When the minimum number of instances of an entity is one, you know which of the following?
A good business rule is which of the following?
A binary relationship is which of the following?
If there are two entities with a relationship between them, and one of the entities is completely dependent on the other, then which of the following must exist?
A relationship is which of the following?
Which of the following conditions should exist if you want to convert a relationship to an associative entity?
A good identifier is which of the following?
The term Complete for a UML has the same meaning as which of the following for an EER diagram?
A UML diagram includes which of the following?
An object can have which of the following multiplicities?
Which of the following statement is true concerning objects and/or classes?
Which of the following applies to a class rather than an object?
The benefits of object-oriented modeling are which of the following?
The term Incomplete for a UML has the same meaning as which of the following for an EER diagram?
A constructor operation does which of the following?
Which of the following is a technique for hiding the internal implementation details of an object?
Aggregation is which of the following?
The fact that the same operation may apply to two or more classes is called what?
The object-oriented development life cycle is which of the following?
Multiplicity is the same as what concept for an ERD?
Composition is a stronger form of which of the following?
An abstract class is which of the following?
The object definition language (ODL) is which of the following?
An atomic literal is which of the following?
Which of the following is true concerning an ODBMS?
The reserved word enum is used for which of the following?
Which of the following is an unordered collection of elements that may contain duplicates?
Which of the following is true concerning the following statement: class Manager extends Employee
Which of the following is an ordered collection of elements of the same type?
A relationship should be specified how in the ODL?
Using OQL, you may do which of the following?
The Object Query Language is which of the following"?
ODL supports which of the following types of association relationships?
An extent is which of the following?
Identify the class name for the following code: ABC123 course();
Using ODL, you can define which of the following?
The keyword "inverse" is used in which of the following?
________ is considered to be one of the foundations of data access in the Microsoft world.
________ is an interface by which application programs can access and process SQL databases in a DBMS-independent manner.
Which of the following are goals of OLE DB?
An ODBC data structure that identifies a database and the DBMS that processes it is called a(n):
In OLE DB, actions that an object can perform are called:
In OLE DB, which of the following represents characteristics of the recordset abstraction?
In ODBC, a file that can be shared among database users is called a:
________ is an object-oriented interface that encapsulates data-server functionality.
When using ODBC, which of the following serves as an intermediary between the application and the DBMS drivers?
The ODBC Level 1 API contains which of the following functions?
In OLE DB, a service provider:
In OLE DB, a tabular data provider:
The ODBC Level 2 API contains which the following functions?
In ODBC, a data source that is local to a single computer is called a:
________ is a cover for utilizing OLE DB that is designed for use by almost any language.
ODBC minimum SQL grammar contains which of the following?
When using ODBC, which of the following processes ODBC requests and submits specific SQL statements to a given type of data source?
The ODBC core API consists of which of the following functions?
________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications.
ODBC core SQL grammar contains which of the following?:
The blocking factor is:
Which of the following improves a query's processing time?
Which of the following are integrity controls that a DBMS may support?
Which of the following is not a factor to consider when switching from small to large block size?
What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length?
A secondary key is which of the following?
The fastest read/write time and most efficient data storage of any disk array type is:
A rule of thumb for choosing indexes for a relational database includes which of the following?
Sequential retrieval on a primary key for sequential file storage has which of the following features?
A multidimensional database model is used most often in which of the following models?
To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:
Which of the following is NOT a type of SQL constraint?
A ________ is a program that performs some common action on database data and that is stored in the database.
For what purposes are views used?
What is an SQL virtual table that is constructed from other tables?
What SQL structure is used to limit column values of a table?
Which is NOT one of the most common types of SQL CHECK constraints?
What is an advantage of placing computations in SQL views?
Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:
The SQL command to create a table is:
A ________ is a stored program that is attached to a table or a view.
The DROP TABLE statement:
SQL views can be used to hide:
The SQL statement to create a view is:
Which of the following statements is true about symmetric multiprocessing?
Which of the following items are not necessary for client/server?
A benefit of the three-tier architecture is which of the following?
Which of the following statements is true concerning JDBC?
A characteristic of a file server is which of the following?
Stored procedures have which of the following advantages?
Which of the following statements is a true statement concerning the open database connectivity standard (ODBC)?
Which of the following is true concerning QBE?
Client/server security includes which of the following?
An application program interface (API) is which of the following?
Three-tier architecture includes which of the following?
Which of the following is true concerning the mainframe?
A server cannot serve on which of the following levels?
The three different application logic components are which of the following?
A database server is responsible for which of the following?
Which of the following database activities determines the entities, attributes, and relationships of data?
The use of packaged data models can offer which of the following benefits?
The Enterprise tier of the three-tiered database architecture includes:
An entity type is which of the following?
Strategic Planning factors do not include which of the following?
CASE tools do not include which of the following features?
In enterprise data modeling, which is incorrect?
Which of the following database activities require a specific knowledge of a DBMS?
User views are included as part of which schema?
Whose role is it to determine the requirements and design for a database?
A database application can perform which of the following activities?
An enterprise data model is:
A shared database should:
Data administrators are responsible for:
Which of the following types of databases are the most common?
Which of the following is true for a relational database?
Some advantages of the database approach include all, but:
An enterprise database is which of the following?
Structured data may include which of the following?
An extranet is which of the following?
A data warehouse uses:
Metadata enables database designers and users to do all of the following except:
Duplicate data often results in loss of data integrity because:
Legacy data is which of the following?
A database management system (DBMS) is a:
A server-side extension is needed to do what?
Which of the following is true about ColdFusion Markup Language (CFML)?
XML is which of the following?
An intranet provides which of the following?
Client-side extensions:
Which of the following is true about Microsoft Active Server Pages (ASP)?
Websites without a database attached to them have which of the following characteristics?
Web servers should be configured in which of the following ways?
A proxy server is used for which of the following?
Which of the following is true concerning the standard network protocol for connecting a client to a Web or database server via the Internet?
An intrusion detection system does not perform which of the following?
Features of XML include which of the following?
What is Hypertext Transfer Protocol (HTTP)?
No comments:
Post a Comment