DBMS Quiz 2 DSE

What is the full form of SQL?

• 1. Structured Query List

• 1. Structure Query Language

• 1. Sample Query Language

• 1. None of these.

Which of the following is not a DDL command?

• 1. TRUNCATE

• 1. ALTER

• 1. CREATE

• 1. UPDATE

How many Primary keys can have in a table?

• 1. Only 1

• 1. Only 2

• 1. Depends on no of Columns

• 1. Depends on DBA

Which of the following is not a valid aggregate function?

• 1. COUNT

• 1. COMPUTE

• 1. SUM

• 1. MAX

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

• 1. ANY

• 1. BETWEEN

• 1. ALL

• 1. IN

In which of the following cases a DML statement is not executed?

• 1. When existing rows are modified.

• 1. When a table is deleted.

• 1. When some rows are deleted.

• 1. All of the above

  Hide Answer

Which of the following is true about the HAVING clause?

• 1. Similar to the WHERE clause but is used for columns rather than groups.

• 1. Similar to WHERE clause but is used for rows rather than columns.

• 1. Similar to WHERE clause but is used for groups rather than rows.

• 1. Acts exactly like a WHERE clause.

Which type of JOIN is used to returns rows that do not have matching values?

• 1. Natural JOIN

• 1. Outer JOIN

• 1. EQUI JOIN

• 1. All of the above

Which of the following is the correct order of a SQL statement?

• 1. SELECT, GROUP BY, WHERE, HAVING

• 1. SELECT, WHERE, GROUP BY, HAVING

• 1. SELECT, HAVING, WHERE, GROUP BY

• 1. SELECT, WHERE, HAVING, GROUP BY

What does the INSERT INTO Statement do?

• 1. In this SQL statement, the data or records are inserted into an existing database table. One query statement can insert multiple records simultaneously using this statement.

• 1. A new database will be created through this SQL statement.

• 1. In the database management system, this SQL statement deletes the existing database, together with all the database tables and views.

• 1. By executing this SQL statement, all records in the SQL database will be deleted.