Explore topic-wise MCQs in Database.

This section includes 45 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.

1.

If a database is built correctly the first time, it will not have to be redesigned.%!

A. True
B. False
Answer» C.
Discussion
2.

Some organizations take the stand that no application should ever employ the true name of a table.%!

A. True
B. False
Answer» B. False
Discussion
3.

The EXISTS keyword will be true if any row in the subquery meets the condition.%!

A. True
B. False
Answer» B. False
Discussion
4.

Typically, there should be at least two different copies of the database schema used in the redesign process.%!

A. True
B. False
Answer» C.
Discussion
5.

The data model produced from the reverse engineering process does not include intersection table data.%!

A. True
B. False
Answer» C.
Discussion
6.

Database redesign is especially difficult if the database has no data.%!

A. True
B. False
Answer» C.
Discussion
7.

Dependency graphs are diagrams that consist of nodes and arcs that show the dependencies of a database.%!

A. True
B. False
Answer» B. False
Discussion
8.

It is not easy to build a database correctly the first time.%!

A. True
B. False
Answer» B. False
Discussion
9.

Because of the need for extensive knowledge of SQL, many database developers choose to automate the redesign process.%!

A. True
B. False
Answer» C.
Discussion
10.

Correlated subqueries are similar to a regular subquery.%!

A. True
B. False
Answer» C.
Discussion
11.

The NOT EXISTS keyword will be true if any row in the subquery meets the condition.%!

A. True
B. False
Answer» C.
Discussion
12.

The data model produced from the reverse engineering process is a true logical model.%!

A. True
B. False
Answer» C.
Discussion
13.

Although creating test databases is a critical and necessary job, there are few career opportunities in this area.%!

A. True
B. False
Answer» C.
Discussion
14.

A regular subquery is processed from the bottom up.%!

A. True
B. False
Answer» B. False
Discussion
15.

Adding null columns to a table is straightforward.%!

A. True
B. False
Answer» B. False
Discussion
16.

Reverse engineering is the process of reading a database schema and producing a data model from that schema.%!

A. True
B. False
Answer» B. False
Discussion
17.

The use of the double NOT EXISTS can be used to find rows that do not match some specified condition.%!

A. True
B. False
Answer» B. False
Discussion
18.

A correlated subquery is processed as a nested subquery.%!

A. True
B. False
Answer» B. False
Discussion
19.

Information systems and organizations do not just influence each other; they create each other.%!

A. True
B. False
Answer» B. False
Discussion
20.

The SQL-92 command to change a table name is RENAME TABLE.%!

A. True
B. False
Answer» C.
Discussion
21.

The process of reading a database schema and producing a data model from that schema is known as:%!

A. data modeling.
B. database design.
C. reverse engineering.
D. None of the above is correct.
Answer» D. None of the above is correct.
Discussion
22.

What SQL command can be used to add columns to a table?%!

A. MODIFY TABLE TableName ADD COLUMN ColumnName
B. MODIFY TABLE TableName ADD ColumnName
C. ALTER TABLE TableName ADD COLUMN ColumnName
D. ALTER TABLE TableName ADD ColumnName
Answer» E.
Discussion
23.

To drop a column that is used as a foreign key, first:%!

A. drop the primary key.
B. drop the table containing the foreign key.
C. drop the foreign key constraint.
D. All of the above must be done.
Answer» D. All of the above must be done.
Discussion
24.

Because of the importance of making data model changes correctly, many professionals are ________ about using an automated process for database redesign.%!

A. optimistic
B. skeptical
C. ambivalent
D. None of the above is correct
Answer» C. ambivalent
Discussion
25.

*$_The process of reading a database schema and producing a data model from that schema is known as:?

A. data modeling.
B. database design.
C. reverse engineering.
D. None of the above is correct.
Answer» D. None of the above is correct.
Discussion
26.

*$_Because of the importance of making data model changes correctly, many professionals are ________ about using an automated process for database redesign.?

A. optimistic
B. skeptical
C. ambivalent
D. None of the above is correct
Answer» C. ambivalent
Discussion
27.

*$_To drop a column that is used as a foreign key, first:?

A. drop the primary key.
B. drop the table containing the foreign key.
C. drop the foreign key constraint.
D. All of the above must be done.
Answer» D. All of the above must be done.
Discussion
28.

*$_What SQL command can be used to add columns to a table??

A. MODIFY TABLE TableName ADD COLUMN ColumnName
B. MODIFY TABLE TableName ADD ColumnName
C. ALTER TABLE TableName ADD COLUMN ColumnName
D. ALTER TABLE TableName ADD ColumnName
Answer» E.
Discussion
29.

*/*_Which SQL-92 standard SQL command can be used to change a table name??

A. RENAME TABLE
B. CHANGE TABLE
C. ALTER TABLE
D. None of the above is correct
Answer» E.
Discussion
30.

%_Which SQL-92 standard SQL command can be used to change a table name?_%

A. RENAME TABLE
B. CHANGE TABLE
C. ALTER TABLE
D. None of the above is correct
Answer» E.
Discussion
31.

_ How many copies of the database schema are typically used in the redesign process?$?

A. One
B. Two
C. Three
D. Four
Answer» D. Four
Discussion
32.

_ The data model that is produced from reverse engineering is:$?

A. a conceptual model.
B. an internal model.
C. a logical model.
D. None of the above is correct.
Answer» E.
Discussion
33.

_ A regular subquery can be processed:$?

A. from the top down.
B. from the bottom up.
C. by nesting.
D. None of the above is correct.
Answer» C. by nesting.
Discussion
34.

_Database redesign is not terribly difficult if the:$?

A. database is structured.
B. database is well-designed.
C. database has no data.
D. database is relatively small.
Answer» D. database is relatively small.
Discussion
35.

_A tool that can help designers understand the dependencies of database structures is a:$?

A. dependency graph.
B. data model.
C. graphical display.
D. None of the above is correct.
Answer» B. data model.
Discussion
36.

_The NOT EXISTS keyword will be true if:$?

A. any row in the subquery meets the condition.
B. all rows in the subquery fail the condition.
C. both of these two conditions are met.
D. neither of these two conditions is met.
Answer» C. both of these two conditions are met.
Discussion
37.

_How can you find rows that do not match some specified condition?$?

A. EXISTS
B. Double use of NOT EXISTS
C. NOT EXISTS
D. None of the above is correct
Answer» C. NOT EXISTS
Discussion
38.

What SQL command can be used to delete columns from a table?$?

A. MODIFY TABLE TableName DROP COLUMN ColumnName
B. MODIFY TABLE TableName DROP ColumnName
C. ALTER TABLE TableName DROP COLUMN ColumnName
D. ALTER TABLE TableName DROP ColumnName
Answer» D. ALTER TABLE TableName DROP ColumnName
Discussion
39.

Which of the following modifications may not succeed?$?

A. Changing a column data type from char to date
B. Changing a column data type from numeric to char
C. Both of the above actions should succeed
D. Neither of the above actions will succeed
Answer» B. Changing a column data type from numeric to char
Discussion
40.

Changing cardinalities in a database is:$?

A. a common database design task.
B. a rare database design task, but does occur.
C. a database design task that never occurs.
D. is impossible to do, so a new database must be constructed and the data moved into it.
Answer» B. a rare database design task, but does occur.
Discussion
41.

Which is not true of a correlated subquery?$?

A. EXISTS/NOT EXISTS is a form of a correlated subquery.
B. The processing of the SELECT statements is nested.
C. They can be used to verify functional dependencies.
D. They are very similar to a regular subquery.
Answer» E.
Discussion
42.

What SQL command can be used to delete columns from a table??

A. MODIFY TABLE TableName DROP COLUMN ColumnName
B. MODIFY TABLE TableName DROP ColumnName
C. ALTER TABLE TableName DROP COLUMN ColumnName
D. ALTER TABLE TableName DROP ColumnName
Answer» D. ALTER TABLE TableName DROP ColumnName
Discussion
43.

Which is not true of a correlated subquery??

A. EXISTS/NOT EXISTS is a form of a correlated subquery.
B. The processing of the SELECT statements is nested.
C. They can be used to verify functional dependencies.
D. They are very similar to a regular subquery.
Answer» E.
Discussion
44.

Changing cardinalities in a database is:?

A. a common database design task.
B. a rare database design task, but does occur.
C. a database design task that never occurs.
D. is impossible to do, so a new database must be constructed and the data moved into it.
Answer» B. a rare database design task, but does occur.
Discussion
45.

Which of the following modifications may not succeed??

A. Changing a column data type from char to date
B. Changing a column data type from numeric to char
C. Both of the above actions should succeed
D. Neither of the above actions will succeed
Answer» B. Changing a column data type from numeric to char
Discussion