CIS 111 All Assignments CIS 111 All Assignments

Set 2 Week 11 Final Exam • Question 1 A(n) ____ is an alternate name given to a column or table in any SQL statement. • Question 2 The SQL command that lets you insert rows into a table is ____. • Question 3 The special operator used to check whether a subquery returns any rows is ____. • Question 4 The ____ special operator is used to check whether an attribute value is null. • Question 5 To delete a row from the PRODUCT table, use the ____ command. • Question 6 The special operator used to check whether an attribute value is within a range of values is ____. • Question 7 The ____ command is used to restore the table’s contents to their previous values. • Question 8 Which of the following is used to select partial table contents? • Question 9 In Oracle, ____ make(s) it possible to merge SQL and traditional programming constructs, such as variables, conditional processing (IF-THEN-ELSE), basic loops (FOR and WHILE loops,) and error trapping. • Question 10 A ____ join returns rows with matching values and includes all rows from both tables (T1 and T2) with unmatched values. • Question 11 The syntax for the UNION query is ____. • Question 12 A(n) ____ join will select only the rows with common values in the common attribute(s). • Question 13 The ANSI standard defines ____ type(s) of outer join(s)

CIS 111 All Assignments CIS 111 All Assignments | Page 16