Oracle Database 11g: New Features for Administrators
Question No: 51
View the Exhibit to examine the output for the V$DIAG_INFO view.
Which statements are true regarding the location of diagnostic traces? (Choose all that apply.)
The path to the location of the background as well as the foreground process trace files is
The location of the text alert log file is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.
The location of the trace file for the current session is/u01/oracle/diag/rdbms/orclbi/orclbi/trace.
The location of the XML-formatted version of the alert log is
Question No: 52
You are managing Oracle Database 11 g with an ASM storage with high redundancy. The following command was issued to drop the disks from the dga disk group after five hours:
ALTER DISKGROUP dga OFFLINE DISKS IN FAILGROUP f2 DROP AFTER 5H;
Which statement is true in this scenario?
It starts the ASM fast mirror resync.
It drops all disk paths from the dga disk group.
All the disks in the dga disk group would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.
All the disks in the dga disk group in failure group f2 would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.
Question No: 53
Evaluate the following SQL statement used to create the PRODUCTS table:
CREATE TABLE products
(product_id NUMBER(3) PRIMARY KEY,
product_desc VARCHAR2(25), qty NUMBER(8,2),
total_value AS ( qty * rate)) PARTITION BY RANGE (total_value)
(PARTITION p1 VALUES LESS THAN (100000), PARTITION p2 VALUES LESS THAN (150000), PARTITION p3 VALUES LESS THAN (MAXVALUE)) COMPRESS FOR ALL OPERATIONS;
Which statement is true regarding this command?
It executes successfully but partition pruning cannot happen for this partition key.
It produces an error because the TOTAL_VALUE column cannot be used as a partition key.
It produces an error because compression cannot be used for the TOTAL_VALUE partition key.
It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.
Question No: 54
What two statements are true regarding the recommendations received from the SQL Access Advisor? (Choose two.)
It can recommend partitioning only on tables that have at least 10,000 rows.
It cannot generate recommendations that support multiple workload queries.
It can recommend only B-tree indexes and not bitmap or function-based indexes.
It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.
Question No: 55
You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours:
ALTER DISKGROUP dg01 SET ATTRIBUTE #39;disk_repair_time#39; = #39;5h#39;; To which disks in the disk group will the new value be applicable?
all disks in the disk group
all disks that are currently in OFFLINE mode
all disks that are not currently in OFFLINE mode
all disks in the disk group only if all of them are ONLINE
Question No: 56
You issued the following command on the temporary tablespace LMTEMP in your database:
SQLgt;ALTER TABLESPACE Imtemp SHRINK SPACE KEEP 20M;
Which requirement must be fulfilled for this command to succeed?
The tablespace must be locally managed.
The tablespace must have only one temp file.
The tablespace must be made nondefault and offline.
The tablespace can remain as the default but must have no active sort operations.
Question No: 57
The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline. Which two operations are performed by the optimizer in this scenario? (Choose two.)
The optimizer adds the new plan to the plan history.
The optimizer selects the new plan for the execution of the SQL statement.
The optimizer adds the new plan to the SQL plan baseline as an accepted plan.
The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.
The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.
Question No: 58
Which two statements are true regarding the Automatic Diagnostic Repository (ADR) in Oracle Database 11g? (Choose two.)
A single ADR can support multiple ADR homes for different database instances.
The alert files are stored in XML file format in the TRACE directory of each ADR home.
If the environmental variable ORACLE_BASE is set, then DIAGNOSTIC_DEST is set to
The BACKGROUND_DUMP_DEST initialization parameter overrides the DIAGNOSTIC_DEST initialization parameter for the location of the alert log file.
Question No: 59
Which two are the prerequisites to enable Flashback Data Archive? (Choose two.)
Undo retention guarantee must be enabled.
Database must be running in archivelog mode.
Automatic undo management must be enabled.
The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).
Question No: 60
The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA#39;s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?
SQL profile recommendations
restructuring of SQL recommendations
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|