148
87.7k
Chapter:

40+ Unit 3 Solved MCQs

in Advanced Database Management Systems (ADBMS)

These multiple-choice questions (MCQs) are designed to enhance your knowledge and understanding in the following areas: Master of Computer Applications (MCA) .

Chapters

Take a Test
Chapter: Unit 3
1.

Who developed SEQUEL?

A. Dr. E.F. Codd
B. Chris Date
D. Chamberlain
Answer» D. Chamberlain
discuss
2.

Which of the following is used to get all the columns of a table ?

A. *
B. @
C. %
D. #
Answer» A. *
discuss
3.

The first commercial RDBMS is:

A. INGRESS
B. DB2
C. ORACLE
D. None of these.
Answer» A. INGRESS
discuss
4.

Which of the following is not a DCL statement?

A. Rollback
B. Grant
C. Revoke
D. None of these
Answer» A. Rollback
discuss
5.

Which of the following is the result of a select statement?

A. Trigger
B. Index
C. Table
D. None of these
Answer» C. Table
discuss
6.

Which of the following clause specifies the table or tables from where the data has to be retrieved?

A. Where
B. Table
C. From
D. None of these
Answer» C. From
discuss
7.

How many tables can be joined to create a view?

A. 1
B. 2
C. Database dependent
D. None of these
Answer» A. 1
discuss
8.

Which of the following can be used to get those items that fall within a range?

A. IN
B. BETWEEN
C. DISTINCT
D. LIKE
Answer» B. BETWEEN
Explanation: The BETWEEN operator is used in SQL to filter the results that fall within a specific range of values (inclusive).
For example:

SELECT * FROM products WHERE price BETWEEN 10 AND 50;

IN: is used to filter results that match any value in a list.
DISTINCT: is used to return unique values.
LIKE: is used for pattern matching in strings.
discuss
9.

Which of the following constitutes a basic set of operations for manipulating relational data?

A. Predicate calculus
B. Relational algebra
C. Relational calculus
D. None of the above
Answer» B. Relational algebra
discuss
10.

Which of the following is not a relational algebraic operation that is not form the set theory?

A. UNION
B. INTERSECTION
C. CARTESIAN PRODUCT
D. SELECT
Answer» D. SELECT
discuss
11.

Which of the following is not a relational algebraic operation that is developed specifically for the relational databases?

A. SELECT
B. UNION
C. JOIN
D. PROJECT
Answer» B. UNION
discuss
12.

Which is the symbol used to denote the SELECT operation?

A. Sigma
B. Rho
C. Pi
D. None of the above
Answer» A. Sigma
discuss
13.

Which of the following operations need the participating relations to be union compatible?

A. UNION
B. INTERSECTION
C. DIFFERENCE
D. All of the above
Answer» D. All of the above
discuss
14.

What will be the number of columns of CARTESIAN PRODCUT if the participating relations have 5 and 7 columns respectively?

A. 5
B. 12
C. 35
D. None of the above
Answer» B. 12
discuss
15.

What will be the number of columns of CARTESIAN PRODCUT if the participating relations have 5 and 20 rows respectively?

A. 5
B. 20
C. 25
D. 100
Answer» D. 100
discuss
16.

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
Answer» B. PROJECT
discuss
17.

Which of the following is not a procedural language?

A. Relational Algebra
B. SQL
C. Relational calculus
D. None of the above
Answer» C. Relational calculus
discuss
18.

Who developed QBE?

A. C.J. Date
B. E.F. Codd
C. M.M. Zloof
D. None of the above
Answer» C. M.M. Zloof
discuss
19.

What is the expansion of QBE?

A. Query by Example
B. Query by Experiment
C. Question before evaluation
D. None of the above
Answer» A. Query by Example
discuss
20.

Who developed Structured English Query Language?

A. E.F. Codd
B. D. Chamberlain
C. Chris Date
D. None of the above
Answer» B. D. Chamberlain
discuss
21.

Which of the following is the first commercial RDBMS?

A. DB2
B. INGRESS
C. ORACLE
D. None of the above
Answer» D. None of the above
discuss
22.

Which of the following is IBM’s first RDBMS?

A. DB2
B. IMS
C. SQL/DS
D. None of the above
Answer» C. SQL/DS
discuss
23.

The ____ is used as a temporary storage area for ORDER BY or GROUP BY operations, as well as for index-creation functions.

A. sort cache
B. SQL cache
C. data cache
D. optimizer mode
Answer» A. sort cache
discuss
24.

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

A. parsing
B. analyzing
C. execution
D. fetching
Answer» A. parsing
discuss
25.

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
Answer» D. the fastest processor
discuss
26.

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
Answer» B. the DBMS doesn't have to wait for the hard disk to retrieve the data
discuss
27.

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
Answer» D. table spaces
discuss
28.

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

A. indexes
B. rows
C. table spaces
D. Tables
Answer» D. Tables
discuss
29.

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
Answer» B. functions
discuss
30.

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

A. tables
B. queries
C. processes
D. Logs
Answer» C. processes
discuss
31.

The ____ is a shared, reserved memory area that stores the most recently accessed data blocks in RAM.

A. table space
B. extends
C. data cache
D. SQL cache
Answer» C. data cache
discuss
32.

Index ____ is a measure of how likely an index will be used in query processing.

A. statistics
B. connectivity
C. sparsity
D. selectivity
Answer» D. selectivity
discuss
33.

A(n) ____ is a logical grouping of several data files that store data with similar characteristics.

A. table space
B. extends
C. data cache
D. SQL cache
Answer» A. table space
discuss
34.

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
Answer» B. poorly written SQL code
discuss
35.

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
Answer» C. Archetype entity
discuss
36.

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
Answer» A. Rollback
discuss
37.

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
Answer» A. To ensure data integrity when updates occur to the database in a multiuser environment
discuss
38.

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
Answer» D. The essential data of the record
discuss
39.

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
Answer» A. Oracle views cannot use the ORDER BY clause in view definitions.
discuss
40.

Which of the following is NOT an Oracle-supported trigger?

A. BEFORE
B. DURING
C. AFTER
D. INSTEAD OF
Answer» B. DURING
discuss
41.

What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?

A. Full backup
B. Consistent backup
C. Inconsistent backup
D. Differential backup
Answer» B. Consistent backup
discuss
42.

Which of the following is true concerning a procedure?

A. You do not create them with SQL.
B. They do not need to have a unique name.
C. They include procedural and SQL statements.
D. They are the same thing as a function.
Answer» C. They include procedural and SQL statements.
discuss
43.

A CASE SQL statement is which of the following?

A. A way to establish an IF-THEN-ELSE in SQL.
B. A way to establish a loop in SQL.
C. A way to establish a data definition in SQL.
D. All of the above.
Answer» A. A way to establish an IF-THEN-ELSE in SQL.
discuss
44.

Which of the following statements is true concerning routines and triggers?

A. Both consist of procedural code.
B. Both have to be called to operate.
C. Both run automatically.
D. Both are stored in the database.
Answer» A. Both consist of procedural code.
discuss

Done Studing? Take A Test.

Great job completing your study session! Now it's time to put your knowledge to the test. Challenge yourself, see how much you've learned, and identify areas for improvement. Don’t worry, this is all part of the journey to mastery. Ready for the next step? Take a quiz to solidify what you've just studied.

Take a Test