SQL Questions

By Shubhranshu Shekhar / March 14, 2023

0 votes, 0 avg

441

SQL Questions

1 / 15

1. What is the difference between HAVING and WHERE clause?

A. HAVING clause is used in column operation whereas WHERE clause is used in row operation.

B. HAVING clause is post-filter whereas WHERE clause is pre-filter.

C. HAVING clause filters the groups whereas WHERE clauses filter the single record of the table.

D. All of the above

2 / 15

2. Which keyword in the UPDATE statement is used to assign values to columns?

A. ASSIGN

B. SET

C. MARK

D. GET

3 / 15

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

A. ASCE, DESC

B. ASC, DES

C. ASCE, DES

D. ASC, DESC

4 / 15

4. In order to delete the database, which keyword is used?

A. DROP

B. DELETE

C. ALTER

D. None of the above

5 / 15

5. Which among the following is the correct syntax for modifying the definition of an existing table?

A. ALTER TABLE person MODIFY person_id SMALLINT UNSIGNED AUTO_INCREMENT;

B. ALTER TABLE person person_id SMALLINT UNSIGNED AUTO_INCREMENT;

C. ALTER TABLE person MODIFY person_id ;

D. ALTER TABLE person

6 / 15

6. Which command is used for the table definition in Mysql?

A. DESC table_name;

B. DESC table_name

C. DESC

D. None of the mentioned

7 / 15

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

8 / 15

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

9 / 15

9. A multiple-table delete can apply any join.

A. true

B. false

10 / 15

10. Which of the following clause cannot be optional in SQL SELECT Statement?

A. WHERE

B. GROUP BY

C. ORDER BY

D. None of the above

11 / 15

11. Is it necessary to insert the value in each column of the table?

A. Yes

B. No

C. Depends on the server

D. Depends on the usage of the table

12 / 15

12. Which feature is used for the automatic increment of the column?

A. AUTO_INCREMENT

B. AUTO

C. INCREMENT

D. All of the mentioned

13 / 15

13. Which operator is used to compare a value to a specified list of values?

A. ANY

B. BETWEEN

C. ALL

D. IN

14 / 15

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

15 / 15

15. Which datatype can store unstructured data in a column?

A. CHAR

B. RAW

C. NUMERIC

D. VARCHAR

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