Data Manipulation Language MCQ

This section focuses on the "Data Manipulation Language" of the SQL. These Multiple Choice Questions (mcq) should be practiced to improve the SQL skills required for various interviews (campus interview, walk-in interview, company interview), placement, entrance exam and other competitive examinations.

1. Which of the following statements are TRUE about DISTINCT keyword?

A. DISTINCT removes duplicates based on all the columns in the SELECT clause
B. Usage of DISTINCT should be avoided as far as possible due to performance issues
C. Both A and B
D. None of the above

View Answer


2. Which of the following statements are False about DISTINCT keyword?

A. DISTINCT removes duplicates based on all the columns in the SELECT clause
B. DISTINCT keyword can be used in SELECT and WHERE clauses
C. Usage of DISTINCT should be avoided as far as possible due to performance issues
D. None of the above

View Answer


3. Which of the following columns in a table cannot be updated?

A. DATE type columns in the table
B. Columns which allows NULL values in the table
C. A primary key column which also serves as foreign key reference in another table
D. All of the above

View Answer


4. The language used application programs to request data from the DBMS is referred to as __________

A. DML
B. DDL
C. Query language
D. All of the Mentioned

View Answer


5. Which of the following is not a type of SQL statement?

A. DML
B. DDL
C. DCL
D. DCI

View Answer


6. Which of the following is not included in DML (Data Manipulation Language)?

A. Insert
B. Update
C. Delete
D. Alter

View Answer


7. TRUNCATE statement in SQL is a

A. DDL
B. DML
C. DCL
D. TCL

View Answer


8. A type of query that is placed within a WHERE or HAVING clause of another query is called

A. Master query
B. Sub query
C. Super query
D. Multi-query

View Answer


9. Stack is also called __________

A. First In First Out (LIFO)
B. Last In First Out (LIFO)
C. First In Last Out (FILO)
D. First Come First Served (FCFS)

View Answer


10. The three language components of a database management system (DBMS) like DDL, DCL, DML. Two different types of people (users and practitioners) are concerned with them. Which of them do users of a DB

A. DDL
B. DML
C. DDL And DCL
D. DCL And DML

View Answer






Also check :


Discussion


* You must be logged in to add comment.