Oracle Database 12c: Installation and Administration
Question No: 41
You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEEDcontainer data files in separate directories.
You plan to create the database using SQL statements. Which three techniques can you use to achieve this?
Use Oracle Managed Files (OMF).
Specify the SEED FILE_NAME_CONVERT clause.
Specify the PDB_FILE_NAME_CONVERT initialization parameter.
Specify the DB_FILE_NAMECONVERT initialization parameter.
Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).
Answer: A,B,C Explanation:
You must specify the namesand locations of the seed#39;s files in one of the following ways:
(A) Oracle Managed Files
(B) The SEED FILE_NAME_CONVERT Clause
(C) The PDB_FILE_NAME_CONVERT Initialization Parameter
Question No: 42
You have successfully taken a database backup by using the command: RMANgt;BACKUP AS BACKUPSET DATABASE;
Now you execute this command:
RMANgt; BACKUP INCREMENTAL LEVEL 1 DATABASE;
What is the outcome?
It fails because an incremental level 1 backup always searches for an image copy as level 0 backup.
It fails because an incremental level 0 backup does not exist.
It takes a backup of blocks that have been formatted since the last full database backup.
It takes an incremental level 0 backup of the database.
It first takes an incremental level 0 backup and then an incremental level 1 backup.
Answer: E Explanation:
References: https://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup004.htm (188.8.131.52)
Question No: 43
Which statement is true aboutusing the Database Upgrade Assistant (DBUA) to upgrade
your database from Oracle Database 11g to Oracle Database 12c?
It terminates if the SYSTEM tablespace in the source database is not autoextensible.
It automatically makes necessary changes to Oracle environment variables.
It automatically enables unified auditing in the upgraded database.
It automatically adds new data files if there is not enough disk space to grow.
Answer: D Explanation: References:
Question No: 44
Which three statements are true about space usage alerts?
Alerts are issued only when the critical threshold for space available in a tablespace is breached.
The sum of active extents and allocated user quotas is considered to compute space usage for an undo tablespace.
Databasealerts can provide warnings about low space availability at both tablespace and segment levels.
Alerts are not issued for locally managed tablespaces that are offline or in read-only mode.
A newly created locally managed tablespace is automatically assigned the default threshold values defined for a database.
Answer: A,D,E Explanation: References:
Question No: 45
The HR user owns the BONUSES table. HR grants privileges to the user TOM by using the command:
SQLgt; GRANT SELECT ON bonuses TO tom WITH GRANT OPTION;
TOM then executes this command to grant privilegesto the user JIM: SQLgt; GRANT SELET ON hr.bonuses TO jim;
Which statement is true?
TOM cannot revoke the SELECT ON HR.BONUSES privilege from JIM.
HR can revoke the SELECT ON HR.BINUSES privilege from JIM.
JIM can grant the SELECT ON HR.BONUSESprivilege to other users, but cannot revoke the privilege from them.
HR can revoke the SELECT ON HR.BONUSES privilege from TOM, which will automatically revoke the SELECT ON HR.BONUSES privilege from JIM.
Question No: 46
Examine the parameters for your database instance:
Which three statements are true about the process of automatic optimization by using cardinality 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 does not 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.
Answer: A,C,D 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 isto automatically 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: 47
To implement Automatic Management (AMM), you set the following parameters:
When you try to start the database instance with these parameter settings, you receive the following error message:
SQL gt; startup
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information.
Identify the reason the instance failed to start.
The PGA_AGGREGATE_TARGET parameter is set to zero.
The STATISTICS_LEVEL parameter is set to BASIC.
Both the SGA_TARGET and MEMORY_TARGET parametersare set.
The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal.
Answer: B Explanation:
Example: SQLgt;startup force
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings
ORA-00848: STATISTICS_LEVEL cannot be set to BASIC with SGA_TARGET or MEMORY_TARGET
Question No: 48
Which three operations can be performed as multipartitionoperations in Oracle?
Merge partitions of a list partitioned table
Drop partitions of a list partitioned table
Coalesce partitions of a hash-partitioned global index.
Move partitions of a range-partitioned table
Rename partitions of a rangepartitioned table
Merge partitions of a reference partitioned index
Answer: A,B,F Explanation:
Multipartition maintenance enables adding, dropping, truncate, merge, split operations on multiple partitions.
A: Merge Multiple Partitions:
The new “ALTER TABLE … MERGE PARTITIONS ” help merge multiple partitions or subpartitions with a single statement. When merging multiple partitions, local and global index operations and semantics for inheritance of unspecified physical attributes are the same for merging two partitions.
B: Drop Multiple Partitions:
The new “ALTER TABLE … DROP PARTITIONS ” help drop multiple partitions or subpartitions with a single statement.
view plaincopy to clipboardprint?
SQLgt;ALTER TABLE Tab_tst1 DROP PARTITIONS
Tab_tst1_PART5, Tab_tst1_PART6, Tab_tst1_PART7; Table altered
You can’t drop all partitions of the table.
If the table has a single partition, you will get the error: ORA-14083: cannot drop the only
partition of a partitioned.
Question No: 49
Which two statements are true about Oracle Data Pump export and import operations?
You cannot specify how partitioned tables shouldbe handled during an import operation.
Only data can be compressed during an export operation.
Existing dump files can be overwritten during an export operation.
Tables cannot be renamed during an import operation.
Metadata that is exported andimported can be filtered based on objects and object types.
Question No: 50
An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache.
How would you guarantee that the blocks for the table never age out?
Configure the KEEP buffer pool and alter the table with the corresponding storage clause.
Increase the database buffer cache size.
Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.
Configure Automata Shared Memory Management.
Configure Automatic Memory Management-
Answer: A Explanation:
Schema objects are referenced with varying usage patterns; therefore, their cache behavior may be quite different. Multiple buffer poolsenable you to address these differences. You can use a KEEP buffer pool to maintain objects in the buffer cache and a RECYCLE buffer pool to prevent objects from consuming unnecessary space in the cache. When an object is allocated to a cache, all blocks from that object are placed in that cache. Oracle maintains a DEFAULT buffer pool for objects that have not been assigned to one of the buffer pools.
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|