SQL/Oracle SQL 2

Question 1

include only the result from the first result set that are not included in second result set

Answer 1

Except/Minus

Question 2

Connective test for the absence of set membership

Answer 2

not in

Question 3

returns the value true if the argument subquery is nonempty

Answer 3

exists

Question 4

to change a value in a tuple without changing all values in the tuple

Answer 4

update

Question 5

used to combiner two select statements but only returns the records which are common from both select statement

Answer 5

Intersect

Question 6

Connective test for set membership where the set is a collection of values produced by select clause

Answer 6

In

Question 7

greater than all

Answer 7

> all

Question 8

are functions that takes a collection of value as an input and return as single value

Answer 8

Aggregate Function

Question 9

retain all duplicates

Answer 9

Union all

Question 10

used to combined the result of two select statements and eliminate duplicate

Answer 10

Union

Question 11

is expressed in much the same way as a query

Answer 11

delete

Question 12

greater than at least one

Answer 12

> some

Question 13

was added to SQL because WHERE keyword cannot be used with aggregate functions

Answer 13

Having