A.Table aliases can improve performance

B.The BETWEEN condition always performs better than using the >= and <= conditions

C.The join syntax used makes no difference to performance

D.The BETWEEN condition always performs less well than using the >= and <= conditions

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

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

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

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

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

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

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

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

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

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

E.The Oracle join syntax only supports right outer joins

F.The Oracle join syntax supports natural joins

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

A.Revoke the CREATE SESSION privilege from other users

B.Revoke the CREATE SESSION privilege from user HR

C.Log in to the database instance

D.Grant the CREATE SESSION privilege with ADMIN OPTION to other users

E.Execute DDL statements in the HR schema

F.Execute DML statements in the HR schema

A.SELECT TO_CHAR(SYSDATE,'DD-MON-YYYY') - '01-JAN-2019' FROM DUAL;

B.SELECT SYSDATE - TO_DATE('01-JANUARY-2019') FROM DUAL;

C.SELECT TO_DATE(SYSDATE, 'DD/MONTH/YYYY') - '01/JANUARY/2019' FROM DUAL;

D.SELECT ROUND(SYSDATE - '01-JAN-2019') FROM DUAL;

E.SELECT ROUND(SYSDATE - TO_DATE('01/JANUARY/2019')) FROM DUAL;