Question 1

The architecture of a DBMS is represented by the ____ and structures used to manage a database.

Accepted Answer

A) tables 
B) queries 
C) processes 
D) Logs 
A) tables 
B) queries 
C) processes 
D) Logs C

Question 2

Which type of entity represents a logical generalization whose actual occurrence is represented by a second, associated entity?

Accepted Answer

A) Supertype entity 
B) Subtype entity 
C) Archetype entity 
D) Instance entity 
A) Supertype entity 
B) Subtype entity 
C) Archetype entity 
D) Instance entity C

Question 3

The transaction log includes which of the following?

Accepted Answer

A) The before-image of a record 
B) The after-image of a record 
C) The before and after-image of a record 
D) The essential data of the record 
A) The before-image of a record 
B) The after-image of a record 
C) The before and after-image of a record 
D) The essential data of the record D

Question 4

When creating a database, in order to optimize performance, put high-usage tables in their own ____.

Accepted Answer

A) data caches 
B) data spaces 
C) table caches 
D) table spaces 
A) data caches 
B) data spaces 
C) table caches 
D) table spaces

Question 5

Which of the following is not true of SQL views?

Accepted Answer

A) Oracle views cannot use the ORDER BY clause in view definitions. 
B) Oracle views are created using the standard SQL-92 CREATE VIEW command. 
C) Oracle views can by queri 
A) Oracle views cannot use the ORDER BY clause in view definitions. 
B) Oracle views are created using the standard SQL-92 CREATE VIEW command. 
C) Oracle views can by queri

Question 6

Concurrency control is important for which of the following reasons?

Accepted Answer

A) To ensure data integrity when updates occur to the database in a multiuser environment 
B) To ensure data integrity when updates occur to the database in a single-user environment 
C) To ensure data integrity while reading data occurs to the database in a multiuser environment 
D) To ensure data integrity while reading data occurs to the database in a single-user environment 
A) To ensure data integrity when updates occur to the database in a multiuser environment 
B) To ensure data integrity when updates occur to the database in a single-user environment 
C) To ensure data integrity while reading data occurs to the database in a multiuser environment 
D) To ensure data integrity while reading data occurs to the database in a single-user environment

Question 7

The DBMS processes queries in three phases; the first is ____.

Accepted Answer

A) parsing 
B) analyzing 
C) execution 
D) fetching 
A) parsing 
B) analyzing 
C) execution 
D) fetching

Question 8

Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?

Accepted Answer

A) Rollback 
B) Rollforward 
C) Switch to duplicate database 
D) Reprocess transactions 
A) Rollback 
B) Rollforward 
C) Switch to duplicate database 
D) Reprocess transactions

Question 9

Generally, what will provide the best database client performance in terms of CPU speed?

Accepted Answer

A) single processor 
B) multiple processors 
C) the slowest processor 
D) the fastest processor 
A) single processor 
B) multiple processors 
C) the slowest processor 
D) the fastest processor

Question 10

Which of the following is not a procedural language?

Accepted Answer

A) Relational Algebra 
B) SQL 
C) Relational calculus 
D) None of the above 
A) Relational Algebra 
B) SQL 
C) Relational calculus 
D) None of the above

Question 11

Working with data in the data cache is many times faster than working with data in the data files because ____.

Accepted Answer

A) there is no network access involved 
B) the DBMS doesn't have to wait for the hard disk to retrieve the data 
C) the DBMS can optimize queries against the cache 
D) the data cache contains only a few records from each table 
A) there is no network access involved 
B) the DBMS doesn't have to wait for the hard disk to retrieve the data 
C) the DBMS can optimize queries against the cache 
D) the data cache contains only a few records from each table

Question 12

Who developed QBE?

Accepted Answer

A) C.J. Date 
B) E.F. Codd 
C) M.M. Zloof 
D) None of the above 
A) C.J. Date 
B) E.F. Codd 
C) M.M. Zloof 
D) None of the above

Question 13

Which of the following is IBM's first RDBMS?

Accepted Answer

A) DB2 
B) IMS 
C) SQL/DS 
D) None of the above 
A) DB2 
B) IMS 
C) SQL/DS 
D) None of the above

Question 14

Database statistics are stored in the system catalog in specially designated ____.

Accepted Answer

A) indexes 
B) rows 
C) table spaces 
D) Tables 
A) indexes 
B) rows 
C) table spaces 
D) Tables

Question 15

Who developed Structured English Query Language?

Accepted Answer

A) E.F. Codd 
B) D. Chamberlain 
C) Chris Date 
D) None of the above 
A) E.F. Codd 
B) D. Chamberlain 
C) Chris Date 
D) None of the above

Question 16

To optimize queries, use simple columns or literals as operands in a conditional expression and avoid the use of conditional expressions with ____ whenever possible.

Accepted Answer

A) the WHERE clause 
B) functions 
C) the GROUP BY clause 
D) Indexes 
A) the WHERE clause 
B) functions 
C) the GROUP BY clause 
D) Indexes

Question 17

What is the expansion of QBE?

Accepted Answer

A) Query by Example 
B) Query by Experiment 
C) Question before evaluation 
D) None of the above 
A) Query by Example 
B) Query by Experiment 
C) Question before evaluation 
D) None of the above

Question 18

Which of the following is the operation that is used if we are interested in only certain attributes or columns of a table?

Accepted Answer

A) SELECT 
B) PROJECT 
C) UNION 
D) JOIN 
A) SELECT 
B) PROJECT 
C) UNION 
D) JOIN

Question 19

The majority of current database performance problems are related to ____.

Accepted Answer

A) not having enough memory on the database server 
B) poorly written SQL code 
C) improper use of table space 
D) old statistics 
A) not having enough memory on the database server 
B) poorly written SQL code 
C) improper use of table space 
D) old statistics

The architecture of a DBMS is represented by the ____ and structures used to manage a database.

Which type of entity represents a logical generalization whose actual occurrence is represented by a second, associated entity?

The transaction log includes which of the following?

When creating a database, in order to optimize performance, put high-usage tables in their own ____.

Which of the following is not true of SQL views?

Concurrency control is important for which of the following reasons?

The DBMS processes queries in three phases; the first is ____.

Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?

Generally, what will provide the best database client performance in terms of CPU speed?

Which of the following is not a procedural language?

Working with data in the data cache is many times faster than working with data in the data files because ____.

Who developed QBE?

Which of the following is IBM's first RDBMS?

Database statistics are stored in the system catalog in specially designated ____.

Who developed Structured English Query Language?

To optimize queries, use simple columns or literals as operands in a conditional expression and avoid the use of conditional expressions with ____ whenever possible.

What is the expansion of QBE?

Which of the following is the operation that is used if we are interested in only certain attributes or columns of a table?

The majority of current database performance problems are related to ____.

Database Management System DBMS: Part A

Database Management and Data Mining

Database Management System: Relational Model and Operations

Oracle Backup, Distributed Databases, and SQL Commands

Filters

Exam 2: Database Management System DBMS: Part B

The architecture of a DBMS is represented by the ____ and structures used to manage a database.

Which type of entity represents a logical generalization whose actual occurrence is represented by a second, associated entity?

The transaction log includes which of the following?

When creating a database, in order to optimize performance, put high-usage tables in their own ____.

Which of the following is not true of SQL views?

Concurrency control is important for which of the following reasons?

The DBMS processes queries in three phases; the first is ____.

Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?

Generally, what will provide the best database client performance in terms of CPU speed?

Which of the following is not a procedural language?

Working with data in the data cache is many times faster than working with data in the data files because ____.

Who developed QBE?

Which of the following is IBM's first RDBMS?

Database statistics are stored in the system catalog in specially designated ____.

Who developed Structured English Query Language?

To optimize queries, use simple columns or literals as operands in a conditional expression and avoid the use of conditional expressions with ____ whenever possible.

What is the expansion of QBE?

Which of the following is the operation that is used if we are interested in only certain attributes or columns of a table?

The majority of current database performance problems are related to ____.

Database Management System DBMS: Part A

Database Management and Data Mining

Database Management System: Relational Model and Operations

Oracle Backup, Distributed Databases, and SQL Commands

Filters