Contents

Which of the following view is based on one or more tables?
a) simple view                     

b) complex view
c) composite view               

d) none of these

b

Which of the following is a virtual table?
a) simple view                     

b) complex view
c) composite view               

d) view

d

Which of the following is not a valid SQL type?
a) FLOAT                             

b) NUMERIC
c) DECIMAL                      

d) CHARACTER

c

Which of the following is not a DDL command?
a) truncate                           

b) alter
c) create                                

d) update

d

Which statement is used to delete all rows in a table without having the action logged?
a) delete

b) remove                             

c) truncate

c

SQL Views are also known as……
a) simple tables   

b) virtual tables
c) complex table 

d) actual table

b