Explanation:Check(value ‘condition’) is the syntax. 8. Which of the following closely resembles Create view ?
A. Create table . . .like
B. Create table . . . as
C. With data
D. Create view as
Answer:A
Explanation:Check(value ‘condition’) is the syntax. 8. Which of the following closely resembles Create view ?
A. Create table . . .like B. Create table . . . as C. With data D. Create view as
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 _____.