1z0-050 | The Secret of Oracle 1z0-050 braindumps

Q41. Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package? (Choose all that apply.)

A. It can be used to allow the access privilege settings for users but not roles.

B. It can be used to allow the access privilege settings for users as well as roles.

C. It can be used to control the time interval for which the access privilege is available to a user.

D. It can be used to selectively restrict the access for each user in a database to different host computers.

E. It can be used to selectively restrict a user's access to different applications in a specific host computer.

Answer: BCD

Q42. Which three statements correctly describe the features of the I/O calibration process? (Choose three.)

A. Only one I/O calibration process can run at a time.

B. It automates the resource allocation for the Automated Maintenance Tasks.

C. It improves the performance of the performance-critical sessions while running.

D. It can be used to estimate the maximum number of I/Os and maximum latency time for the system.

E. The latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRUE.

Answer: ADE

Q43. Evaluate the following statements:

CREATE TABLE purchase_orders

(po_id NUMBER(4),

po_date TIMESTAMP,

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

A. Partitions of PURCHASE_ORDER_ITEMS have system-generated names.

B. Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each.

C. Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.

D. The PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.

E. Partition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.

Answer: BC

Q44. When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. 

Which two statements describe the implications of this? (Choose two.)

A. It produces less accurate results of the comparison analysis.

B. It automatically calls the SQL Tuning Advisor for recommendations.

C. It shortens the time of execution and reduces the impact on system resources.

D. Only the changes in the execution plan, and not performance regression, are detected.

Answer: AC

Q45. View the Exhibit to examine the error during the database startup.

You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:

RMAN> REPAIR FAILURE;

Which statement describes the consequence of the command?

A. The command performs the recovery and closes the failures.

B. The command only displays the advice and the RMAN script required for repair.

C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.

D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).

Answer: C

Q46. Which tasks are run automatically as part of the Automated Maintenance Task by default? (Choose all that apply.)

A. Segment Advisor

B. SQL Access Advisor

C. Optimizer statistics gathering

D. Automatic SQL Tuning Advisor

E. Automatic Database Diagnostics Monitor

Answer: ACD

Q47. Which three statements are true regarding the functioning of the Autotask Background Process (ABP)? (Choose three.)

A. It translates tasks into jobs for execution by the scheduler.

B. It creates jobs without considering the priorities associated with them.

C. It determines the list of jobs that must be created for each maintenance window.

D. It is spawned by the MMON background process at the start of the maintenance window.

E. It maintains a repository in the SYSTEM tablespace to store the history of the execution of all tasks.

Answer: ACD

Q48. In your database, the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory (OID). SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command:

$ SQLPLUS scott/tiger@DB01 AS SYSDBA

where DB01 is the net service name.

Which authentication method would be used first?

A. authentication by password file

B. authentication by using certificates over SSL

C. authentication by using the Oracle Internet Directory

D. authentication by using the local OS of the database server

Answer: A

Q49. Examine the following RMAN command:

BACKUP DATABASE

TAG TESTDB

KEEP UNTIL 'SYSDATE+1'

RESTORE POINT TESTDB06;

Which two statements are true regarding the backup taken by using the above RMAN command? (Choose two.)

A. Only data files and the control file are backed up.

B. Archived redo logs are backed up only if the database is open during the backup.

C. The backup is deleted after one day, regardless of the default retention policy settings.

D. The backup becomes obsolete after one day, regardless of the default retention policy settings.

Answer: BD

Q50. You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.

You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11. You executed the following commands:

RMAN> CONNECT CATALOG rco11/password@catdb

RMAN> IMPORT CATALOG rcat10/oracle@inst1 NO UNREGISTER; 

Which two statements are true regarding the tasks accomplished with these commands? (Choose two.)

A. They import all metadata from the RCAT10 catalog.

B. They unregistered the database from the RCAT10 catalog.

C. They do not register the databases registered in the RCAT10 catalog.

D. They register all databases registered in the RCAT10 catalog.

Answer: AD