Examine this command:

Which two statements are true?

• A.Compressed objects in SALES01.DBF will be uncompressed In SALES02.DBF after the move.
• B.The "to" clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used.
• C.It overwrites any existing file with the name SALES02.DBF.dbf in /u02 by default.
• D.DML may be performed on tables with one or more extents in this data file during the execution of this command.
• E.Tables with one or more extents in this data file may be queried during the execution of this command.

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

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the product_details table:

Which two statements are true?

• A.PRODUCT _ic can be assigned the PRIMARY KEY constraint.
• B.PRODUCT_NAKE cannot contain duplicate values.
• C.EXPIRY_ DATE contains the sysdate by default if no date is assigned to it.
• D.EXPIRY_ DATE cannot be used in arithmetic expressions.
• E.PRODUCT _price can be used in an arithmetic expression even if it has no value stored in it.
• F.PRODUCT _price contains the value zero by default if no value is assigned to it.

Comment: *

Name: *

Email: *

Verification: *

Examine this command:

Which two statements are true? (Choose two.)

• A.DML may be performed on tables with one or more extents in this data file during the execution of this command.
• B.The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
• C.The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
• D.If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.
• E.The file is renamed and stored in the same location

Comment: *

Name: *

Email: *

Verification: *

Which two are true about complete recovery? (Choose two.)

• A.Uncommitted transactions will be rolled back after it completes.
• B.Only RMAN backupsets can be used to restore a database as part of it.
• C.It is possible only when the database is in MOUNT state
• D.Incremental backups can be used to roll forward the database while performing it.
• E.The database must have FLASHBACK enabled in order to perform it.

Comment: *

Name: *

Email: *

Verification: *