A.CURRENT_DATE returns the current date and time as per the session time zone

B.SYSDATE can be used in expressions only if the default date format is DD-MON-RR

C.SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server

D.CURRENT_TIMESTAMP returns the same date as CURRENT_DATE

E.CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds

F.SYSDATE can be queried only from the DUAL table

A.The listener is not listening on the default port 1521

B.The service DB01.abc.com is dynamically registered

C.The service DB01.abc.com is statically registered

D.The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file

E.The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1

A.the number of password changes required within a period of time before a password can be reused

B.the number of days for which an account may be inactive before it is locked

C.the number of hours for which an account is locked after the configured number of login attempts has been reached

D.the ability to prevent a password from ever being reused

E.the maximum amount of CPU time allowed for a user's sessions before their account is locked

F.the number of days for which an account is locked after the configured number of login attempts has been reached

G.the maximum number of sessions permitted for a user before the account is locked

A.It is available only when the database is open

B.It can be used to switch a database into ARCHIVELOGMODE

C.The same port number can be used for multiple Database Express configurations for multiple databases on the same host

D.The same port number can be used for Database Express configurations for databases on different hosts

E.It can be used to perform database recovery

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