An outer join is a………
a) is not supported by ANSI
b) is supported by DBMS
c) both a & b
d) none of these
What the relationship is between EXIST and NOT EXIST?
a) logical operator those value is true or false
b) only work with one or two tables
c) can return values
d) none of these
What happen when using INSERT?
a) rows can modified
b) rows cannot be copied
c) columns cannot be copied
d) rows can be inserted into table one time
What happen when using delete?
a) rows can be deleted one at time
b) columns can be deleted
c) rows can be deleted only one time
d) order of operation is not important
Which is not true about modifying data?
a) rows can be modified one at time
b) keyword set is used
c) after SET name of column is changed
d) mass updates are fast, and easy
Which of the following is not an SQL statement used on a single table?
a) select with where
b) select with group by
c) select with having
d) selection
