HARD
HSSC Clerk
IMPORTANT
Earn 100
Which of the following commands do we use to delete a relation (R) from a database?
50% studentsanswered this correctly
Important Questions on Practice Sets
MEDIUM
HSSC Clerk
IMPORTANT
The CREATE TRIGGER statement is used to create the trigger.
THE _____ clause specifies the table name on which the trigger is to be attached. The _____ specifies that this is an AFTER INSERT trigger.
HARD
HSSC Clerk
IMPORTANT
Implicit and Explicit cursor has attribute
HARD
HSSC Clerk
IMPORTANT
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
HARD
HSSC Clerk
IMPORTANT
Suppose a relation R is in three NF. Then an FD: is not valid on R, if:
I. is a proper subset of some keys.
II. is not a proper subset of any key.
III. is a key.
IV is part of some key.
MEDIUM
HSSC Clerk
IMPORTANT
In SQL, which of the following is not a data Definition Language Command?
MEDIUM
HSSC Clerk
IMPORTANT
A relation is said to be in when
MEDIUM
HSSC Clerk
IMPORTANT
A major goal of the database system is to minimize the number of block transfers between the disk and memory. This is achieved by _____.
HARD
HSSC Clerk
IMPORTANT
If the same object name is given to different objects of different classes, then _____.
