Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and ACCOUNTS_PDB,

Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and ACCOUNTS_PDB, both of which use the CDB tablespace. The temp file iscalled temp01.tmp. A user issues a query on a table on one of the PDBs and receives the following error:ERROR at line 1:ORA-01565: error in identifying file `/u01/app/oracle/oradata/CDB1/temp01.tmp’ORA-27037: unable to obtain file status […]

Read More

Which two statements are true about redefining the table?

Examine the following commands for redefining a table with Virtual Private Database (VPD) policies: Which two statements are true about redefining the table? (Choose two.) A. All the triggers for the table are disabled without changing any of the column names or column types in the table. B. The primary key constraint on the EMPLOYEES […]

Read More

Which option identifies the correct sequence to recover the SYSAUX tablespace?

Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find that the SYSAUX tablespace is corruptedin the root container. The steps to recover the tablespace are as follows: 1. Mount the CDB.2. Close all the PDBs.3. Open the database.4. Apply the archive redo logs.5. Restore the data file.6. Take […]

Read More

Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database

Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled? A. Reduced logical I/O B. Reduced virtual memory utilization C. Improved parallel Execution performance D. Improved Serial Execution performance E. Reduced physical I/O F. Reduced CPU utilization Explanation:* Multiprocess and Multithreaded Oracle Database Systems Multiprocess Oracle Database […]

Read More

Which three statements are true about this requirement?

In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to othertablespaces in your Oracle 12c database? Both local and global partitioned B-tree Indexes are defined on the table. A high volume of transactions access the table during the […]

Read More

What are three purposes of the RMAN “FROM” clause?

What are three purposes of the RMAN “FROM” clause? A. to support PUSH-based active database duplication B. to support synchronization of a standby database with the primary database in a Data environment C. to support PULL-based active database duplication D. to support file restores over the network in a Data Guard environment E. to support […]

Read More

How can you detect the cause of the degraded performance?

You notice that the performance of your production 24/7 Oracle 12c database significantly degraded. Sometimes you are not able to connect to the instancebecause it hangs. You do not want to restart the database instance. How can you detect the cause of the degraded performance? A. Enable Memory Access Mode, which reads performance data from […]

Read More

Which three storage options support the use of HCC?

You plan to use the In-Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed(HCC) format. Which three storage options support the use of HCC? (Choose three.) A. ASM disk groups with ASM disks consisting of Exadata Grid Disks. B. ASM disk groups with […]

Read More