Oracle Database 12c: Advanced Administration
Question No: 21
Your database is running in archivelog mode. Examine the parameters for your database instance:
LOG_ARCHIVE_DEST_l =#39;LOCATION=/disk1/arch MANDATORY#39;
LOG_ARCHIVE_DEST_2 =#39;LOCATION=/disk2/arch#39; LOG_ARCHIVE_DEST_3 =#39;LOCATIO=/disk3/arch#39; LOG_ARCHIVE_DEST _4 =#39;LOCATIONs/disk4/arch#39;
LOG_ARCHIVE _MIN_SUCCEED_DEST = 2
While the database is open, you notice that the destination set by the log_archive_dest_1 parameter is not available. All redo log groups have been used.
What happens at the next log switch?
The database instance hangs and the redo logfiles are not overwritten.
The archived redo log files are written to the fast recovery area until the mandatory destination is made available.
The database instance is shutdown immediately.
The destination set by the log_archive_dest parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.
Question No: 22
You want to create a guaranteed restore point for your database by executing the command:
SQLgt; CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;
Identify two prerequisites for the successful execution of this command.
The database must be running in archivelog mode.
Flashback Database must be enabled.
Fast Recovery Area must be enabled.
The recyclebin must be enabled for the database.
Undo retention guarantee must be enabled.
A database backup must be taken.
Question No: 23
Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?
By default, EM express is available for a database after database creation.
You can use EM express to manage multiple databases running on the same server.
You can perform basic administrative tasks for pluggable databases by using the EM express interface.
You cannot start up or shut down a database instance by using create and configure pluggable databases by using EM express.
You can create and configure pluggable databases by using EM express.
Explanation: EM Express is built inside the database.
Oracle Enterprise Manager Database Express (EM Express) is a web-based database management tool that is built inside the Oracle Database. It supports key performance management and basicdatabase administration functions. From an architectural perspective, EM Express has no mid-tier or middleware components, ensuring that its overhead on the database server is negligible.
Question No: 24
Examine the backup requirement for your company:
Every Sunday, a backup of all used data file blocks is performed.
Every Wednesday and Friday, a backup of all the changed blocks since last Sunday#39;s backup is performed.
On all the other days, a backup of only the changed blocks since the last day#39;s backup is performed.
Which backup strategy satisfies the requirements?
level 0 backup on Sunday, cumulative incremental backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days
level 0 backup on Sunday, differential incrementalbackup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days
full database backup on Sunday, level 0 backup on Wednesday and Friday, and
cumulative incremental level 1 backup on all the other days
full database backup on Sunday, level 0 backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days
Question No: 25
Which two statements are true regarding the Oracle Data Pump export and import operations?
You cannot export data from a remote database.
You can rename tables during import.
You can overwrite existing dump files during export.
You can compress data but not metadata during export.
Answer: A,B Reference:http://docs.oracle.com/cd/B28359_01/server.111/b28319/dp_import.htm#BEHF FDCD
Question No: 26
Examine the command to create a pluggable database (PDB):
SQLgt; CREATE PLUGGABLE DATABASE pdb2 FROM pdb1
FILE_NAME-_CONVERT = (#39;/disk1/oracle/pdb1/#39;, #39;/disk2/oracle/pdb2/’) PATH_PREFIX= #39;/disk2/oracle/pdb2#39;;
Which two statements are true?
The pluggable database pdb2 is created by cloning pdb1 and is in mount state.
Details about the metadata describing pdb2 are stored in an XML file in the #39;/disk2/oracle/pdb2/#39; directory.
The tablespace specifications of pdb2 are the same as pdb1.
All database objects belonging to common users in PD3I are cloned in PD32.
pdb2 is created with its own private undo and temp tablespaces.
Reference:http://oracle-info.com/2013/07/27/12c-database-create-pdbs-plug-unplug/(see the table, 4throw)
Question No: 27
Identify two scenarios in which the RMAN crosscheck command canbe used.
when checking for backups that are not required as per the retention policy
when updating the RMAN repository if any of the archived redo log files have been deleted without using RMAN to do the deletes
when updating outdated information about backups that disappeared from disk or media or became corrupted and inaccessible
when synchronizing backups, which were not performed by using RMAN, with the RMAN repository
when listing backups that are required for recovery operations
Question No: 28
You are administering a multitenant container database (CDB) cdb1 that has multiple pluggable databases (PDBs). As the sys user on cdb$root, you execute the commands:
SQLgt; CREATE USER C##ADMIN IDENTIFIED BY orc1123;
SQLgt; GRANT CREATE SESSION to C##ADMIN CONTAINER=ALL; SQLgt; GRANT CREATE USER TO C##ADMIN CONTAINER=ALL;
Which two statements are true about the c##admin user that is created in all PDBs?
It can create only local users in all the PDBs.
It has a common schema for all the PDBs.
It can create common users only when it is logged in to the CDB.
It can create only local users in the CDB.
It can be granted only common roles in the PDBs.
Question No: 29
You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). You are connected to cdb$root as thesys user. You execute the commands:
SQLgt; CREATE USER C##ADMIN IDENTIFIED BY orcll23; SQLgt; CREATE ROLE C##CONNECT;
SQLgt; GRANT CREATE SESSION, CREATE TABLE, SELECT ANY TABLE TO C##CONNECT;
SQLgt; GRANT C##CONNECT to C##ADMIN CONTAINER=ALL;
Which statement istrue about the c##connect role?
It is created only in cdb$root and cannot be granted to the c##admin user with the container=all clause.
It is granted to the c##admin user only in the CDB.
It is granted to the c##admin user in all PDBs and can be granted only to a local user in a PDB.
It is granted to the c##admin user in all PDBs and can be granted object and system privileges for a PDB.
Question No: 30
You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance.
How can you detect the cause of the degraded performance?
Enable Memory Access Mode, which reads performance data from SGA.
Use emergency monitoring to fetch data directly from SGA for analysis.
Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest
Automatic Workload Repository (AWR) snapshots.
Use Active Session History (ASH) data and hang analysis in regular performance monitoring,
Run ADDM in diagnostic mode.
Explanation: * In most cases, ADDM output should be the first placethat a DBA looks when notified of a performance problem.
Performance degradation of the database occurs when your database was performing optimally in the past, such as 6 months ago, but has gradually degraded to a point where it becomes noticeable to the users. The Automatic Workload Repository (AWR) Compare Periods report enables you to compare database performance between two periods of time.
While an AWR report shows AWR data between two snapshots (or two points in time), the AWR Compare Periods report shows the difference between two periods (or two AWR reports with a total of four snapshots). Using the AWR Compare Periods report helps you to identify detailed performance attributes and configuration settings that differ between two time periods.
Reference: Resolving Performance Degradation Over Time
100% Free Download!
–Download Free Demo:1z0-063 Demo PDF
100% Pass Guaranteed!
–Download 2018 Latesttests 1z0-063 Full Exam PDF and VCE
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|