Explore topic-wise MCQs in Database.

This section includes 34 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 any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data.

A. 1
B.
Answer» B.
Discussion
2.

Common types of SQL CHECK constraints include range checks and limiting columns values.

A. 1
B.
Answer» B.
Discussion
3.

A benefit of using a stored procedure is that it can be distributed to client computers.

A. 1
B.
Answer» C.
Discussion
4.

A updatable view has its own data.

A. 1
B.
Answer» C.
Discussion
5.

A view that contains a computed column can be easily updated.

A. 1
B.
Answer» C.
Discussion
6.

Three types of triggers are: BEFORE, AFTER and EXCEPTION.

A. 1
B.
Answer» C.
Discussion
7.

The SQL DELETE statement is used to delete both the table structure and table data.

A. 1
B.
Answer» C.
Discussion
8.

A stored procedure is a program that performs some common action on database data and is stored in the database.

A. 1
B.
Answer» B.
Discussion
9.

Views can be used to show the results of computed columns.

A. 1
B.
Answer» B.
Discussion
10.

A trigger is a stored program that is attached to a database.

A. 1
B.
Answer» C.
Discussion
11.

There are three SQL data modification operations: insert, modify and delete.

A. 1
B.
Answer» B.
Discussion
12.

SQL statements can be embedded in triggers, stored procedures, and program code.

A. 1
B.
Answer» B.
Discussion
13.

Which of the following is an SQL trigger supported by Oracle?

A. BEFORE
B. INSTEAD OF
C. AFTER
D. All of the above.
Answer» E.
Discussion
14.

Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause.

A. 1
B.
Answer» C.
Discussion
15.

A ________ is a program that performs some common action on database data and that is stored in the database.

A. trigger
B. stored procedure
C. pseudofile
D. None of the above is correct.
Answer» C. pseudofile
Discussion
16.

What is an SQL virtual table that is constructed from other tables?

A. Just another table
B. A view
C. A relation
D. Query results
Answer» C. A relation
Discussion
17.

SQL Server does not support the BEFORE trigger.

A. 1
B.
C. 1
D.
Answer» B.
Discussion
18.

A reason for using an SQL view to hide columns is:

A. to simplify a result only.
B. to prevent the display of sensitive data only.
C. to accomplish both of the above.
D. None of the above are reasons for using an SQL view.
Answer» D. None of the above are reasons for using an SQL view.
Discussion
19.

SQL has a JOIN ON syntax that can be used to create inner joins and outer joins.

A. 1
B.
Answer» B.
Discussion
20.

For what purposes are views used?

A. To hide columns only
B. To hide rows only
C. To hide complicated SQL statements only
D. All of the above are uses for SQL views.
Answer» E.
Discussion
21.

Which is NOT one of the most common types of SQL CHECK constraints?

A. System date
B. Range checks
C. Lists of values
D. Comparing one column value to another within the same table
Answer» B. Range checks
Discussion
22.

The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships.

A. 1
B.
Answer» C.
Discussion
23.

A SQL view is a virtual table that is constructed from other tables or views.

A. 1
B.
C. 1
D.
Answer» B.
Discussion
24.

Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:

A. GROUP BY.
B. WHERE.
C. ORDER BY.
D. FROM.
Answer» D. FROM.
Discussion
25.

When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables.

A. 1
B.
C. 1
D.
Answer» B.
Discussion
26.

The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors.

A. 1
B.
Answer» C.
Discussion
27.

Which of the following is NOT a type of SQL constraint?

A. PRIMARY KEY
B. FOREIGN KEY
C. ALTERNATE KEY
D. UNIQUE
Answer» D. UNIQUE
Discussion
28.

A ________ is a stored program that is attached to a table or a view.

A. pseudofile
B. embedded SELECT statement
C. trigger
D. None of the above is correct.
Answer» D. None of the above is correct.
Discussion
29.

When using the SQL INSERT statement:

A. rows can be modified according to criteria only.
B. rows cannot be copied in mass from one table to another only.
C. rows can be inserted into a table only one at a time only.
D. rows can either be inserted into a table one at a time or in groups.
Answer» E.
Discussion
30.

The SQL statement used to create a view is CREATE VIEW.

A. 1
B.
C. 1
D.
Answer» B.
Discussion
31.

To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:

A. a particular column in a particular underlying table.
B. a particular column in a particular row.
C. a particular row in a particular underlying table.
D. None of the above is correct.
Answer» D. None of the above is correct.
Discussion
32.

The SQL statement to create a view is:

A. CREATE VIEW.
B. MAKE VIEW.
C. SELECT VIEW.
D. INSERT VIEW.
Answer» B. MAKE VIEW.
Discussion
33.

SQL views can be used to hide:

A. columns and rows only.
B. complicated SQL syntax only.
C. both of the above can be hidden by an SQL view.
D. None of the above is correct.
Answer» D. None of the above is correct.
Discussion
34.

The SQL command to create a table is:

A. MAKE TABLE.
B. ALTER TABLE.
C. DEFINE TABLE.
D. CREATE TABLE.
Answer» E.
Discussion