• 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 )
• Question 14 The primary objective of database design is ____.
• Question 15 Installing the DBMS , creating the database , and loading or converting the data are part of the ____ phase of the DBLC .
• Question 16 The process of creating an information system is known as ____ development .
• Question 17 Evaluation , maintenance , and enhancement are part of the ____ phase of the SDLC .
• Question 18 Analyzing the company situation is part of the ____ phase of the DBLC .
• Question 19 There are ____ stages in the DBLC .
• Question 20 ____ are required to prevent another transaction from reading inconsistent data .