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. Question 12 The syntax for the UNION query is ____. Question 13 A ____ join returns rows with matching values and includes all rows from both tables( T1 and T2) with unmatched values. Question 14 Question 15 Installing the DBMS, creating the database, and loading or converting the data are part of the ____ phase of the DBLC. Question 16 Creating the conceptual design and selecting DBMS software are part of the ____ phase of the DBLC. Question 17 The traditional SDLC is divided into ____ phases. Question 18 A detailed system specification is part of the ____ phase of the SDLC. Question 19 User requirements, existing system evaluation, and logical system design are part of the ____ phase of the SDLC. Question 20 Lock ____ indicates the level of lock use. Question 21 The implicit beginning of a transaction is ____. Question 22 ____ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed. Question 23 A ____ lock locks the entire table preventing access to any row by a transaction while another transaction is using the table. Question 24 The information stored in the ____ is used by the DBMS for a recovery requirement triggered by a ROLLBACK statement, a program’ s abnormal termination, or a system failure such as a network discrepancy or a disk crash.