Skip to main content

1Z0-074 Real Exam Questions

Upgrade Oracle DBA 11g or 12c to 12c R2

75 questions available · Page 1 of 8

Updated Exam DumpsVerified AnswersPass Guarantee

Get Complete Exam Dumps
Question 1 Single choice

The TESTDB container database (CDB) running in ARCHIVELOG mode contains two pluggable databases (PDBs) PDB1 and PDB2. A connect descriptor for TESTDB is mapped to the TNS alias testdb in tnsnames.ora.
The default RMAN configuration is used.
Examine these commands:

Which files are backed up?

  1. A

    all root and PDB1 data files, and the CONTROLFILE, SPFILE, and FLASHBACKLOGS

  2. B

    all root and PDB1 data files, and the CONTROLFILE, SPFILE, and ARCHIVELOGS

  3. C

    all root and PDB1 data files, and the CONTROLFILE and SPFILE

  4. D

    all root and PDB1 data files, and the CONTROLFILE, SPFILE, ONLINE REDO LOG FILES, and

    ARCHIVELOGS

  5. E

    all root and PDB1 data files

Show answer and explanation

Correct answer: E

Explanation

References:
https://oracle-base.com/articles/12c/multitenant-rman-backup-recovery-cdb-and-pdb-12cr1

Question 2 Multiple choice

In which three situations would you recommend DB Replay to be used? (Choose three.)

  1. A

    to check the impact of schema changes such as adding new indexes or materialized views

  2. B

    to check the impact of database migration to the cloud

  3. C

    to check the impact of changing the storage system or the network

  4. D

    to check the impact of partitioning a table

  5. E

    to check the impact of new optimizer statistics

  6. F

    to check the impact of upgrading and patching databases

Show answer and explanation

Correct answers: B, C, F

Explanation

References:
https://www.oracle.com/technetwork/database/manageability/db-replay-ow08-134917.pdf

Question 3 Multiple choice

Which three resources can be controlled or managed by using Oracle Database Resource Manager? (Choose three.)

  1. A

    number of parallel queries issued by a consumer group

  2. B

    maximum number of DML operations performed by a consumer group

  3. C

    sessions that are blocking other sessions

  4. D

    sessions that are not blocking other sessions

  5. E

    UNDO quota for a consumer group

Show answer and explanation

Correct answers: A, C, E

Question 4 Single choice

You plan to use Information Lifecycle Management (ILM) for the ORDERS table.

Which is true about Heat Map statistics when HEAT_MAP is ON?

  1. A

    They are collected for all segments except for those in the SYSTEM and SYSAUX tablespaces, and are stored in the SYSTEM tablespace.

  2. B

    They are collected for all segments except for those in the SYSTEM and SYSAUX tablespaces, and are stored in the SYSAUX tablespace.

  3. C

    They are collected for all segments and are stored in the SYSAUX tablespace.

  4. D

    They are collected for all segments and are stored in the SYSTEM tablespace.

  5. E

    They are collected only for the ORDERS table if it has an associated ADO policy.

Show answer and explanation

Correct answer: D

Question 5 Single choice

You set the maximum size of the diagnostic collection repository by issuing this command as root.tfact1 set reposizeMB=5120 You then notice that the current repository size is 5 GB and that old files are not being purged.

Which statement is true?

  1. A

    The tfact1 command fails because it can be set only by the Oracle software owner.

  2. B

    TFA collects new diagnostic data if the Max Size of TFA Log parameter value is greater than 5 GB.

  3. C

    TFA does not collect new diagnostic data when the maximum repository size is reached.

  4. D

    TFA collects new diagnostic data but logs a warning message.

  5. E

    TFA collects new diagnostic data while the repository directory's file system has free space.

Show answer and explanation

Correct answer: A

Explanation

References:
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/atnms/provisioning-access-to-users.html#GUID-C3CF0056-0869-4AC2-99CC-9D0ACF848A46

Question 6 Multiple choice

HR.EMP.EMPLOYEE_ID is the primary key of the HR.EMP partitioned table, which contains 108 rows and resides in the EXAMPLE tablespace.
HR executes this command:
SQL> CREATE TABLE employees TABLESPACE users FOR EXCHANGE WITH TABLE hr.emp;
Table created.

Which two statements are true? (Choose two.)

  1. A

    Dependent objects of HR.EMP are automatically created for HR.EMPLOYEES.

  2. B

    HR.EMP is moved to the USERS tablespace.

  3. C

    The column names HR.EMP and HR.EMPLOYEES are identical.

  4. D

    The HR.EMPLOYEES table has 108 records.

  5. E

    HR.EMPLOYEES.EMPLOYEE_ID is the PRIMARY KEY of HR.EMPLOYEES

  6. F

    The column order HR.EMP and HR.EMPLOYEES are identical

Show answer and explanation

Correct answers: C, F

Question 7 Single choice

USER1 is an OS user with the password oracle and is only a member of the oinstall group.
In the ORCL database, the OS_AUTHEN_PREFIX value is ops$.

Examine these commands executed by the DBA:
SQL> CREATE USER ops$user1 IDENTIFIED externally;
SQL> GRANT create session TO ops$user1;

How can USER1 be given the SYSRAC privilege?

  1. A

    Make User1 a member of the OSDBA group in Linux or the ORA_%HOMENAME%_SYSDBA group in Windows only.

  2. B

    Grant SYSRAC to user1.

  3. C

    Grant SYSRAC to ops$user1.

  4. D

    Make USER1 a member of the OSRACDBA group in Linux or the ORA_%HOMENAME%_SYSRAC group in Windows.

  5. E

    Grant SYSDBA to ops$user1

Show answer and explanation

Correct answer: C

Question 8 Single choice

Examine these statements executed in the PROD1 database:

Which statements are audited?

  1. A

    only the CREATE USER statement

  2. B

    only the ALTER SYSTEM statements

  3. C

    only the CREATE USER statement and the first change to JOB_QUEUE_PROCESSES

  4. D

    only the changes to JOB_QUEUE_PROCESSES and the CREATE USER statement

  5. E

    all the statements

Show answer and explanation

Correct answer: D

Question 9 Multiple choice

A multi-tenant container database (CDB) contains three PDBs.

Which three are prerequisites for performing a cross-platform transport of any of the PDBs? (Choose three.)

  1. A

    The CDB should be in MOUNT state.

  2. B

    The source and target platforms must have the same endianness.

  3. C

    The COMPATIBLE parameter must be set to 12.2 or greater in the CDB.

  4. D

    The source PDBs must be closed for a cross-platform PDB backup.

  5. E

    Flashback database must be enabled for the CDB.

  6. F

    The CDB must use Automatic Memory Management.

Show answer and explanation

Correct answers: B, C, D

Explanation

References:
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/bradv/rman-transporting-data-across-platforms.html#GUID-B0178538-6E41-455D-8166-FBB1EDC5D198

Question 10 Single choice

In TESTDB, U1 has SYSDBA privileges and the password Oracle_4U.
You recreate the password file:
$ orapwd FILE=orapwtestdb FORMAT=12.2 password=Oracle_123 ENTRIES=5

Examine the command and result:
$ sqlplus u1/Oracle_4U@testdb as sysdba

ERROR:
ORA-01017: invalid username/password; logon denied

What can you do to fix this error?

  1. A

    Recreate the password file with the password set to Oracle_4U.

  2. B

    Change the password of U1 to Oracle_123.

  3. C

    Set the REMOTE_LOGIN_PASSWORDFILE parameter value to NONE.

  4. D

    Regrant SYSDBA to U1.

  5. E

    Restart the database instance.

Show answer and explanation

Correct answer: A

Explanation

References:
https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:670117794561