L. 3. Introduction to Database Management System - 6

1. Which of the following is an example of a DBMS ?

• SQL

• Microsoft Office

• PHP

• Oracle

2. ____________ is a language used to build database applications that need to query relational databases.

• C++

• SQL

• PAGEMAKER

• JAVA

3. _____________ used to create a new SQL Database.

• INSERT database

• SELECT database

• CREATE database

• UPDATE database

4. ____________ database used to remove any of the existing SQL Database.

• SELECT

• DELETE

• UPDATE

• DROP

5. SQL provides us with modifying and updating the existing records in a table using the________ command.

• CHANGE

• UPDATE

• INSERT

• MODIFY

6. ______________ clause is used in SELECT and UPDATE query statement for the condition.

• WHERE

• IF

• WHICH

• IN

7. The Query results are listed in Ascending or Descending order using the command _____________ .

• WHERE

• ORDER BY

• IF CLAUSE

• NONE OF THESE

8. Using the __________ command, we can group the column .

• ORDER BY

• WHERE BY

• GROUP BY

• MERGE BY

9. When we have to select data from more than 2 tables SQL __________ clause is used.

• SELECT

• WHERE

• JOIN

• MERGE

10. From the multiple records available in the table, the enquired data are retrieved from the table using the _______________ command

• HIGHLIGHT

• INSERT

• RETRIEVE

• SELECT