16.)Which one is a system privilege?
A.) DROP
B.) DELETE
C.) TRUNCATE
D.) ALTER TABLE
E.) CREATE TABLE
Answer: Option E
17.) Which four are types of functions available in SQL? (Choose 4)
A.) string
B.) character
C.) integer
D.) calendar
E.) numeric
F.) translation
G.) date
H.) conversion
Answer: Option B, E, G, H
18.) The primary key is selected from the:
A.) composite keys.
B.) determinants.
C.) candidate keys.
D.) foreign keys.
Answer: Option C
19.) Which is a valid CREATE TABLE statement?
A.) Create table emp add(id number(3));
B.) Create table emp (id number(3));
C.) Create table emp modified (id number(3));
D.) Create table emp (id numbers(3));
Answer: Option B
20.) A tuple is a?
A.) row of a table.
B.) key of a table.
C.) column of a table.
D.) Two dimensional table
Answer: Option A