Database Application Unit 5

What are the steps to join two tables?

A. List columns to be displayed, list of tables containing displayed columns, restrict rows from the two tables that have common values.
B. List columns to be displayed, list of tables containing displayed columns, restrict rows from the two tables that have common values in matching columns.
C. List columns to be displayed, list of tables containing displayed columns, restrict columns from the two tables that have common values.
D. List columns to be displayed, list of tables containing displayed columns, restrict columns from the two tables that have common values in matching rows.
E. All of the above
F. None of the above

What is an EXISTS operator?

A. An operator that to retrieve data from a specific table
B. An operator that checks the existence of rows that satisfies some criterion
C. An operator that checks the existence of rows in another table
D. An operator that to retrieve data another table
E. All of the above
F. None of the above

Which of the following would you use to produce a combination of all rows from two tables?

A. FULL JOIN
B. FULL INNER JOIN
C. FULL OUTER JOIN
D. PRODUCT

What is an alias?

A. an alternate name of a column in the database
B. an alternate name for a column in the FROM clause
C. an alternate name of a table in the database
D. an alternate name for a table in the FROM clause

Which of the following statements is true?

A. Right outer join, all rows from the table on the left are not included regardless of whether they match rows from the table on the right.
B. Left outer join, all rows from the table on the right are included regardless of whether they match rows from the table on the left.
C. Left outer join, all rows from the table on the left are not included regardless of whether they match rows from the table on the right.
D. Right outer join, all rows from the table on the right are included regardless of whether they match rows from the table on the left.

Which two condition must be met in order to use UNION operators?

A. The two tables must have the table types and same column names.
B. The two tables must have the column names and same number of columns.
C. The two tables must have the table types and same number of columns.
D. The two tables must have the column datatypes and same number of columns.

Which of the following statements is valid?

A. ALL operator: the condition is true only if it satisfies all values: ANY operator: the condition is true if it satisfies any value.
B. ALL operator: the condition is true only if it satisfies all values.
ANY operator: the condition is true if it satisfies more than one value.
C. ALL operator: the condition is true only if it satisfies more than one value. ANY operator: the condition id true if it satisfies all values.
D. ALL operator: the condition is true only if it satisfies any value. ANY operator: the condition is tru if it satisfies all value.
E. All of the above
F. None of the above

Which of the following is not a SET operator in MySQL Server?

A. UNION
B. INTERSECT
C. MINUS
D. EXCEPT
E. All of the above
F. None of the above

Which of the following is not true about joining a table to itself?

A. Known as SELF-JOIN
B. Must use columns aliases
C. Must join the same table using primary key
D. Known as INNER-JOIN
E. All of the above
F. None of the above

Which of the following is not a valid JOIN command?

A. INNER JOIN
B. OUTER JOIN
C. FULL INNER JOIN
D. FULL OUTER JOIN
E. All of the above
F. None of the above