Examine this command:

Which two statements are true? (Choose two.)

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

Comment: *

Name: *

Email: *

Verification: *

Which is true about roles?

• A.All roles belong to the SYSTEM schema.
• B.Roles can be created only by SYS or SYSTEM.
• C.Roles containing object privileges can be created only by the object owner.
• D.A role can be granted to other roles.
• E.A role can be password-protected only if it has been granted system privileges.

Comment: *

Name: *

Email: *

Verification: *

Which three failures require intervention for recovery? (Choose three.)

• A.a user error such as dropping the wrong table
• B.statement failure
• C.media failure
• D.user process failure
• E.network interface card (NIC) failure

Comment: *

Name: *

Email: *

Verification: *

Which two tasks can be performed in the NOMOUNT state? (Choose two.)

• A.enabling online redo log archiving
• B.full database recovery
• C.creating a database
• D.renaming data files
• E.re-creating control files

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the DUAL table? (Choose two.)

• A.It consists of a single row and single column of VARCHAR2 data type
• B.It can be accessed by any user who has the SELECT privilege in any schema
• C.It can display multiple rows and columns
• D.It can be accessed only by the SYS user
• E.It can display multiple rows but only a single column
• F.It can be used to display only constants or pseudo columns

Comment: *

Name: *

Email: *

Verification: *