Explore topic-wise MCQs in Database.

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

51.

_ Which of the following is the original purpose of SQL?$?

A. To specify the syntax and semantics of SQL data definition language
B. To specify the syntax and semantics of SQL manipulation language
C. To define the data structures
D. All of the above
Answer» E.
Discussion
52.

__ON UPDATE CASCADE ensures which of the following?__

A. Normalization
B. Data Integrity
C. Materialized Views
D. All of the above
Answer» C. Materialized Views
Discussion
53.

__The SQL -92 wildcards are ____ and ____ .__

A. asterisk (*); percent sign (%)
B. percent sign (%); underscore (_)
C. underscore(_); question mark (?)
D. question mark (?); asterisk (*)
Answer» C. underscore(_); question mark (?)
Discussion
54.

__A subquery in an SQL SELECT statement is enclosed in:__

A. braces -- {...}.
B. CAPITAL LETTERS.
C. parenthesis -- (...) .
D. brackets -- [...].
Answer» D. brackets -- [...].
Discussion
55.

__To define what columns should be displayed in an SQL SELECT statement:__

A. use FROM to name the source table(s) and list the columns to be shown after SELECT.
B. use USING to name the source table(s) and list the columns to be shown after SELECT.
C. use SELECT to name the source table(s) and list the columns to be shown after USING.
D. use USING to name the source table(s) and list the columns to be shown after WHERE.
Answer» B. use USING to name the source table(s) and list the columns to be shown after SELECT.
Discussion
56.

__When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):__

A. LIKE only.
B. IN only.
C. NOT IN only.
D. Both IN and NOT IN.
Answer» E.
Discussion
57.

The SQL WHERE clause:$?

A. limits the column data that are returned.
B. limits the row data are returned.
C. Both A and B are correct.
D. Neither A nor B are correct.
Answer» C. Both A and B are correct.
Discussion
58.

The HAVING clause does which of the following?$?

A. Acts like a WHERE clause but is used for groups rather than rows.
B. Acts like a WHERE clause but is used for rows rather than columns.
C. Acts like a WHERE clause but is used for columns rather than groups.
D. Acts EXACTLY like a WHERE clause.
Answer» B. Acts like a WHERE clause but is used for rows rather than columns.
Discussion
59.

SQL query and modification commands make up a(n) ________ .$?

A. DDL
B. DML
C. HTML
D. XML
Answer» C. HTML
Discussion
60.

Which of the following is the correct order of keywords for SQL SELECT statements?$?

A. SELECT, FROM, WHERE
B. FROM, WHERE, SELECT
C. WHERE, FROM,SELECT
D. SELECT,WHERE,FROM
Answer» B. FROM, WHERE, SELECT
Discussion
61.

The command to eliminate a table from a database is:$?

A. REMOVE TABLE CUSTOMER;
B. DROP TABLE CUSTOMER;
C. DELETE TABLE CUSTOMER;
D. UPDATE TABLE CUSTOMER;
Answer» C. DELETE TABLE CUSTOMER;
Discussion
62.

To sort the results of a query use:$?

A. SORT BY.
B. GROUP BY.
C. ORDER BY.
D. None of the above is correct.
Answer» D. None of the above is correct.
Discussion
63.

The command to eliminate a table from a database is:?

A. REMOVE TABLE CUSTOMER;
B. DROP TABLE CUSTOMER;
C. DELETE TABLE CUSTOMER;
D. UPDATE TABLE CUSTOMER;
Answer» C. DELETE TABLE CUSTOMER;
Discussion
64.

The HAVING clause does which of the following??

A. Acts like a WHERE clause but is used for groups rather than rows.
B. Acts like a WHERE clause but is used for rows rather than columns.
C. Acts like a WHERE clause but is used for columns rather than groups.
D. Acts EXACTLY like a WHERE clause.
Answer» B. Acts like a WHERE clause but is used for rows rather than columns.
Discussion
65.

Which of the following is the correct order of keywords for SQL SELECT statements??

A. SELECT, FROM, WHERE
B. FROM, WHERE, SELECT
C. WHERE, FROM,SELECT
D. SELECT,WHERE,FROM
Answer» B. FROM, WHERE, SELECT
Discussion
66.

To sort the results of a query use:?

A. SORT BY.
B. GROUP BY.
C. ORDER BY.
D. None of the above is correct.
Answer» D. None of the above is correct.
Discussion
67.

SQL query and modification commands make up a(n) ________ .?

A. DDL
B. DML
C. HTML
D. XML
Answer» C. HTML
Discussion