1.Which statement best defines a schema?
A) A schema is a logical group of database objects—such as tables and indexes—that are related to each other
2. Which of the following is NOT a valid clause of CREATE TABLE statement?
A) SECONDARY KEY
3. Which of the following is NOT a table constraint?
A) ON INSERT
4. Which SQL command changes the structure of a TABLE?
A) ALTER
5. Which of the following is NOT a valid constraint?
A) UNIQUE
6. Which of the following is not a valid command to change a COLUMN in a TABLE?
A) DELETE
7. Which commands would you use to save and undo table changes?
A) COMMIT and ROLLBACK
8. Which of the following is a valid UPDATE command?
A) UPDATE table_name SET column_name WHERE condition;
9. Which of the following is a valid characteristic of a VIEW?
A) The name of a view can be used anywhere a table name is expected in a SQL statement.
10. Which of the following updatable view restrictions is NOT valid?
A) Updatable view must include the name(s) of the base table(s) used in the view.