Which four actions are possible during an Online Data file Move operation? (Choose four.)

• A.Creating and dropping tables in the data file being moved
• B.Performing file shrink of the data file being moved
• C.Querying tables in the data file being moved
• D.Performing Block Media Recovery for a data block in the data file being moved
• E.Flashing back the database
• F.Executing DML statements on objects stored in the data file being moved

Comment: *

Name: *

Email: *

Verification: *

Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):

Which three are prerequisites for successful execution of the command? (Choose three.)

• A.The import operation must be performed by a user on the target database by a user with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user with the DATAPUMP_EXP_FULL_DATABASE role on the source database.
• B.All the user-defined tablespaces must be in read-only mode on the source database.
• C.The export dump file must be created before starting the import on the target database.
• D.The source and target database must be running on the same operating system (OS) with the same endianness.
• E.The impdp operation must be performed by the same user that performed the expdp operation.

Comment: *

Name: *

Email: *

Verification: *

Identify three situations in which messages are written to the alert log file. (Choose three.)

• A.Rebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block
  corrupted (file # 14, block # 50)"
• B.Inserting a value into a table returns "ORA-01722: invalid number"
• C.Updating a record in a table returns "ORA-00060: deadlock detected while waiting for resource"
• D.Running a query on a table returns "ORA-01578: ORACLE data block corrupted (file # 4, block # 131)"
• E.Inserting a value into a table returns "ORA-00001: unique constraint (SYS.PK_XXXX) violated"
• F.Creating a table returns "ORA-00955: name is already in used by an existing object"

Comment: *

Name: *

Email: *

Verification: *

What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archiving enabled?

• A.It fails with the ORA-665610 Invalid DDL statement on history-tracked message
• B.The rows in the table are truncated without being archived.
• C.The rows in the table are archived, and then truncated.
• D.The rows in both the table and the archive are truncated.

Comment: *

Name: *

Email: *

Verification: *

Flashback is enabled for your multitenant container database (CDB), which contains two pluggable
database (PDBs). A local user was accidently dropped from one of the PDBs.
You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB
and execute the following commands:
SQL > SHUTDOWN IMMEDIATE
SQL > STARTUP MOUNT
SQL > FLASHBACK DATABASE to TIME "TO_DATE ('08/20/12' , 'MM/DD/YY')";
Examine following commands:
1. ALTER PLUGGABLE DATABASE ALL OPEN;
2. ALTER DATABASE OPEN;
3. ALTER DATABASE OPEN RESETLOGS;
Which command or commands should you execute next to allow updates to the flashback back schema?

• A.Only 1
• B.Only 2
• C.Only 3
• D.3 and 1
• E.1 and 2

Comment: *

Name: *

Email: *

Verification: *