Lv1 Chapter 3 Basics of SQL

Types of SQL Commands are            

• DDL
• DML
• DCL
• All of the above

Which of the following is not a type of SQL statement?

• Data Manipulation Language (DML)
• Data Definition Language (DDL)
• Data Control Language (DCL)
• Data Communication Language (DCL)

Commands that comes under DDL is/are –

• DROP
• CREATE
• TRUNCATE
• All of the above

Command that comes under DML is/are –

• ROLLBACK
• GRANT
• UPDATE
• All of the above

Command that comes under DCL is/are -

• GRANT
• REVOKE
• Both A. and B.
• None of the above

Which of the following is generally used for performing tasks like creating the structure of the relations, deleting relation?

• DML(Data Manipulation Language)
• Query
• Relational Schema
• DDL(Data Definition Language)

You can add a row using SQL in a database with which of the following?

• ADD
• CREATE
• INSERT
• MAKE

Which of the following syntax is true for adding a new record in table ?

• INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...);
• INSERT INTO (column1, column2, column3, ...) VALUES (value1, value2, value3, ...);
• INSERT INTO table_name (column1, column2, column3, ...) (value1, value2, value3, ...);
• INSERT IN table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...);

The FROM SQL clause is used to            ?

• specify what table we are selecting or deleting data FROM
• specify range for search condition
• specify search condition
• None of these

The table records can be retrieved using which command?

• RETRIEVE
• SELECT
• CREATE
• ALTER