Oracle Database 12c: Advanced Administration
Question No: 31
Examine the commands executed in CDBS ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB):
SQLgt; CREATE ROLE c ##role1 CONTAINER-ALL;
SQLgt; GRANT CREATE SESSION, CREATE TABLE TO c##role1 CONTAINER#39;ALL; SQLgt;CREATE USER c##adnin IDENTIFIED BY orcl123;
SQLgt;GRANT c##role1 TO c##admin CONTAINER=ALL;
SQLgt; GRANT SELECT ON DBA_USERS to c##rola1 CONTAINER*ALL;
Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1role?
The command fails and gives an error because object privileges cannot be granted to a common user.
The command fails because container is not set to current.
The command succeeds and the common user cmadnxn can create a session and query the D3A_users view incdbssoo? and all the PDBs.
The command succeeds and the common user ct (admin can create a session in cdbSroot and all the PDBs, but can only query the dba_users view in ct3S?cdt.
The command succeeds and the common user c#(admin can create a session and query the D3A users view only in cdbsrooi.
Question No: 32
Examine the steps to configure Oracle Secure Backup (OSB) for use with RMAN:
Create media families for data files and archived redo log files.
Configure database backup storage selectors or RMAN media management parameters. 3.Create an OSB user preauthorized for RMAN operations.
Configure RMAN Access to the OSB SBT.
Disable Non-Uniform Memory Access (NUMA) awareness by setting the ob_ignore_numa parameter to 0.
Identify the steps in the correct order.
A. 1, 4, 3, 2, 5
B. 1, 3, 4, 5, 2
C. 4, 3, 1, 2, 5
D. 4, 3, 5, 1, 2
Question No: 33
Examine the command to back up the ASM metadata:
In which three situations can you use the backup?
when one or more disks in an ASM disk group are lost
when the data file on an ASM disk group gets corrupted
when one of the disks in a disk group is accidentally unplugged
when one or more file directory paths are accidentally deleted from an ASM disk group
when all the ASM disk groups for the ASM instance are lost
Question No: 34
Which three conditions must be met before you create a Virtual Private Catalog (VPC)?
A base recovery catalog should exist.
The owner of VPC cannot own recovery catalog.
At least one target database should beregistered in the recovery catalog.
The register database privilege should be granted to the virtual catalog owner.
The recovery_catalog_owner role should be granted to the virtual catalog owner.
Question No: 35
You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference.
Which method or feature should you use?
Automatic Database Diagnostic Monitor (ADDM) Compare Period report
Active Session History (ASH) report
SQL Performance Analyzer
Question No: 36
Examine the commands executed to monitor database operations:
$gt; conn sys/oracle@prod as sysdba SQLgt; VAR eid NUMBER SQLgt;EXEC :eid :=
Which two statements are true?
Database operations will be monitored only when they consume a significant amount of resource.
Database operations for all sessions will be monitored.
Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC TUNING.
Only DML and DDL statements will be monitored for the session.
All subsequent statements in the session will be treated as one database operation and will be monitored.
Explanation: C: Setting the CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter to DIAGNOSTIC TUNING (default) enables monitoring of database operations. Real-Time SQL Monitoring is a feature of the Oracle Database Tuning Pack.
* The DBMS_SQL_MONITOR package provides information about Real-time SQL Monitoring and Real-time Database Operation Monitoring.
*(not B) BEGIN_OPERATION Function starts a composite database operation in the current session.
/ (E) FORCE_TRACKING – forces the composite database operation to be tracked when the operation starts. You can also use the string variable #39;Y#39;.
/ (not A) NO_FORCE_TRACKING – the operation will be tracked only when it has consumed at least 5 seconds of CPU or I/O time. You can also use the string variable #39;N#39;.
Question No: 37
Which two resources might be prioritized between competing pluggable databases (PDBs) when creating a multitenant container database(COB) plan using Oracle Database Resource Manager?
maximum undo per consumer group
maximum idle time for a session in a PDB
parallel server limit
maximum number of sessions for a PDB
Question No: 38
Examine these Data Pump commands to export and import objects from and to the same database.
The dba has not yet created users hr1 and oe1.
$expdp system/manager schemas = hr.oe directory = EXP_DIR dumpfile = export.dat include = table
schemas = hr1,oe1 directory = EXP_DIR dumpfile = export.dat
What will happen when running these commands?
expdp will fail because no path has been defined for the dumpfile.
expdp will succeed but impdp will fail because the users do not exist.
inpdp will create two users called hr1 and oe1 and import all objects to the new schemas.
impdp will create two users called hr1 and oe1 and import only the tables owned by hr and oe schemas to ht1 and oe1 schemas, respectively.
Question No: 39
RMAN is connected to the target database prod1 and an auxiliary instance in nomount state. Examine the command to create a duplicate database:
RMANgt; DUPLICATE TARGET DATABASE TO dup1 FROM ACTIVE DATABASE
NOFILENAMECHECK PASSWORD FILE SPFILE;
Which two statements are true about the execution of the duplicate command?
All archive redo log files are automatically copied to the duplicate database.
The duplicate database has the same directory structure as the source database.
The duplicate database is created by using the backups created during the execution of
the duplicate command.
The password file and SPFILE for theduplicate database dup1 are created in their respective default locations.
The duplicate database is created without using RMAN backups and prod: is allowed to remain open during duplication.
Question No: 40
You want to capture column group usage and gather extended statistics for better cardinality estimates for the customers table in the SH schema.
Examine the following steps:
Issue the SELECTDBMS_STATS. CREATE_EXTENDED_STATS(‘SH’, #39;CUSTOMERS#39;)from dual statement.
Execute the dbms_stats.seed_col_usage (null,’SH’,500) procedure. 3.Execute the required queries on the customers table.
4.Issue the select dbms_stats.reportwcol_usage(‘SH’, #39;customers#39;) from dual statement. Identify the correct sequence of steps.
A. 3, 2, 1, 4
B. 2, 3, 4, 1
C. 4, 1, 3, 2
D. 3, 2, 4, 1
Explanation: Step 1 (2). Seed column usage
Oracle must observe a representative workload, in order to determine the appropriate column groups. Using the new procedure DBMS_STATS.SEED_COL_USAGE, you tell Oracle how long it should observe the workload.
Step 2: (3)You don#39;t need to execute all of the queries in your work during this window. You can simply run explain plan for some of your longer running queries to ensure column group information is recorded for these queries.
Step 3. (1) Create the column groups
Atthis point you can get Oracle to automatically create the column groups for each of the tables based on the usage information captured during the monitoring window. You simply have to call the DBMS_STATS.CREATE_EXTENDED_STATS function for each table.This
function requires just two arguments, the schema name and the table name. From then on, statistics will be maintained for each column group whenever statistics are gathered on the table.
DBMS_STATS.REPORT_COL_USAGE reports column usage informationand records all the SQL operations the database has processed for a given object.
The Oracle SQL optimizer has always been ignorant of the implied relationships between data columns within the same table. While the optimizer has traditionally analyzedthe distribution of values within a column, he does not collect value-based relationships between columns.
Creating extended statistics
Here are the steps to create extended statistics for related table columns withdbms_stats.created_extended_stats:
-The first step is to create column histograms for the related columns.
– Next, we run dbms_stats.create_extended_stats to relate the columns together. Unlike a traditional procedure that is invoked via an execute (“exec”) statement, Oracle extended statistics are created via a select statement.
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|