Which two are true about Oracle recovery and data protection solutions? (Choose two.)

• A.Oracle Data Guard can prevent data loss caused by a site failure.
• B.Data Recovery Advisor can be used to restore a single file from an RMAN backupset.
• C.Data Recovery Advisor can be used to validate backup strategies.
• D.RMAN can be used to roll back committed transactions.
• E.RMAN can be used to FLASHBACK a database.

Comment: *

Name: *

Email: *

Verification: *

You execute this command:

Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBStablespace? (Choose two.)

• A.Additional data files may not be added
• B.It will always have a 32K blocksize
• C.It will be a dictionary-managed tablespace by default
• D.It must be bigger than the largest SMALLFILE tablespace
• E.AUTOEXTEND is possible for the datafile

Comment: *

Name: *

Email: *

Verification: *

Evaluate these commands which execute successfully:

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)

• A.If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS
• B.Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times
• C.Sequence ORD_SEQ is guaranteed not to generate duplicate numbers
• D.Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ
• E.Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

• A.A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
• B.GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
• C.GLOBAL TEMPORARY TABLE space allocation occurs at session start.
• D.Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
• E.A GLOBAL TEMPORARY TABLE'S definition is available to multiple sessions.
• F.A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)

• A.CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds
• B.SYSDATE can be queried only from the DUAL table
• C.CURRENT_DATE returns the current date and time as per the session time zone
• D.SYSDATE can be used in expressions only if the default date format is DD-MON-RR
• E.SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server
• F.CURRENT_TIMESTAMP returns the same date as CURRENT_DATE

Comment: *

Name: *

Email: *

Verification: *