Question 1

Which of the following is the operation that is used if we are interested in only certain attributes or columns of a table?
A)SELECT
B)PROJECT
C)UNION
D)JOIN

Accepted Answer

The PROJECT operation in relational database management systems is used to select certain attributes or columns from a table, excluding others. This operation allows for the specification of which attributes (columns) of a table should be included in the result, effectively focusing on the vertical aspect of a table.

Question 2

Which of the following is not a procedural language?
A)Relational Algebra
B)SQL
C)Relational calculus
D)None of the above

Accepted Answer

C

Question 3

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

Accepted Answer

M.M. Zloof at IBM's Research Laboratory developed Query By Example (QBE) in the 1970s as a method to simplify the construction of database queries.

Question 4

What is the expansion of QBE?
A)Query by Example
B)Query by Experiment
C)Question before evaluation
D)None of the above

Accepted Answer

Query by Example (QBE) is a database query language for relational databases. It allows users to search for data by providing a sample or example of the data they are looking for, rather than writing a complex query.

Question 5

Who developed Structured English Query Language?
A)E.F. Codd
B)D. Chamberlain
C)Chris Date
D)None of the above

Accepted Answer

Donald D. Chamberlain was one of the key developers of SQL (Structured Query Language), which was initially developed at IBM.

Question 6

Which of the following is IBM's first RDBMS?
A)DB2
B)IMS
C)SQL/DS
D)None of the above

Accepted Answer

SQL/DS (Structured Query Language/Data System) was IBM's first RDBMS, introduced in 1981, predating DB2 which was released in 1983. IMS, on the other hand, is a hierarchical database management system, not a relational one.

Question 7

The DBMS processes queries in three phases; the first is ____.
A)parsing
B)analyzing
C)execution
D)fetching

Accepted Answer

The first phase in processing queries by a DBMS is parsing, where the query is checked for syntactical correctness and converted into a format that can be understood by the DBMS.

Question 8

Generally, what will provide the best database client performance in terms of CPU speed?
A)single processor
B)multiple processors
C)the slowest processor
D)the fastest processor

Accepted Answer

The fastest processor generally provides the best database client performance in terms of CPU speed because it can process tasks more quickly than slower processors.

Question 9

Working with data in the data cache is many times faster than working with data in the data files because ____.
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

Accepted Answer

The primary reason working with data in the data cache is faster than working with data in the data files is that the DBMS doesn't have to wait for the hard disk to retrieve the data. Data retrieval from hard disks is significantly slower than from memory (cache), where access times are much shorter.

Question 10

When creating a database, in order to optimize performance, put high-usage tables in their own ____.
A)data caches
B)data spaces
C)table caches
D)table spaces

Accepted Answer

Table spaces are used to separate high-usage tables into their own storage areas, which can optimize performance by reducing contention and improving data access speed.

Question 11

Database statistics are stored in the system catalog in specially designated ____.
A)indexes
B)rows
C)table spaces
D)Tables

Accepted Answer

Database statistics are stored in the system catalog in specially designated tables. These tables contain metadata about the database objects, including statistics that help in query optimization and database management.

Question 12

To optimize queries, use simple columns or literals as operands in a conditional expression and avoid the use of conditional expressions with ____ whenever possible.
A)the WHERE clause
B)functions
C)the GROUP BY clause
D)Indexes

Accepted Answer

Functions in conditional expressions can prevent the use of indexes, leading to less efficient query execution.

Question 13

The architecture of a DBMS is represented by the ____ and structures used to manage a database.
A)tables
B)queries
C)processes
D)Logs

Accepted Answer

The architecture of a DBMS (Database Management System) is represented by the processes and structures used to manage a database, not by tables, queries, or logs. These processes include the software components and mechanisms for database management, such as data storage, query processing, and transaction management.

Question 14

The majority of current database performance problems are related to ____.
A)not having enough memory on the database server
B)poorly written SQL code
C)improper use of table space
D)old statistics

Accepted Answer

Poorly written SQL code is often the primary cause of database performance issues. This can include inefficient queries, lack of proper indexing, and failure to optimize SQL statements, which can lead to excessive CPU usage, memory consumption, and slow response times.

Question 15

Which type of entity represents a logical generalization whose actual occurrence is represented by a second, associated entity?
A)Supertype entity
B)Subtype entity
C)Archetype entity
D)Instance entity

Accepted Answer

The answer of Which type of entity represents a logical...

Question 16

Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?
A)Rollback
B)Rollforward
C)Switch to duplicate database
D)Reprocess transactions

Accepted Answer

Rollback is the preferred method to recover a database after a transaction in progress terminates abnormally because it undoes any changes made during the transaction, ensuring data integrity.

Question 17

Concurrency control is important for which of the following reasons?
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

Accepted Answer

Concurrency control is crucial in a multiuser environment to maintain data integrity when multiple users attempt to update the database simultaneously.

Question 18

The transaction log includes which of the following?
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

Accepted Answer

The answer of The transaction log includes which of the...

Question 19

Which of the following is not true of SQL views?
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

Accepted Answer

Oracle views can indeed use the ORDER BY clause in view definitions, making statement A incorrect. Oracle views are created using the standard SQL-92 CREATE VIEW command, and they can be queried like tables, which makes statements B and C true.

Quiz 2: Database Management System DBMS: Part B

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

Which of the following is not a procedural language?

Who developed QBE?

What is the expansion of QBE?

Who developed Structured English Query Language?

Which of the following is IBM's first RDBMS?

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

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

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

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

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

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

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

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

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

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

Concurrency control is important for which of the following reasons?

The transaction log includes which of the following?

Which of the following is not true of SQL views?