Oracle Database 12c: Advanced Administration
Question No: 1
Examine the RMAN command:
RMANgt; SET ENCRYPTION IDENTIFIEDBY lt;passwordgt; ON FOR ALL TABLESPACES; RMANgt; BACKUP DATABASE PLUS ARCHIVELOG;
Which type of encryption is used for the backup performed by using this command?
Answer: A Reference:http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmbckad.htm#CEGE JABH(to make password -encrypted backups)
Question No: 2
Which two statements are true regarding SecureFile lobs?
The amount of undo retained is user controlled.
They can be used only for nonpartitioned tables.
Fragmentation is minimized by using variable-sized chunks.
They support random reads and writes of encrypted LOB data.
Answer: C,D Reference:http://docs.oracle.com/cd/E11882_01/appdev.112/e18294/adlob_smart.htm#AD LOB46113
Question No: 3
Which two statements are true about service creation for pluggable databases (PDBs)?
When a PDB is created, a service is automatically started in the instance with the same name as the PDB.
The defaultservice that is automatically created by a database at the time of PDB creation can be dropped, provided a new additional service is created.
A database managed by Oracle Restart can have additional services created or existing services modified by usingthe srvctl utility for each PDB.
Only a common user can create additional services for a PDB.
When a PDB is created, a service with the same name as the PDB is created in the PDB.
Question No: 4
Which two are prerequisites for creating a backup-based duplicate database?
connecting to the target database and a recovery catalog to execute the duplicate command
creating a password file for an auxiliary instance
connecting to an auxiliary instance
matching the database identifier (DBID) of the source database and the duplicate database
creating an SPFILE for the target database
Answer: A,B Reference:http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta020.htm#CH DEDFFH
Question No: 5
You must unload data from the orders, order_items, and products database tables to four filesusing the External Tables.
CREATE TABLE orders_ext
(order_id, order_date, product_id, product_name,quantity) ORGANIZATION EXTERNAL
TYPE ORACLE_DATAPUMP DEFAULT DIRECTORY ext.dir
) PARALLEL AS
SELECT o.order_id,o.order_date,p.product_id,p.product_name,i.quantity FROM orders o,productsp,order_itemsi
WHERE o.orderjd = i.order_id and i.product_id = p.product_id;
You execute the command shown in the Exhibit, but only two files are created. Which parameter must be changed so that four files are created?
Question No: 6
Examine the parameters for your database instance:
optimizer_adaptive_reporting_onlybooleanFALSE optimizer_capture_sql_plan_baselinesbooleanFALSE optimizer_dynamic_samplinginteger2
Which three statements are true about the process of automatic optimization by using statistics feedback?
The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.
The optimizer can re optimize a query only once using cardinality feedback.
The optimizer enables monitoring for cardinality feedback after the first execution of a query.
The optimizer doesnot monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.
After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.
Explanation: C: During the first execution of a SQL statement, an execution plan is generated as usual.
D: if multi-column statistics are not present for the relevant combination of columns, the optimizer can fall back on cardinality feedback.
(not B)* Cardinality feedback. This feature, enabled by default in 11.2, is intended to improve plans for repeated executions.
Dynamic sampling or multi-column statistics allow the optimizer to more accurately estimate selectivity of conjunctive predicates.
OPTIMIZER_DYNAMIC_SAMPLING controls the level of dynamic sampling performed by the optimizer.
Range of values. 0 to 10
Cardinality feedback was introduced in Oracle Database 11gR2. The purpose of this feature is toautomatically improve plans for queries that are executed repeatedly, for which the optimizer does not estimate cardinalities in the plan properly. The optimizer may misestimate cardinalities for a variety of reasons, such as missing or inaccurate statistics, or complex predicates. Whatever the reason for the misestimate, cardinality feedback may be able to help.
Question No: 7
You want to move your existing recovery catalog to another database.
Examine the steps:
Export the catalog data by using the Data Pump Export utility in the source database.
Create a recovery catalog user and grant the necessary privileges in the target database.
Create a recovery catalog by using the create catalog command.
Import the catalog data into the new recovery catalog by using the Data Pump Import utility in the target database.
Import the source recovery catalog schema by using the import catalog command. 6)Connect to the destination database.
7) Connect as catalog to the destination recovery catalog schema.
Identify the option with the correct sequence for moving the recovery catalog.
A. 1, 6, 4
B. 2, 3, 7, 5
C. 1, 2, 6, 4
D. 1, 2, 3, 6, 5
Question No: 8
You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:
$ . oraenv
ORACLE鈥SID = [oracle] ? cdb1
The oraclebasefor ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 is
$ rman target /
Recovery Manager : Release 18.104.22.168.2 – production on Fri Ju1 19 05:18:33: 2013 Coppyright (c) 1982, 2013, oracle and/or its affiliates. All rights reserved.
Connected to target database:CDB1 (DBID=782249327) RMANgt;SELECT name FROMv$tablespace;
Which statement is true about the execution of the last command?
It succeeds and displays all the tablespaces that belong to the root database.
It fails and returns an error because a connection is not made by using the sysdba privilege.
It succeeds and displays all the tablespaces that belong to the root and pluggable databases.
It fails and returns an error because SQL commands cannot be executed at the RMAN prompt.
Question No: 9
Which three statements are true about persistent lightweight jobs?
A user cannot set privileges on them.
They generate large amounts of metadata.
They may be created as fully self-contained jobs.
They must reference an existing Scheduler Program.
The are useful when users need to create a large number of jobs quickly.
Question No: 10
Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?
A DBA can check specific tables with the DMU
The database to be migrated must be opened read-only.
The release of the database to be converted can be any release since 22.214.171.124.
The DMU can report columns that are too long in the converted characterset
The DMU can report columns that are not represented in the converted characterset
Explanation: A: In certain situations, you may want to exclude selected columns or tables from scanning or conversion steps ofthe migration process.
D: Exceed column limit
The cell data will not fit into a column after conversion.
E: Need conversion
The cell data needs to be converted, because its binary representation in the target character set is different than the representation in the current character set, but neither length limit issues nor invalid representation issues have been found.
EnsurePass ExamCollection Testking Lowest Price Guarantee Yes No No Up-to-Dated Yes No No Real Questions Yes No No Explanation Yes No No PDF VCE Yes No No Free VCE Simulator Yes No No Instant Download Yes No No