What are the steps to join two table?
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. (right answer)
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 (right answer)
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
-------------------------------
Check My Work
Which of the following would you use to produce a combination of all rows from two tables?
a. FULL JOIN XXX
b. PRODUCT (right answer)
c. FULL OUTER JOIN XXX
d. FULL INNER JOIN
------------------------------
What is an alias?
a. an alternate name of a column in the database
b. an alternate name of a table in the database
c. an alternate name for a table in the FROM clause (right answer)
d. an alternate name for a column in the FROM clause
----------------------------------
Which of the following statements is true?
a. 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. (right answer)
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 left are not included regardless of whether they match rows from the table on the right.
-------------------------------------
Which two conditions must be met in order to use UNION operators?
a. The two table must have the table types and same column names. XX
b. The two table must have the column names and same number of columns. XXX
c. The two table must have the column datatypes and same number of columns. (right answer)
d. The two table must have the table types 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. (right answer)
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 is true if it satisfies all value.
d. ALL operator: the condition is true only if it satisfies any value. ANY operator: the condition is true 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 MS SQL Server?
a. UNION
b. INTERSECT (right answer)
c. MINUS XXXX
d. EXCEPT
e. All of the above
f. None of the above XXXX
-------------------------------------------
Which of the following is not true about joining a table to itself?
a. Known as SELF-JOIN. (right answer)
b. Must use columns aliases.
c. Must join the same table using primary key. XXX
d. Known as INNER-JOIN XXX
e. All of the above XXXX
f. None of the above XXXX
--------------------------------------------
Which of the following is not a valid JOIN command?
a. INNER JOIN
b. OUTER JOIN
c. FULL INNER JOIN (right answer)
d. FULL OUTER JOIN
e. All of the above
f. None of the above
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. (right answer)
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 (right answer)
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
-------------------------------
Check My Work
Which of the following would you use to produce a combination of all rows from two tables?
a. FULL JOIN XXX
b. PRODUCT (right answer)
c. FULL OUTER JOIN XXX
d. FULL INNER JOIN
------------------------------
What is an alias?
a. an alternate name of a column in the database
b. an alternate name of a table in the database
c. an alternate name for a table in the FROM clause (right answer)
d. an alternate name for a column in the FROM clause
----------------------------------
Which of the following statements is true?
a. 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. (right answer)
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 left are not included regardless of whether they match rows from the table on the right.
-------------------------------------
Which two conditions must be met in order to use UNION operators?
a. The two table must have the table types and same column names. XX
b. The two table must have the column names and same number of columns. XXX
c. The two table must have the column datatypes and same number of columns. (right answer)
d. The two table must have the table types 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. (right answer)
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 is true if it satisfies all value.
d. ALL operator: the condition is true only if it satisfies any value. ANY operator: the condition is true 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 MS SQL Server?
a. UNION
b. INTERSECT (right answer)
c. MINUS XXXX
d. EXCEPT
e. All of the above
f. None of the above XXXX
-------------------------------------------
Which of the following is not true about joining a table to itself?
a. Known as SELF-JOIN. (right answer)
b. Must use columns aliases.
c. Must join the same table using primary key. XXX
d. Known as INNER-JOIN XXX
e. All of the above XXXX
f. None of the above XXXX
--------------------------------------------
Which of the following is not a valid JOIN command?
a. INNER JOIN
b. OUTER JOIN
c. FULL INNER JOIN (right answer)
d. FULL OUTER JOIN
e. All of the above
f. None of the above
|
|
|
|
|
|
|
|
