[Free] 2018(Jan) Latesttests Dumpsleader Oracle 1z0-050 Dumps with VCE and PDF Download 31-40

Latesttests 2018 Jan Oracle Official New Released 1z0-050
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/1z0-050.html

Oracle Database 11g: New Features for Administrators

Question No: 31

You executed the following PL/SQL block successfully: VARIABLE tname VARCHAR2(20)

BEGIN

dbms_addm.insert_finding_directive (NULL, DIR_NAME=gt;#39;Detail CPU Usage1, FINDING_NAME=gt;#39;CPU Usage1,

MIN_ACTIVE_SESSIONS=gt;0,MIN_PERC_IMPACT=gt;90);

: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 .

  1. with the CPU Usage finding if it is less than 90

  2. without the CPU Usage finding if it is less than 90

  3. with the CPU Usage finding for snapshots below 90

  4. with the CPU Usage finding for snapshots not between 150 and 162

Answer: B

Question No: 32

Which client requests to the database can be captured as a part of the workload capture? (Choose all that apply.)

  1. flashback query

  2. distributed transactions

  3. logging in and logging out of sessions

  4. all DDL statements having bind variables

  5. direct path load of data from external files

Answer: C,D

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),

quantity NUMBER(8),

CONSTRAINT po_items_fk

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.)

  1. Partitions of PURCHASE_ORDER_ITEMS have system-generated names.

  2. Both PURCHASEjDRDERS and PURCHASEJDRDERJTEMS tables are created with four partitions each.

  3. Partitions of the PURCHASEJDRDERJTEMS table exist in the same tablespaces as the partitions of the

    PURCHASEJDRDERS table.

  4. The PURCHASEJDRDERJTEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.

  5. Partition maintenance operations performed on the PURCHASEJDRDERJTEMS table are automatically reflected in the PURCHASEjDRDERS table.

Answer: B,C

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

TO dupdb

FROM ACTIVE DATABASE

DB_FILE_NAME_CONVERT #39;/oracIe/oradata/prod/1, #39;/scratch/oracIe/oradata/dupdb/1

SPILE

PARAMETER_VALUE_CONVERT#39;/oracle/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.)

  1. The source database should be open.

  2. The target database should be in ARCHIVELOG mode if it is open.

  3. RMAN should be connected to both the instances as SYSDBA

  4. The target database backups should be copied to the source database backup directories.

  5. The password file must exist for the source database and have the same SYS user password as the target.

Answer: A,C,E

Question No: 35

Which two statements are true regarding hot patching? (Choose two.)

  1. It requires relinking of the Oracle binary.

  2. It does not require database instance shutdown.

  3. It can detect conflicts between two online patches.

  4. It is available for installing all patches on all platforms.

  5. It works only in a single database instance environment.

Answer: B,C

Question No: 36

Which two statements are true regarding Health Monitor checks in Oracle Database 11g? (Choose two.)

  1. Health Monitor checks are always initiated manually when there is some critical error.

  2. Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and

    corruption

  3. Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically.

  4. Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible, corrupt or inconsistent.

Answer: B,D

Question No: 37

Which tasks can be accomplished using the DBMS_LOB.SETOPTIONS procedure?

  1. only encryption and compression settings for all SecureFile LOBs

  2. only encryption and deduplication settings for only SecureFile CLOBs

  3. deduplication, encryption, and compression settings for all SecureFile LOBs

  4. deduplication, encryption, and compression settings only for SecureFile CLOBs

Answer: C

Question No: 38

Which statement is true regarding the retention policy for the incidents accumulated in the Automatic Diagnostic Repository (ADR)?

  1. The incident metadata is purged when the problem is resolved and the DBA closes the SR.

  2. The incident files and dumps are not retained in the ADR for the manually created incidents.

  3. The incident files are retained but the incident metadata is purged when the problem is resolved and the DBA closes the SR

  4. 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.

Answer: D

Question No: 39

Which statement describes the effect of table redefinition on the triggers attached to the table?

  1. All triggers on the table remain valid.

  2. All triggers on the table are invalidated and are automatically revalidated with the next DML execution on the table #39;

  3. All triggers on the table are invalidated and must be manually recompiled before the next DML execution on the table.

  4. 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.

Answer: B

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?

  1. A disk in a disk group can be taken offline.

  2. A new disk cannot be added to a disk group.

  3. The client RDBMS instance can access the file as a read-only file.

  4. The client RDBMS instance cannot access the files in the disk group,

Answer: D

100% Free Download!
Download Free Demo:1z0-050 Demo PDF
100% Pass Guaranteed!
Download 2018 Latesttests 1z0-050 Full Exam PDF and VCE

Latesttests 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

2018 Latesttests IT Certification PDF and VCE