Post Test ICT 7

1. Which of the following is the main purpose of SQL?

• To perform data operations related to Data Definition Language
• To perform data operations related to Data Manipulation Language
• Define the data structure
• All of the above

2. The SQL statement to display data from a table is...

• SELECT
• READ
• QUERY
• There is no correct answer

3. SQL stands for..

• Standard Query Language
• Structured Query Language
• Simple Query Language
• Super Query Language

4. SQL can be used for

• just create a database structure
• displaying data from a database
• modify existing data in a database
• Everything mentioned above can be done with SQL

5. DBMS is an acronym for

• Database Merging System
• Database
• Database Management System
• Database Manipulating System

6. The following are SQL commands that are included in the DCL (Data Control Language) group.

• GRANT and REVOKE
• INSERT and DELETE
• SELECT and UPDATE
• DROP and DELETE

7. The group of SQL commands related to defining a database structure are

• DDL (Data Definition Language)
• DML (Data Manipulation Language)
• DCL (Data Control Language)
• Nothing is right

8. The group of SQL commands related to data manipulation and processing are

• DDL (Data Definition Language)
• DML (Data Manipulation Language)
• DCL (Data Control Language)
• Nothing is right

9. Which of the following sequences is correct regarding a syntax for the SQL SELECT statement?

• SELECT, FROM, WHERE
• FROM, WHERE, SELECT
• WHERE, FROM, SELECT
• SELECT,WHERE,FROM

10. The group of SQL commands related to giving privilege to particular user are

• DDL (Data Definition Language)
• DML (Data Manipulation Language)
• DCL (Data Control Language)
• Nothing is right