Oracle Database 11g: New Features for Administrators
Question No: 31
You executed the following PL/SQL block successfully: VARIABLE tname VARCHAR2(20)
dbms_addm.insert_finding_directive (NULL, DIR_NAME=gt;#39;Detail CPU Usage1, FINDING_NAME=gt;#39;CPU Usage1,
:tname := #39;database ADDM task4#39;; dbms_addm.analyze_db(:tname, 150,162); END;
Then you executed the following command:
SQLgt; SELECT dbms_addm.get_report(:tname) FROM DUAL;
The above command produces Automatic Database Diagnostic Monitor (ADDM) analysis .
with the CPU Usage finding if it is less than 90
without the CPU Usage finding if it is less than 90
with the CPU Usage finding for snapshots below 90
with the CPU Usage finding for snapshots not between 150 and 162
Question No: 32
Which client requests to the database can be captured as a part of the workload capture? (Choose all that apply.)
logging in and logging out of sessions
all DDL statements having bind variables
direct path load of data from external files
Question No: 33
Evaluate the following statements:
CREATE TABLE purchase_orders (pojd NUMBER(4),
po_date TIMESTAMP, supplie_id NUMBER(6), po_total NUMBER(8,2),
CONSTRAINT order_pk PRIMARY KEY(po_id)) PARTITION BY RANGE(po_date)
(PARTITION Q1 VALUES LESS THAN (TO_DATE(?1-apr-2007?d-mon-yyyy?), PARTITION Q2 VALUES LESS THAN (TO_DATE(?1-jul-2007?d-mon-yyyy?), PARTITION Q3 VALUES LESS THAN (TO_DATE(?1-oct-2007?d-mon-yyyy?), PARTITION Q4 VALUES LESS THAN (TO_DATE(?1-jan-2008?d-mon-yyyy?));
CREATE TABLE purchase_order_items
(po_id NUMBER(4) NOT NULL, product_id NUMBER(6) NOT NULL, unit_price NUMBER(8,2),
FOREIGN KEY (po_id) REFERENCES purchase_orders(po_id)) PARTITION BY REFERENCE(po_items_fk);
What are the two consequences of the above statements? (Choose two.)
Partitions of PURCHASE_ORDER_ITEMS have system-generated names.
Both PURCHASEjDRDERS and PURCHASEJDRDERJTEMS tables are created with four partitions each.
Partitions of the PURCHASEJDRDERJTEMS table exist in the same tablespaces as the partitions of the
The PURCHASEJDRDERJTEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.
Partition maintenance operations performed on the PURCHASEJDRDERJTEMS table are automatically reflected in the PURCHASEjDRDERS table.
Question No: 34
You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same system with the name DUPDB.
You issued the following RMAN commands to create a duplicate database: RMANgt; CONNECT target sys/sys@APPPROD
RMANgt; DUPLICATE TARGET DATABASE
FROM ACTIVE DATABASE
DB_FILE_NAME_CONVERT #39;/oracIe/oradata/prod/1, #39;/scratch/oracIe/oradata/dupdb/1
SET SGA_MAX_SIZE = #39;300M1 SET SGA_TARGET = #39;250M#39;
SET LOG_FILE_NAME_CONVERT #39;/oracle/oradata/prod/redo/#39;, #39;/scratch/oracIe/oradata/dupdb/redo/1;
Which three are the prerequisites for the successful execution of the above command? (Choose three.)
The source database should be open.
The target database should be in ARCHIVELOG mode if it is open.
RMAN should be connected to both the instances as SYSDBA
The target database backups should be copied to the source database backup directories.
The password file must exist for the source database and have the same SYS user password as the target.
Question No: 35
Which two statements are true regarding hot patching? (Choose two.)
It requires relinking of the Oracle binary.
It does not require database instance shutdown.
It can detect conflicts between two online patches.
It is available for installing all patches on all platforms.
It works only in a single database instance environment.
Question No: 36
Which two statements are true regarding Health Monitor checks in Oracle Database 11g? (Choose two.)
Health Monitor checks are always initiated manually when there is some critical error.
Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and
Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically.
Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible, corrupt or inconsistent.
Question No: 37
Which tasks can be accomplished using the DBMS_LOB.SETOPTIONS procedure?
only encryption and compression settings for all SecureFile LOBs
only encryption and deduplication settings for only SecureFile CLOBs
deduplication, encryption, and compression settings for all SecureFile LOBs
deduplication, encryption, and compression settings only for SecureFile CLOBs
Question No: 38
Which statement is true regarding the retention policy for the incidents accumulated in the Automatic Diagnostic Repository (ADR)?
The incident metadata is purged when the problem is resolved and the DBA closes the SR.
The incident files and dumps are not retained in the ADR for the manually created incidents.
The incident files are retained but the incident metadata is purged when the problem is resolved and the DBA closes the SR
The default setting is for one year after which the incident metadata is purged from the ADR and the files are retained for one month.
Question No: 39
Which statement describes the effect of table redefinition on the triggers attached to the table?
All triggers on the table remain valid.
All triggers on the table are invalidated and are automatically revalidated with the next DML execution on the table #39;
All triggers on the table are invalidated and must be manually recompiled before the next DML execution on the table.
Only triggers that are affected by the changes to the structure of the table are invalidated and automatically revalidated with the next DML execution on the table.
Question No: 40
You issued the following command to mount the DATA disk group in restricted mode: ALTER DISKGROUP data MOUNT RESTRICT;
What is the implication of this command?
A disk in a disk group can be taken offline.
A new disk cannot be added to a disk group.
The client RDBMS instance can access the file as a read-only file.
The client RDBMS instance cannot access the files in the disk group,
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|