SQL/Oracle SQL 2

Question 1

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

Answer 1

Union

Question 2

retain all duplicates

Answer 2

Union all

Question 3

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

Answer 3

Intersect

Question 4

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

Answer 4

Except/Minus

Question 5

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

Answer 5

Aggregate Function

Question 6

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

Answer 6

Having

Question 7

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

Answer 7

In

Question 8

Connective test for the absence of set membership

Answer 8

not in

Question 9

greater than at least one

Answer 9

> some

Question 10

greater than all

Answer 10

> all

Question 11

returns the value true if the argument subquery is nonempty

Answer 11

exists

Question 12

is expressed in much the same way as a query

Answer 12

delete

Question 13

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

Answer 13

update