Explanation:The ‘create table . . . as’ statement closely resembles the create view statement and both are defined by using queries.The main difference is that the contents of the table are set when the table is created, whereas the contents of a view always reflect the current query result. 9. In contemporary databases the top level of the hierarchy consists of ______, each of which can contain _____.
A. Catalogs, schemas
B. Schemas, catalogs
C. Environment, schemas
D. Schemas, Environment
Answer:A
Explanation:The ‘create table . . . as’ statement closely resembles the create view statement and both are defined by using queries.The main difference is that the contents of the table are set when the table is created, whereas the contents of a view always reflect the current query result. 9. In contemporary databases the top level of the hierarchy consists of ______, each of which can contain _____.
A. Catalogs, schemas B. Schemas, catalogs C. Environment, schemas D. Schemas, Environment
Explanation:None. 10. Which of the following statements creates a new table temp instructor that has the same schema as instructor.