Oracle Database 12c: Advanced Administration
Question No: 51
Which three statements are true about the startup and shutdown of multitenant container databases (CDBs) and pluggable databases (PDBs)?
A PDB opened in restricted mode allows only local users to connect.
When a CDB is open in restricted mode, PDBs must also be opened in restricted mode.
When a CDB is in mount state, PDBs are automatically placed in mount state.
All PDBs must be shut down before shutting down a CDB instance.
When a CDB instance is started, PDBs can be placed in open state by using database triggers or by executing the alter pluggable databasecommand.
Question No: 52
Which two statements are true abouta multitenant architecture?
Each pluggable database (PDB) has its own initialization parameter file.
A PDB can have a private undo tablespace.
Log switches occur only at the container database level.
A PDB can have a private temporary tablespace.
Each PDB has a private control file.
Question No: 53
The environmental variable oracle_Base is set to /u01/app/oracleand oracle_home is set to
You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR). Examine the initialization parameters set in your database.
———————- ———- ————————
What is the location of the ADR base?
It is set to/u01/app/oracle/product:/12.1.0/db_1/log.
It is set to /u01/app/oracle/admin/enl2ramp;p/adump.
It is set to /u01/app/oracle.
It is set to/u01/app/oracle/flash_recovery_area.
Answer: A Explanation:
The Automatic Diagnostic Repository (ADR) is a directory structure that is stored outside of the database. It is therefore available for problem diagnosis when the database is down.
The ADR root directory is known as ADR base. Its location is set by the DIAGNOSTIC_DEST initialization parameter. If this parameter is omitted or left null, the database sets DIAGNOSTIC_DEST upon startup as follows:
If environment variable ORACLE_BASE is set, DIAGNOSTIC_DEST is set to the directory designated by ORACLE_BASE.
If environment variable ORACLE_BASE is not set, DIAGNOSTIC_DEST is set to ORACLE_HOME/log.
Question No: 54
View the SPFILE parameter settings in the Exhibit.
You issue this command and get errors: SQLgt; startup
ORA-00824:cannotsetSGAJTARGET or MEMORY_TARGET dueto existing internalsettings,seealertlog for moreinformation
Why did the instance fail to start?
because pga_aggregate_target is not set
because statistics_level is set to basic
because memory_target and memory_max_target cannot be equal
because sga_target and memory_target are both set
Question No: 55
You are connected to a pluggable database (PDB) as a common user with the sysdba privilege. The PDB is open and you issue the shutdown immediate command.
What is the outcome?
The PDB is closed.
The PDB is placed in mount state.
The command executes only if the common user is granted the set container privilege for the PDB.
The command results in an error because the PDB can be shut down only by a local user.
Question No: 56
Identify three benefits of unified auditing.
It helps to reduce disk space used to store an audit trail in a database.
It guarantees zero-loss auditing.
It reduces overhead on a database caused by auditing,by having a single audit trail.
An audit trail cannot be modified because it is read-only.
It automatically audits Recovery Manager (RMAN) events.
Question No: 57
Your database is running in archivelog mode. You are taking a backup of your database by using RMAN with a recovery catalog. Because of a media failure, one of the data files and all the control files are lost.
Examine the steps to recover the database:
1.Restore the control filesby using the RMAN restore controlfile command. 2.Mount the database.
3.Restore the data files by using the RMAN restore database command. 4.Open the database with the resetlogs option.
Recover the data files by using the RMAN recover using backup controlfile command.
Start the database instance in nomount state.
Connect to the target database by using a recovery catalog. 8.Open the database.
9.Restore the data file. 10.Recover the data file.
Identify the required steps in the correct order.
A. 7,6, 1, 2, 3, 5, 4
B. 7, 2, 1, 3, 5, 8
C. 7, 6, 1, 2, 9, 10, 8
D. 7, 6, 1, 2, 9, 10, 4
Question No: 58
You want RMAN to make duplicate copies of data files when using the backup command. What must you set using the RMAN configure command to achieve this?
MAXSETSIZE TO 2;
DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
CHANNEL DEVICE TYPE DISK FORMAT #39;/disk1/%U#39; , #39;/disk2/%U#39;;
DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
Question No: 59
You created a tablespace with this statement:
CREATE BIGFILE TABLESPACE adtbs
DATAFILE #39;/proddb/data/adtbs.dbf#39; SIZE 10G;
The tablespace is nearly full and youneed to avoid any out of space errors for the load of a 5 gig table.
Which two alter statements will achieve this?
ALTER TA3LESPACE adtbs RESI2E 20G;
ALTER TA3LESPACE adtbs ADD DATAFILE;
ALTER TABLESPACE adtbs AUTOEXTEND ON;
ALTER TA3LESPACE adtbs ADD DATAFILE #39;/proddb/data/adtbsl.dbf#39; SIZE 1QG;
ALTER TA3LESPACE adtbs MODIFY DATAFILE #39;/proddb/data/adtbs.dbf AUTOEXTEND ON;
Question No: 60
Which two statements are true about a common user?
A common user connected to a pluggable database (PDB) can exercise privileges across other PDBs.
A common user with the create user privilege can createother common users, as well as local users.
A common user can be granted only a common role.
A common user can have a local schema in a PDB.
A common user always uses the global temporary tablespace that is defined at the CDB level as the default temporary tablespace.
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|