NEW QUESTION 1
Which statement is true about the Automatic Diagnostic Repository (ADR)?

• A. Space used by the ADR can be limited to a user-specified value.
• B. Space used by the ADR is limited based only on the retention period.
• C. The retention period for the ADR is set based on the space limit specified.
• D. When the ADR reaches the space limit, it deletes incident dumps and metadata before deleting old core dumps.
• E. Manual purging of all types of ADR files is allowed.

Answer: E

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
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 4
In which three situations would you recommend DB Replay to be used? (Choose three.)

• A. to check the impact of schema changes such as adding new indexes or materialized views
• B. to check the impact of database migration to the cloud
• C. to check the impact of changing the storage system or the network
• D. to check the impact of partitioning a table
• E. to check the impact of new optimizer statistics
• F. to check the impact of upgrading and patching databases

Answer: BCF

NEW QUESTION 5
Which two operations is theopcuser authorized to perform in an Oracle Database Cloud environment? (Choose two.)

• A. Log in to the database deployment compute node.
• B. Run some commands asroot.
• C. Run all commands asroot.
• D. Only run all commands asoracle.
• E. Only run some commands asoracle.

Answer: AC

NEW QUESTION 6
Which two statements are true about the In-Memory (IM) column store? (Choose two.)

• A. It may be used for columns in Index Organized Tables (IOTs)
• B. It may be used for columns in clustered tables
• C. IM area size is not controlled by Oracle Automatic Memory Management
• D. IM area size can be set at the CDB and PDB levels
• E. IM area size can be increased or decreased dynamically
• F. It is not used for partitioned tables

Answer: AE

NEW QUESTION 7
Which statement is true about policy expressions?

• A. A named policy expression is stored in the Data Masking format library.
• B. A named policy expression applied to a column in a redacted table overrides the default expression of its redaction policy.
• C. A redacted table can have only one policy expression defined on it.
• D. A policy expression can be applied to columns in different redacted tables.
• E. A named policy expression is stored in the Enterprise Manager Database Express repository.

Answer: C

NEW QUESTION 8
Which two are true about tables recovered by using theRMAN RECOVER TABLEcommand or the command itself, starting from Oracle Database 12c Release 2? (Choose two.)

• A. They may be recovered to a schema in a different PDB
• B. AnAUXILIARYinstance is started only if there is sufficient disk space
• C. They can be recovered by RMAN without anAUXILIARYinstance
• D. They must be un-partitioned tables
• E. They may be recovered to a different schema in the same pluggable database (PDB)

Answer: BE

NEW QUESTION 9
Examine this command:

Which statement is true?

• A. Up to four worker processes are allocated to export data and metadata
• B. Four worker processes are allocated to export only data
• C. Four worker processes are active to export only metadata
• D. Four worker processes are allocated to export data and metadata
• E. Four worker processes are allocated when there is sufficient CPU available

Answer: D

NEW QUESTION 10
Which two statements are true about clean restore points in a regular PDB? (Choose two.)

• A. They require a clone instance to be created when used in a PDB flashback operation
• B. They can be created for a PDB when connected to either the PDB or to the root
• C. They require backups to be restored when used in a PDB flashback operation
• D. They are created as guaranteed restore points
• E. They can be created only if shared undo is enabled
• F. They can be created only for a PDB in the mount state

Answer: EF

NEW QUESTION 11
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 12
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 13
In which situation can the optimizer choose a hash join?

• A. when a non-equijoin is used and the join column in at least one of the tables is a primary key
• B. when a non-equijoin is used and the join column for both tables is a primary key
• C. when a non-equijoin is used between a table and a sorted hash cluster
• D. when an equality operator is used
• E. when any self-join is done

Answer: D

NEW QUESTION 14
One of your databases supports an OLTP workload.
If a better plan is discovered for a statement, then you want that plan to be used. Which two can cause better plans to be used for a statement? (Choose two.)

• A. adaptive cursor sharing
• B. using literals in SQL statements
• C. SQL Access Advisor
• D. SQL Performance Analyzer
• E. adaptive execution plans

Answer: CE

NEW QUESTION 15
You want to partition theSALEStable on theCITYandSALE_DATEcolumns. Which three partitioning methods can you use? (Choose three.)

• A. range
• B. interval
• C. hash
• D. list
• E. virtual column-based

Answer: ACD

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
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 18
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 19
Which three types of database objects can have their columns stored in the In-Memory column store? (Choose three.)

• A. heap tables with composite primary key constraints
• B. heap tables with dependent materialized views
• C. clustered tables with dependent materialized views
• D. index-organized tables stored in system-defined tablespaces
• E. sys-owned objects stored in sysaux-defined tablespaces

Answer: BDE

NEW QUESTION 20
Which three statements are true about the SQL Performance Analyzer? (Choose three.)

• A. It recommends the use of SQL Tuning Advisor for regressed SQL statements.
• B. It recommends the creation of indexes for regressed SQL statements.
• C. It compares and analyzes execution plans for the SQL statements in a SQL Tuning Set (STS).
• D. It always executes triggers that are fired recursively inFULLDMLmode.
• E. It generates execution plans for each SQL statement in an STS.

Answer: ACE

NEW QUESTION 21
Your CDB has a PDB,EMP_PDB.
You successfully execute these commands as theSYSTEM USERinCDB$ROOT:

Which two statements are true aboutC##USR1?(Choose two.)

• A. It can connect toEMP_PDBand view the data only in tables created by common users.
• B. It can connect toEMP_PDBbut cannot view the data in any table in it.
• C. It can connect only to the root.
• D. It is a common user.
• E. It is a local user.

Answer: AE

NEW QUESTION 22
You log in to the ORCL database as SYSTEM and successfully execute these two blocks of code:

The SCOTT user has the SELECT privilege onHR.EMP.
Which statement is true about queries bynon-DBAusers with theSELECTprivilege onHR.EMP?

• A. All their queries display blanks forLAST_NAMEand the true contents of theSALARYcolumn.
• B. OnlySCOTT’Squeries display the true contents of theSALARYcolumn and blanks forLAST_NAME.
• C. All their queries display blanks forLAST_NAMEand zeroes forSALARY.
• D. OnlySCOTT’Squeries display the true contents of theSALARYandLAST_NAMEcolumns.
• E. OnlySCOTT’Squeries display zero forSALARYand the true contents of theLAST_NAMEcolumn.

Answer: A

NEW QUESTION 23
TheORCLCDB has a PDB,ORCL_PDB.
Examine these parameters inORCL:

Examine these parameters inORCL_PDB:

You switch toORCL_PDBand plan to execute these commands:

What will be the outcome?

• A. SGA_TARGETis set to 600M.The other values remain unchanged in bothORCLandORCL_PDB.
• B. SGA_TARGETis set to 600M andDB_CACHE_SIZEto 200M inORCL_PD
• C. The other values remain unchanged in bothORCLandORCL_PDB.
• D. SGA_TARGETandSGA_MAX_SIZEare set to 600M andDB_CACHE_SIZEto 200M inORCL_PD
• E. SGA_TARGETandSGA_MAX_SIZEare set to (1360-600)M andDB_CACHE_SIZEto 200M inORCL.
• F. Altering theDB_CACHE_SIZEresults in an error becauseSGA_TARGETshould be altered to 600M first.
• G. Altering theDB_CACHE_SIZEresults in an error because it cannot be altered in a PD
• H. SGA_TARGETsize is changed to 600 M.

Answer: D

NEW QUESTION 24
You create a new application container,SALES_APP, with applicationPDBs,SALES1_PDB, andSALES2_PDB.
You want to install theNEW_APPapplication inSALES1_PDBandSALES2_PDBby using:

Where should you execute these statements?

• A. All the statements should be executed in the application root.
• B. All the statements should be executed in the application seed.
• C. All the statements should be executed in theSALES1_PDBandSALES2_PDBapplication containers.
• D. BEGIN/END INSTALLstatements should be executed in the application root and the SYNC statement inSALES1_PDBandSALES2_PDB.
• E. BEGIN/END INSTALLstatements should be executed in the CDB root and the SYNC statement in the application root.

Answer: AD

NEW QUESTION 25
......