Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB andACCOUNTS_PDB, both of which use the CDB tablespace. The temp file is called 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 […]
Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:Which two statements are true about redefining the table?
Which two statements are true about the use of the procedures listed in thev$sysaux_occupants.move_procedure column?
Which statement is true about Oracle Net Listener?
You are administering a database stored in Automatic Storage Management (ASM). You useRMAN to back up the database and the MD_BACKUP command to back up the ASM metadataregularly. You lost an ASM disk group DG1 due to hardware failure.In which three ways can you re-create the lost disk group […]
Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has twopluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database.You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF data file forthe default permanent tablespace […]
Which Oracle Database component is audited by default if the unified Auditing option is enabled?
Your multitenant container (CDB) containing three pluggable databases (PDBs) is running inARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in 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. […]
Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database12c when it is enabled?
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 other tablespaces in your Oracle 12cdatabase?Both local and global partitioned B-tree Indexes are defined on the table.A high volume of […]