SQL Questions

By Shubhranshu Shekhar / March 14, 2023

0 votes, 0 avg

416

SQL Questions

1 / 15

1. Commands that comes under DDL is/are –

A. CREATE

B. DROP

C. TRUNCATE

D. All of the above

2 / 15

2. Which one is not the OPTIONAL Clause in SELECT statement?

A. WHERE

B. ORDER BY

C. HAVE

D. HAVING

3 / 15

3. A view can refer to multiple tables via __________

A. UNION

B. JOIN

C. GROUP

D. SELECT

4 / 15

4. Which Statement is used to insert the values in the table?

A. INSERT INTO

B. Insert

C. INSERT

D. None of the mentioned

5 / 15

5. SQL INSERT is used to insert a –

A. Single or Multiple record

B. Single or Multiple database

C. Single or Multiple table

D. None of the above

6 / 15

6. What is xyz in the following SQL statement? DELETE FROM xyz WHERE abc = 5;

A. database name

B. column name

C. table name

D. row name

7 / 15

7. CROSS JOIN and JOIN are similar to __________

A. INNER JOIN

B. NATURAL JOIN

C. OUTER JOIN

D. CARTESIAN JOIN

8 / 15

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

9 / 15

9. Commands that come under TCL is/are –

A. COMMIT

B. ROLLBACK

C. SAVEPOINT

D. All of the above

10 / 15

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

11 / 15

11. Which statement can be used for modifying the definition for an existing table?

A. ALTER

B. Modified

C. SELECT

D. FROM

12 / 15

12. What is the role of “CONSTRAINS” in defining a table in Mysql?

A. Declaring primary key

B. Declaring Foreign Key

C. Restrictions on columns

D. All of the mentioned

13 / 15

13. What is generally done after the transactions are executed successfully?

A. delete

B. rollback

C. commit

D. update

14 / 15

14. In inner join, result is produced by matching rows in one table with rows in another table.

A. true

B. false

15 / 15

15. How many Primary keys can have in a table?

A. Only 1

B. Only 2

C. Depends on no of Columns

D. Depends on DBA

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