31.) Evaluate the SQL statement
DROP TABLE SACHIN;
Which four statements are true of the SQL statement? (Choose Two)
A.) You cannot roll back this statement.
B.) All views based on the DEPT table are deleted.
C.) All data in the table is deleted, and the table structure is also deleted.
D.) All data in the table is deleted, but the structure of the table is retained.
E.) All synonyms based on the DEPT table are deleted.
Answer: Option A, C
32.) Which statement creates a new user?
A.) CREATIVE USER susan;
B.) CREATIVE OR REPLACE USER susan;
C.) CREATE NEW USER susan DEFAULT
D.) CREATE USER sachin IDENTIFIED BY gupta;
E.) CREATE OR REPLACE USER susan IDENTIFIED BY blue;
Answer: Option D
33.) A functional dependency is a relationship between or among:
A.) tables
B.) rows
C.) relations
D.) attributes.
Answer: Option D
34.) Which statement is valid?
A.) ALTER TABLE EMPLOYEE
MODIFY (last_name CHAR2(2000));
B.) ALTER TABLE EMPLOYEE
CHANGE (last_name CHAR2(2000));
C.) ALTER TABLE EMPLOYEE
CHANGE (last_name VARCHAR2 (2000));
D.) ALTER TABLE EMPLOYEE
MODIFY (last_name VARCHAR2 (2000));
Answer: Option D
35.) What does the DROP statement do?
A.) Removes the table
B.) Removes all rows from a table
C.) Shortens the table to 10 rows
D.) Removes all columns from a table
Answer: Option A