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
Which of the following is not an SQL command type?
a) DDL
b) DML
c) DGL
d) DCL
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
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
Which command is not included in most data retrieval statements?
a) select
b) As
c) From
d) Where
Which of the following organization developed SQL?
a) IBM
b) Apple
c) Microsoft
d) none
Explanation: IBM stand for International Business Machinery