1z0-074 Exam - Upgrade Oracle DBA 11g/12c to 12cR2

NEW QUESTION 1
HR.EMP.EMPLOYEE_IDis the primary key of theHR.EMPpartitioned table, which contains 108 rows and resides in theEXAMPLEtablespace.
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. Dependent objects ofHR.EMPare automatically created forHR.EMPLOYEES.
• B. HR.EMPis moved to theUSERStablespace.
• C. The column namesHR.EMPandHR.EMPLOYEESare identical.
• D. TheHR.EMPLOYEEStable has 108 records.
• E. HR.EMPLOYEES.EMPLOYEE_IDis thePRIMARY KEYofHR.EMPLOYEES
• F. The column orderHR.EMPandHR.EMPLOYEESare identical

Answer: CF

NEW QUESTION 2
Examine these statements:

Which statement is true?

• A. Statements 2 and 3 will validate the conversion
• B. Only statement 3 will validate the conversion
• C. Only statement 1 will validate the conversion
• D. Statement 1 will return an error
• E. All the statements will validate the conversion

Answer: B

NEW QUESTION 3
Which statement is true about Trace File Analyzer (TFA) Collector?

• A. TFA collects diagnostic data only for Oracle 12c Release 2 databases or later versions.
• B. If TFA is installed on any cluster node, it automatically collects diagnostic data on all other cluster nodes.
• C. It can be used to collect diagnostic data for predefined events, and can be configured to automatically collect data for other events.
• D. In Oracle 12c Release 2, TFA installation can be done only while executingroot.sh.
• E. It is used to collect diagnostic data only for ORA-600, ORA-7445, and ORA-4031 events.

Answer: D

NEW QUESTION 4
TheEMP_CDB1andEMP_CDB2CDBs are in ARCHIVELOG mode. Oracle Managed Files is enabled in both CDBs.
EMP_CDB1has a PDB,EMP_PDB1.
InEMP_CDB2, you log in as theSYSuser. You plan to execute this statement:
CREATE PLUGGABLE DATABASE emp_pdb2 FROM emp_pdb1@emp_link RELOCATE; Which two statements are true? (Choose two.)

• A. TheAVAILABILITY MAXclause should be added to the command to ensure transaction consistency during the relocation process.
• B. SYSOPERprivilege should be granted to the user defined inEMP_LINKand used to connect to the remotedatabase.
• C. EMP_PDB2should be opened in read-write mode to complete the relocation process.
• D. EMP_PDB1should be dropped manually fromEMP_CDB1after executing the relocating command.
• E. EMP_LINKshould exist as a public link inEMP_CDB1andEMP_CDB2.
• F. OnlyEMP_PDB1should be in local undo mode.

Answer: CE

NEW QUESTION 5
TheCOMPATIBLEparameter is set to 12.2.0.0.0.
Which two statements are true about SQL identifier lengths? (Choose two.)

• A. Disk group, PDB, and tablespace names are limited to 30 bytes.
• B. Table names can be as long as 128 bytes.
• C. Database names can be as long as 30 bytes.
• D. Database link names can be as long as 30 bytes.
• E. Database names can be as long as 128 bytes.

Answer: BE

NEW QUESTION 6
Which three database objects can have columns stored in the In-Memory (IM) column store? (Choose three.)

• A. subpartitions
• B. clustered tables
• C. materialized views
• D. index-organized tables
• E. heap tables
• F. any SYS owned objects

Answer: BDF

NEW QUESTION 7
In which four situations does theRMAN DUPLICATEcommand use the “pull” method? (Choose four.)

• A. when theUSING BACKUPSETclause is used
• B. when theSET ENCRYPTIONclause is added before theDUPLICATEcommand
• C. when theSECTION SIZEclause is used
• D. when the number of auxiliary channels allocated is less than the number of target channels allocated
• E. when theUSING COMPRESSED BACKUPSETclause is used
• F. when no auxiliary channels are allocated
• G. whenIMAGE COPIESare used for theDUPLICATEoperation

Answer: ACDE

NEW QUESTION 8
InTESTDB, U1hasSYSDBAprivileges and the passwordOracle_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. Recreate the password file with the password set toOracle_4U.
• B. Change the password ofU1 to Oracle_123.
• C. Set theREMOTE_LOGIN_PASSWORDFILEparameter value to NONE.
• D. RegrantSYSDBA to U1.
• E. Restart the database instance.

Answer: A

NEW QUESTION 9
ACDB,CDB1, has aLOCATIONSapplication container. NORTH_PDBandSOUTH_PDBare two application PDBs inLOCATIONS.
Both application PDBs are synchronized with the application installed in theLOCATIONS root… InCDB2, you create a remote clone,LOC_R, of theLOCATIONSapplication root.
You want to query data across theLOCATIONSapplication PDBs created inCDB1andCDB2. How can you do this?

• A. by creating a proxy PDB inLOCATIONS_ROOTinCDB1, referencingLOC_R
• B. by creating a proxy PDB inCDB1root, referencingLOC_R
• C. by using private database links created inCDB1andCDB2
• D. by using public database links created inCDB1andCDB2
• E. by creating a proxy PDB inCDB2root, referencingLOC_R

Answer: E

NEW QUESTION 10
You plan to use Information Lifecycle Management (ILM) for theORDERStable. Which is true about Heat Map statistics whenHEAT_MAPisON?

• A. They are collected for all segments except for those in theSYSTEMandSYSAUXtablespaces, and are stored in theSYSTEMtablespace.
• B. They are collected for all segments except for those in theSYSTEMandSYSAUXtablespaces, and are stored in theSYSAUXtablespace.
• C. They are collected for all segments and are stored in theSYSAUXtablespace.
• D. They are collected for all segments and are stored in theSYSTEMtablespace.
• E. They are collected only for theORDERStable if it has an associated ADO policy.

Answer: D

NEW QUESTION 11
The TESTDB container database (CDB) running inARCHIVELOGmode contains two pluggable databases (PDBs)PDB1andPDB2.
A connect descriptor forTESTDBis mapped to the TNS aliastestdb in tnsnames.ora. The defaultRMANconfiguration is used.
Examine these commands:

Which files are backed up?

• A. all root andPDB1data files, and theCONTROLFILE, SPFILE, andFLASHBACKLOGS
• B. all root andPDB1data files, and theCONTROLFILE, SPFILE, andARCHIVELOGS
• C. all root andPDB1data files, and theCONTROLFILEandSPFILE
• D. all root andPDB1data files, and theCONTROLFILE, SPFILE, ONLINE REDO LOG FILES, and ARCHIVELOGS
• E. all root andPDB1data files

Answer: E

NEW QUESTION 12
TheTESTDBcontainer database (CDB) contains two pluggable databases (PDBs),PDB1andPDB2. USER1is a local user inPDB1and has theSYSBACKUPprivilege.
Connect descriptors for PDB1 and PDB2 are mapped to TNS aliasespdb1andPDB2intnsnames.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 connected to a pluggable database.
• B. The current date is displayed.
• C. An error is returned because SQL commands cannot be executed from RMAN without using the SQL shell syntax:SQL”<command>”.
• D. An error is returned because the user is notSYS.
• E. An error is returned because the user is not a common user.

Answer: C

NEW QUESTION 13
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 inMOUNTstate.
• B. The source and target platforms must have the same endianness.
• C. TheCOMPATIBLEparameter must be set to 12.2 or greater in the CDB.
• D. The source PDBs must be closed for a cross-platform PDB backup.
• E. Flashback database must be enabled for the CDB.
• F. The CDB must use Automatic Memory Management.

Answer: BCD

NEW QUESTION 14
In which two situations does theINHERIT ANY PRIVILIGESprivilege regulate the privileges used?

• A. when a user creates a new user
• B. when a user performs a GRANT or REVOKE operation
• C. when a user queries aBEQUEATH CURRENT_USERview that references an invoker’s right procedure
• D. when a user runs a procedure created with invoker’s right
• E. when a user runs a procedure created with definer’s right

Answer: CD

NEW QUESTION 15
Which three statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose three.)

• A. It analyzes only those memory components of the database instance that are impacting performance.
• B. It determines the segments on which waits are occurring when the database has a high number of buffer busy waits.
• C. It analyzes the performance of the database instance based on the latest two AWR snapshots.
• D. It determines SQL statements that are performing poorly.
• E. It recommends implementing SQL profiles to generate better execution plans.
• F. It analyzes only the components and waits that are impacting database performance.

Answer: BCD

NEW QUESTION 16
To which two components does the term “shape” refer in Oracle Database Cloud Service (DBaaS)? (Choose two.)

• A. number of network interface cards (NICs)
• B. number of database instances
• C. number of CPUs
• D. amount of RAM
• E. number of storage LUNs

Answer: CD

NEW QUESTION 17
In a Database Cloud Service (DBCS) environment, which pre-created user hassudoprivileges to run certainrootcommands?

• A. grid
• B. oracle
• C. opc
• D. nobody
• E. oinstall

Answer: C

NEW QUESTION 18
You want to restrict PGA usage to 200 MB for a set of database users’ sessions as part of your organization’s security requirements for combating denial of service (DOS) attacks.
Which statement is true about limiting PGA usage for those users’ sessions?

• A. You can limit their PGA usage by settingSORT_AREA_SIZEto 200 MB.
• B. You cannot limit PGA for a set of database user sessions.
• C. You can limit their PGA usage by settingPGA_AGGREGATE_LIMITto 200 MB.
• D. You can limit their PGA usage by settingPGA_AGGREGATE_TARGETto 200 MB.
• E. You can limit their PGA usage by setting theSESSION_PGA_LIMITdirective by using Database ResourceManager

Answer: C

NEW QUESTION 19
APP1is an application container that has an application seed and two application PDBs,APP_PDB1andAPP_PDB2.
1.1 is the current version of the application. You execute this block in the application root:

What is the outcome?

• A. An error is thrown because the version number should be sequential, either 1.1 or 2.0.
• B. An error is thrown because theCONTAINER=ALLclause is missing.
• C. An error is thrown because thec##prefix is missing in the role name.
• D. A common role is created only in the application root.
• E. A common role is created only in the application root and application seed.
• F. A common role is created in the application root, application seed,APP_PDB1, andAPP_PDB2.

Answer: D

NEW QUESTION 20
You create and enable a unified audit policy on a database that has the default auditing configuration.

The OE user, who has the DBA role, executes these statements.

What is true about the SELECT statement and why?

• A. It is audited because unified auditing is disabled be default.
• B. It is audited because, by default, the database is in mixed auditing mode with default policies enabled.
• C. It is audited because, by default, all user activities in the database are audited.
• D. It is not audited because the table belongs to another schemA.
• E. It is not audited because audit records are stored only when unified auditing is enabled in the database.

Answer: C

NEW QUESTION 21
The In-Memory compression level is set toMEMCOMPRESS FOR QUERY HIGH. For what purpose is this optimized?

• A. for parallel query performance only
• B. for query performance and space saving
• C. for query performance and space saving with greater bias toward space saving
• D. for query performance only
• E. for space saving only

Answer: B

NEW QUESTION 22
......