Oracle Upgrade Oracle DBA 11g or 12c to 12c R2 - 1z1-074 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

You plan to use Information Lifecycle Management (ILM) for the ORDERS table.
Which is true about Heat Map statistics when HEAT_MAP is ON?

A. They are collected only for the ORDERS table if it has an associated ADO policy. B. They are collected for all segments except for those in the SYSTEM and SYSAUX tablespaces, and are stored in the SYSTEM tablespace. C. They are collected for all segments and are stored in the SYSTEM tablespace. D. They are collected for all segments and are stored in the SYSAUX tablespace. E. They are collected for all segments except for those in the SYSTEM and SYSAUX tablespaces, and are stored in the SYSAUX tablespace.

Discussion 0

Correct Answer: C Vote an answer

Question 2

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.)

A. HR.EMPLOYEES.EMPLOYEE_ID is the PRIMARY KEY of HR.EMPLOYEES B. HR.EMP is moved to the USERS tablespace. C. The column order HR.EMP and HR.EMPLOYEES are identical D. Dependent objects of HR.EMP are automatically created for HR.EMPLOYEES. E. The HR.EMPLOYEES table has 108 records. F. The column names HR.EMP and HR.EMPLOYEES are identical.

Discussion 0

Correct Answer: C,F Vote an answer

Question 3

The TESTDB container database (CDB) contains two pluggable databases (PDBs), PDB1 and PDB2.
USER1 is a local user in PDB1 and has the SYSBACKUP privilege.
Connect descriptors for PDB1 and PDB2 are mapped to TNS aliases pdb1 and PDB2 in tnsnames.ora.
Examine these commands executed by USER1 when all PDBs are open:

What is the outcome and why?

A. An error is returned because the user is not SYS. B. An error is returned because the user is connected to a pluggable database. C. An error is returned because SQL commands cannot be executed from RMAN without using the SQL shell syntax: SQL"<command>". D. The current date is displayed. E. An error is returned because the user is not a common user.

Discussion 0

Correct Answer: D Vote an answer

Question 4

Which method can be used to migrate from an on-premises Oracle Database 11g to Oracle Database 12c in the cloud if the on-premises platform is big-endian?

A. Data Pump Transportable Tablespace for all tablespaces B. remote cloning C. Oracle Loader-type external tables D. RMAN Transportable Tablespace with Data Pump for all tablespaces E. Data Pump Conventional Export/Import

Discussion 0

Correct Answer: D Vote an answer

Question 5

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

A. sessions that are blocking other sessions B. sessions that are not blocking other sessions C. UNDO quota for a consumer group D. number of parallel queries issued by a consumer group E. maximum number of DML operations performed by a consumer group

Discussion 0

Correct Answer: A,C,D Vote an answer

Question 6

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?

A. Regrant SYSDBA to U1. B. Change the password of U1 to Oracle_123. C. Recreate the password file with the password set to Oracle_4U. D. Set the REMOTE_LOGIN_PASSWORDFILE parameter value to NONE. E. Restart the database instance.

Discussion 0

Correct Answer: C Vote an answer

Question 7

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.)

A. The CDB should be in MOUNT state. B. The CDB must use Automatic Memory Management. C. Flashback database must be enabled for the CDB. D. The source PDBs must be closed for a cross-platform PDB backup. E. The COMPATIBLE parameter must be set to 12.2 or greater in the CDB. F. The source and target platforms must have the same endianness.

Discussion 0

Correct Answer: D,E,F Vote an answer

Question 8

You execute this command in your database:
ALTER SYSTEM SET ENCRYPT_NEW_TABLESPACES = DDL;
How does this affect the creation of tablespaces?

A. User tablespaces with no ENCRYPTION clause specified in the CREATE TABLESPACE statement are transparently encrypted with AES128 only in the cloud. B. TEMP and UNDO tablespaces are transparently encrypted with AES128 by default in an on-premise database. C. TEMP and UNDO tablespaces are transparently encrypted with AES128 by default only in the cloud. D. User tablespaces with no ENCRYPTION clause specified in the CREATE TABLESPACE statement are transparently encrypted with AES128 only in an on-premise database. E. User tablespaces with no ENCRYPTION clause specified in the CREATE TABLESPACE statement are not encrypted anywhere.

Discussion 0

Correct Answer: C Vote an answer