CHAPTER 4 - SQL (4.1.1 - 4.1.3)

SQL can perform simple and complex queries in database management system

• True

• False

SQL can ______ records in table of database

(your answer must be in small letter)

• insert and delete only

• delete only

• update only

• insert, update, retrieve and delete

Each column in a database table is required to have a name and a data type

• True

• False

______ are example of SQL Datatype

• CHAR and INT

• UPDATE

• DELETE

• WRITE

Below are DML commands EXCEPT

• SELECT

• INSERT

• CREATE

• UPDATE

Below are DDL commands EXCEPT

• CREATE

• ALTER

• DROP

• DELETE

Which SQL statements that control the level of user access?

• DCL

• TCL

• DDL

• DML

What is DCL statements that give user access privilege's to database

• GRANT

• REVOKE

Which SQL statements that allow to control and manage transaction?

• DCL

• DDL

• TCL

• DML

Which TCL statements that permanently save any transaction into database?

• BEGIN

• COMMIT

• ROLLBACK