SQL Questions

By Shubhranshu Shekhar / March 14, 2023

0 votes, 0 avg

442

SQL Questions

1 / 15

1. Select the correct statement.

A. With the DDL commands, any structural changes can be made to the table, including creation, deletion, and alteration.

B. With the DML commands, any structural changes can be made to the table, including creation, deletion, and alteration.

C. With the DCL commands, any structural changes can be made to the table, including creation, deletion, and alteration.

D. With the TCL commands, any structural changes can be made to the table, including creation, deletion, and alteration.

2 / 15

2. Views are not updatable.

A. true

B. false

3 / 15

3. What is x in the following MySQL statement? DELETE FROM x USING x LEFT JOIN y ON x.col = y.col;

A. column name

B. table name

C. server name

D. database name

4 / 15

4. Which statement is TRUE about the ORDER BY Clause?

A. In order to return the rows in a specific order, ORDER BY Clause is used.

B. In order to group the rows, ORDER BY Clause is used.

C. In order to select the defined groups, ORDER BY Clause is used.

D. None of the above

5 / 15

5. In order to sort the records according to the columns, which clause is used?

A. HAVING

B. GROUP BY

C. ORDER BY

D. None of the above

6 / 15

6. SQL DELETE can be used to delete,

A. Rows

B. Database

C. View

D. All of the above

7 / 15

7. Which data manipulation command is used to combines the records from one or more tables?

A. SELECT

B. PROJECT

C. JOIN

D. PRODUCT

8 / 15

8. What is the meaning of “REFERENCES” in table definition?

A. Primary key

B. NULL

C. Foreign Key

D. A ”foreign Key” belong to this particular table

9 / 15

9. SQL Views are also known as

A. Simple tables

B. Virtual tables

C. Complex tables

D. Actual Tables

10 / 15

10. Command that comes under DML is/are –

A. ROLLBACK

B. GRANT

C. UPDATE

D. All of the above

11 / 15

11. Which of these is also known as a virtual table?

A. SCHEMA

B. DATABASE

C. JOIN

D. VIEW

12 / 15

12. What is the clause to delete all rows from the table?

A. SQL DELETE ALL ROWS Table_Name;

B. SQL DELETE ROWS Table_Name;

C. DELETE FROM ALL ROWS Table_Name;

D. DELETE FROM Table_Name;

13 / 15

13. By default, sorting by ORDER BY clause is done in which order?

A. Ascending

B. Descending

14 / 15

14. What is the keyword of the Ascending and Descending?

A. ASCE, DESC

B. ASC, DES

C. ASCE, DES

D. ASC, DESC

15 / 15

15. Commands that comes under DDL is/are –

A. CREATE

B. DROP

C. TRUNCATE

D. All of the above

Your score is

The average score is 58%

By WordPress Quiz plugin

Written by Shubhranshu Shekhar, who has trained 20000+ students in coding.

Shubhranshu Shekhar

Shubhranshu Shekhar is a coding instructor, mentor, and founder of VSIT Delhi with 20+ years of teaching experience (since 2004). He has guided many students who are now working in multinational companies and specializes in Full Stack Development, Python, Digital Marketing, and Data Analytics.

Related Posts