Sql TCL and DCL Set 1

DCL stands for

Data Carry Language

Date Core Language

Data Control Language

Non Of These

Privileges can be any combination of select, insert, update, delete, references, alter, and index .

true

false

Which of the following are not DCL command ?

grant

alter

revoke

roll back

Delete From Emp where eno=1100;

commit;

Can we get previous data roll back ?

yes

Which of the following is not a TCL statement ?

grant

revoke

savepoint

If we want to grant privilege 'select' on Emp table from Scott user to User1, which one of following is correct statement ?

Grant select on SCOTT.EMP to USER1.EMP;

Grant select to SCOTT.EMP to USER1.EMP;

Grant select from SCOTT.EMP to USER1.EMP;

Non of these

Which privileges allow user to EXECUTE, SELECT, INSERT, UPDATE, or DELETE data from database objects to which the privileges apply ?

System privileges

Object privileges

DBA privileges

All of above

The ROLLBACK command ends a transaction, but ROLLBACK TO SAVEPOINT does not .

true

false

Which commands are used for providing security to database objects ?

DDL

TCL

SSL

DCL