A.PCTFREE defaults to 10% for all blocks in all segments for all compression methods

B.A block will always be eligible for inserts if the row is short enough to fit into the block

C.Insert operations always attempt to find blocks with free space appropriate to the length of the row being inserted

D.Update operations always attempt to find blocks with free space appropriate to the length of the row being updated

E.ASSM assigns blocks to one of four fullness categories based on what percentage of the block is allocated for rows

A.It gives an error because the GROUP BY clause is not valid

B.It executes successfully but does not give the required result

C.It executes successfully and gives the required result

D.It gives an error because the ALL keyword is not valid

A.The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables

B.The Oracle join syntax only supports right outer joins

C.The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax

D.The SQL:1999 compliant ANSI join syntax supports natural joins

E.The Oracle join syntax supports natural joins

F.The Oracle join syntax supports creation of a Cartesian product of two tables

G.The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax

A.SELECT NVL(TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;

B.SELECT TO_CHAR(NVL(cust_credit_limit * .15, 'Not Available')) FROM customers;

C.SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;

D.SELECT NVL(cust_credit_limit * .15, 'Not Available') FROM customers;

E.SELECT NVL2(cust_credit_limit * .15, 'Not Available') FROM customers;