• 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.