Online Access Free 1z1-062 Practice Test

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 export dump file must be created before starting the import on the target database.
• B.The source and target database must be running on the same operating system (OS) with the same endianness.
• C.All the user-defined tablespaces must be in read-only mode on the source database.
• D.The impdp operation must be performed by the same user that performed the expdp operation.
• E.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.

Examine the contents of SQL loader control file:

Which three statements are true regarding the SQL* Loader operation performed using the control file?
(Choose three.)

• A.The SQL* Loader data file myfile1.dat has the column names for the EMP table.
• B.Field names should be the first line in the both the SQL* Loader data files.
• C.An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.
• D.The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.
• E.The SQL* Loader operation fails because no record terminators are specified.

Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and are granted system privileges.
You execute the command:
SQL>CREATE AUDIT POLICY tab1e_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ROLES hr_admin, oe_admin; Which statement is true?

• A.It succeeds and starts capturing only successful SQL statements for all users who have either the specified privileges or roles granted to them.
• B.It succeeds and needs to be enabled to capture all SQL statements that require either the specified privileges or any privilege granted to the HR_ADMIN and OE_ADMIN role.
• C.It fails because system privileges cannot be granted with roles in the same audit policy.
• D.It fails because the command does not specify when the unified audit policy should be enforced.

Which three file types are stored in the Fast Recovery Area by default in a traditional nonOMF file system?
(Choose three.)

• A.Flashback logs
• B.multiplexed copies of the current control file
• C.Flashback Data Archive files
• D.online redo log files
• E.archived log files
• F.parameter file

Which statement is true about using the Database Upgrade Assistant (DBUA) to upgrade your database from Oracle Database 11g to Oracle Database 12c?

• A.It terminates if the SYSTEM tablespace in the source database is not autoextensible.
• B.It automatically makes necessary changes to Oracle environment variables.
• C.It automatically enables unified auditing in the upgraded database.
• D.It automatically adds new data files if there is not enough disk space to grow.