WorksheetsCHAPTER 4 - SQL (4.1.1 - 4.1.3)
Total questions: 10
Worksheet time: 5mins
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
