You need to calculate the number of days from 1st January 2019 until today.
Dates are stored in the default format of DD-MON-RR.
Which two queries give the required output? (Choose two.)

• A.SELECT SYSDATE - TO_DATE('01-JANUARY-2019') FROM DUAL;
• B.SELECT TO_DATE(SYSDATE, 'DD/MONTH/YYYY') - '01/JANUARY/2019' FROM DUAL;
• C.SELECT ROUND(SYSDATE - TO_DATE('01/JANUARY/2019')) FROM DUAL;
• D.SELECT ROUND(SYSDATE - '01-JAN-2019') FROM DUAL;
• E.SELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY') - '01-JAN-2019' FROM DUAL;

Comment: *

Name: *

Email: *

Verification: *

In your data center, Oracle Managed Files (OMF) is used for all databases.
All tablespaces are smallfile tablespaces.
SALES_Q1 is a permanent user-defined tablespace in the SALES database.
Examine this command which is about to be issued by a DBA logged in to the SALES database:
ALTER TABLESPACE sales_q1 ADD DATAFILE;
Which are two actions, either one of which you could take to ensure that the command executes successfully?
(Choose two.)

• A.Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.
• B.Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.
• C.Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.
• D.Add the AUTOEXTEND ON clause with NEXT set to 100M.
• E.Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space.

Comment: *

Name: *

Email: *

Verification: *

Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)

• A.checking for outbound shared server responses on the common outbound response queue
• B.sending shared server session responses back to requesters on the appropriate connection
• C.receiving inbound requests from processes using shared server connections
• D.sending each connection input request to the appropriate shared server input queue
• E.writing inbound request to the common request queue from all shared server connections
• F.broadcasting shared server session responses back to requesters on all connections

Comment: *

Name: *

Email: *

Verification: *

Which four account management capabilities can be configured using Oracle profiles? (Choose four.)

• A.the maximum number of sessions permitted for a user before the account is locked
• B.the number of hours for which an account is locked after the configured number of login attempts has been reached
• C.the ability to prevent a password from ever being reused
• D.the maximum amount of CPU time allowed for a user's sessions before their account is locked
• E.the number of days for which an account is locked after the configured number of login attempts has been reached
• F.the number of days for which an account may be inactive before it is locked
• G.the number of password changes required within a period of time before a password can be reused

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about UNDO and REDO? (Choose two.)

• A.DML modifies Oracle database objects and only generates REDO
• B.The generation of REDO generates UNDO
• C.DML modifies Oracle database objects and generates UNDO and REDO
• D.DML modifies Oracle database objects and only generates UNDO
• E.The generation of UNDO generates REDO

Comment: *

Name: *

Email: *

Verification: *