INFOMAN MIDTERMS

Question 1

the _______ executes to find information you dont know

Answer 1

subquery

Question 2

the ______ uses that information to find out what you need to know

Answer 2

Outer query

Question 3

this operator means equal to any member in the list

Answer 3

IN

Question 4

this operator compares value to each value returned by the subquery

Answer 4

ANY

Question 5

this operator compares value to every value returned by the subquery

Answer 5

ALL

Question 6

How many tables can be joined by using the JOINS in Oracle DB?

Answer 6

No limit

Question 7

If the REGIONS table, which contains 4 rows, is cross joined to the COUNTRIES table, which contains 25 rows, how many rows appear in the final results set?

Answer 7

100 rows

Question 8

The _____ operator is used within the outer query WHERE clause to select only those rows which are IN the list of values returned from the inner query

Answer 8

IN

Question 9

What keyword is used to determine the number of steps down from the beginning row that should be returned by a hierarchical query?

Answer 9

LEVEL

Question 10

Which clause specifies how rows must be grouped?

Answer 10

GROUP BY

Question 11

Which type of outer join performs a join on two tables, retrieves all the rows in the right table even if there is no match in the left table?

Answer 11

Left outer join

Question 12

This type of JOIN clause is based on all columns in the two tables that have the same name. It selects rows from the two tables that have equal values in all matched columns. Which of the following refers to the given statement?

Answer 12

NATURAL JOIN