Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable 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 for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB is corrupted.
What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?（）
A. Place CDB1 in the mount stage and then the USERDATA tablespace offline in ACCOUNTS_PDb.
B. Place CDB1 in the mount stage and issue the ALTER PLUGGABLE DATABASE accounts_pdb CLOSE IMMEDIATE command.
C. Issue the ALTER PLUGGABLE DATABASE accounts_pdb RESTRICTED command.
D. Take the USERDATA tablespace offline in ACCOUNTS_PDb.
您可能感兴趣的试卷
你可能感兴趣的试题
You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure.
In which three ways can you re-create the lost disk group and restore the data?（）
A. Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.
B. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.
C. Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.
D. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.
E. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.
F. Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.
A. It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.
B. A single listener can service only one database instance and multiple remote client connections.
C. Service registration with the listener is performed by the process monitor (PMON) process of each database instance.
D. The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.
A. The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.
B. The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.
C. All the components may be moved into SYSAUX tablespace.
D. All the components may be moved from the SYSAUX tablespace.
Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:
Which two statements are true about redefining the table?（）
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 table is disabled during redefinition.
C. VPD policies are copied from the original table to the new table during online redefinition.
D. You must copy the VPD policies manually from the original table to the new table during online redefinition.
最新试题
The persistent configuration settings for RMAN have default for all parameters.Identify four RMAN commands that produce a multi-section backup.（）
Identify two situations in which the alert log file is updated.（）
In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.How would you accomplish this?（）
You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB).The characteristics of the non-CDB are as follows:-Version: Oracle Database 12c Releases 1 64-bit -Character set: WE8ISO8859P15 -National characterset: AL16UTF16 -O/S: Oracle Linux 6 64-bitThe characteristics of the CDB are as follows: -Version: Oracle Database 12c Release 1 64-bit -Characterset: AL32UTF8 -O/S: Oracle Linux 6 64-bitWhich technique should you use to minimize down time while plugging this non-CDB into the CDB?（）
Identify three benefits of Unified Auditing.（）
Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB. You execute the following command:SQL > CREATE UNDO TABLESPACE undotb01 DATAFILE ‘u01/oracle/rddb1/undotbs01.dbf’ SIZE 60M AUTOEXTEND ON;What is the result?（）
Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:SQL > SHUTDOWN IMMEDIATE SQL > STARTUP MOUNT SQL > FLASHBACK DATABASE to TIME “TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”;Examine following commands:1. ALTER PLUGGABLE DATABASE ALL OPEN;2. ALTER DATABASE OPEN;3. ALTER DATABASE OPEN RESETLOGS;Which command or commands should you execute next to allow updates to the flashback back schema?（）
Which two statements are true when row archival management is enabled?（）
In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20.Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?（）
Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.Which two RMAN commands may be; used to back up only the PDB1 pluggable database?（）