SQL MCQs - Data Manipulation Language

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


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

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

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.