Introduction to SQL - Database MCQ Questions and answers- Technical Aptitude

A. ADD

B. CREATE

C. INSERT

D. MAKE

A. REMOVE FROM CUSTOMER ...

B. DROP FROM CUSTOMER ...

C. DELETE FROM CUSTOMER WHERE ...

D. UPDATE FROM CUSTOMER ...

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.

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

A. An exact match is necessary in a SELECT statement.

B. An exact match is not possible in a SELECT statement.

C. An exact match is necessary in a CREATE statement.

D. An exact match is not possible in a CREATE statement.

A. A virtual table that can be accessed via SQL commands

B. A virtual table that cannot be accessed via SQL commands

C. A base table that can be accessed via SQL commands

D. A base table that cannot be accessed via SQL commands

A. REMOVE TABLE CUSTOMER;

B. DROP TABLE CUSTOMER;

C. DELETE TABLE CUSTOMER;

D. UPDATE TABLE CUSTOMER;

A. Normalization

B. Data Integrity

C. Materialized Views

D. All of the above

A. DDL

B. DML

C. HTML

D. XML

A. CREATE INDEX ID;

B. CHANGE INDEX ID;

C. ADD INDEX ID;

D. REMOVE INDEX ID;