SQL Data Manipulation Language MCQ

Data Manipulation Language MCQs : 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 one of these is used with SELECT clause to fetch all columns from a table?

A. ALL
B. *
C. DISTINCT
D. AS

View Answer


2. 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


3. 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


4. 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


5. 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


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

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

View Answer


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

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

View Answer


8. TRUNCATE statement in SQL is a

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

View Answer


9.  A table that displays data redundancies yields ____________ anomalies.

A. Update
B. Insertion
C. Deletion
D. All of the Mentioned

View Answer


10. 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


11. 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


12. 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


13. What is the full form DML?

A. data manipulation language
B. data manipulate language
C. data many language
D. data manipulation load

View Answer


14.  A data manipulation command the combines the records from one or more tables is called

A. SELECT
B. PROJECT
C. JOIN
D. PRODUCT

View Answer


15. Select the sequence for how the query mechanism works?

A. Authentication-> DDL->DML->query optimizer->output
B. DDL->DML->query optimizer-> Authentication->output
C. DML->query optimizer-> Authentication-> DDL-> output
D. All of the mentioned

View Answer


16. Data manipulation language (DML) includes statements that modify the _____ of a database.

A. Structure
B. Data
C. User
D. Size

View Answer





Also check :


Discussion



* You must be logged in to add comment.