Exam information

Exam 1z0-060: Upgrade to Oracle Database 12c

Other exams

A user issues a query on a table on one of the PDBs and receives the following error…

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 […]

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?

Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column?

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?

Which statement is true about Oracle Net Listener?

which three ways can you re-create the lost disk group and restore the data?

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 […]

What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?

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?

Which Oracle Database component is audited by default if the unified Auditing option is enabled?

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

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 Database 12c when it is enabled?

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…?

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 […]

Page 1 of 1512345...10...Last »