Contents

Which of the following is not an operation used on two or more tables?
a) subqueries                       

b) joins
c) EXISTS            
d) SELECT with Group BY

d

Which of the following is not an SQL command type?
a) DDL  

b) DML 

c) DGL 

d) DCL

c

Explanation: DGL stand for data graphic language


Three SQL DDL CREATE commands are
a) schema, base, and table               
b) base, table, and schema
c) key, base, and table       
d) schema, table and view

d

Which of the following is not an advantage of using a view?
a) simplify query commands           
b) provide data security
c) enhance programming productivity
d) decrease system overhead

d

Which command is not included in most data retrieval statements?
a) select

b) As      

c) From 

d) Where

b

Which of the following organization developed SQL?
a) IBM  

b) Apple

c) Microsoft

d) none

a

Explanation: IBM stand for International Business Machinery