CIS 111 STUDY Learn Do Live /cis111study.com CIS 111 STUDY Learn Do Live /cis111study.com | Page 17

www.cis111study.com
This Tutorial contains 4 Set of Final Exam (Approximately – 200
MCQ)CIS – 111 Week 11 Final Exam
• Question 1 Which query will output the table contents when the
value of P_PRICE is less than or equal to 10?
• Question 2 The SQL command that lets you select attributes from
rows in one or more tables is ____.
• Question 3 To list all the contents of the PRODUCT table, you
would use ____.
• Question 4 To delete a row from the PRODUCT table, use the ____
command.
• Question 5 The SQL character data format(s) is(are) ____.
• Question 6 A table can be deleted from the database by using the
____ command.
• Question 7 The special operator used to check whether a subquery
returns any rows is ____.
• Question 8 The ____ special operator is used to che ck whether an
attribute value is null.
• Question 9 The ____ operator could be used in place of
INTERSECT if the RDBMS does not support it.
• Question 10 The syntax for the UNION query is ____.
• Question 11 The ANSI standard defines ____ type(s) of outer
join(s)