Examine the following commands for redefining a table with Virtual Private Database (VPD)policies: Which two statements are true about redefining the table?
Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB andACCOUNTS_PDB, both of which use the CDB tablespace. The temp file is calledtemp01.tmp. A user issues a query on a table on one of the PDBs and receives thefollowing error: Identify two ways to rectify the error.
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). Youuse RMAN to back up the database and the MD_BACKUP command to back up the ASMmetadata regularly. You lost an ASM disk group DG1 due to hardware failure. In whichthree 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 thedatabase. You issue the command to open ACCOUNTS_PDB and find that theUSERDATA.DBF data file for the default permanent tablespace […]
Which Oracle Database component is audited by default if the unified Auditing option isenabled?
Your multitenant container (CDB) containing three pluggable databases (PDBs) is runningin ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the rootcontainer. The steps to recover the tablespace are as follows: Which option identifies thecorrect sequence to recover the […]
Which three are direct benefits of the multiprocess, multithreaded architecture of OracleDatabase 12c when it is enabled?
In order to exploit some new storage tiers that have been provisioned by a storageadministrator, the partitions of a large heap table must be moved to other tablespaces inyour Oracle 12c database? Both local and global partitioned B-tree Indexes are defined onthe table. A high volume of […]