CIS 111 All Assignments CIS 111 All Assignments | Page 19

•
Question 48 ____ CASE tools provide support for the planning, analysis, and design
phases.
•
Question 49 The ____ is responsible for ensuring database security and integrity.
•
Question 50 ____ activities cover all tasks directly related to the day-to-day operations
of the DBMS and its applications.
Set 3
Question 1 To delete a row from the PRODUCT table, use the ____ command.
Question 2 The special operator used to check whether a subquery returns any rows is ____.
Question 3 The ____ command would be used to delete the table row where the P_CODE is
'BRT-345'.
Question 4 The SQL command that lets you select attributes from rows in one or more tables is
____.
Question 5 The SQL command that lets you insert rows into a table is ____.
Question 6 The ____ special operator is used to check whether an attribute value is null.
Question 7 The SQL character data format(s) is(are) ____.
Question 8 To list all the contents of the PRODUCT table, you would use ____.
Question 9 The ANSI standard defines ____ type(s) of outer join(s)
Question 10 The ____ operator could be used in place of INTERSECT if the RDBMS does not
support it.
Question 11 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.