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 .