A.SELECT ROUND(SYSDATE ?TO_DATE(`01/JANUARY/2019')) FROM DUAL;

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

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

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

E.SELECT TO_DATE(SYSDATE, `DD/MONTH/YYYY') ?`01/JANUARY/2019' FROM DUAL;

A.Oracle Net Manager can be used to locally configure naming methods on a database server

B.Oracle Net Manager can be used to centrally configure listeners on any database server target

C.Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server

D.The lsnrctl utility requires a listener.ora file to exist before it is started

E.Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target

F.The Oracle Net Configuration Assistant is only used when running the Oracle installer

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.It can be used from SQL Developer

B.It displays the NOT NULL constraint for any columns that have that constraint

C.It displays the PRIMARY KEY constraint for any column or columns that have that constraint

D.It displays all constraints that are defined for each column

E.It can be used only from SQL*Plus

F.It can be used to display the structure of an existing view

A.Oracle Data Guard can prevent data loss caused by a site failure.

B.Data Recovery Advisor can be used to validate backup strategies.

C.Data Recovery Advisor can be used to restore a single file from an RMAN backupset.

D.RMAN can be used to roll back committed transactions.

E.RMAN can be used to FLASHBACK a database.