1Z0-050 Exam Questions

Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines. (Choose two.)

Which two statements about workload capture and replay operations are true? (Choose two.)

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

USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypte...

View the Exhibit exhibit1 to examine the series of SQL commands. View the Exhibit exhibit2 to examine the plans available in the SQL plan baseline. The baseline in the first row of...

Evaluate the following block of code: BEGIN DBMS_NETWORK_ACL_ADMIN.CREATE_ACL ( acl => 'mycompany-com-permissions.xml', principal => 'ACCT_MGR', is_grant => TRUE, privilege => 'con...

Which steps are mandatory to enable Direct NFS? 1. Mount all required file systems using the kernel NFS driver. 2. Create an oranfstab file containing the attributes for each NFS s...

Which statements are true regarding the concept of problems and incidents in the fault diagnosability infrastructure for Oracle Database 11g? (Choose all that apply.)

You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 30...

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

What can you achieve by implementing reverse key index?

The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in your database instance. At a certain point of time, the maintenance window cl...

In which situation would you use static database registration for a listener?

You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the...

You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script: SQL>@utlu111i.sq...

Which three statements about performance analysis by SQL Performance Analyzer are true? (Choose three.)

Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g? (Choose all that apply.)

Which statement is true regarding the VALIDATE DATABASE command?

Which two are the prerequisites to enable Flashback Data Archive? (Choose two.)

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

You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks...

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

You opened the encryption wallet and then issued the following command: SQL>CREATE TABLESPACE securespace DATAFILE '/home/user/oradata/secure01.dbf' SIZE 150M ENCRYPTION USING '3DE...

Examine the following PL/SQL block: SET SERVEROUTPUT ON SET LONG 10000 ECLARE report clob; BEGIN report := DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE(); DBMS_OUTPUT.PUT_LINE(report); END; W...

In which two aspects does hot patching differ from conventional patching? (Choose two.)

Which statement about the enabling of table compression in Oracle Database 11g is true?

Which are the prerequisites for performing flashback transactions on your database? (Choose all that apply.)

You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tape drives of only 10...

Which statements are true regarding the Query Result Cache? (Choose all that apply.)

You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execu...

Which two changes and their effect on the system can be tested by using the Database Replay feature? (Choose two.)

You executed the following commands: SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false; SQL> EXECUTE DBMS_STATS.SET_TABLE_PREFS('SH', 'CUSTOMERS', 'PUBLISH','false');...

The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?

Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework?

View the Exhibit and examine the output. You executed the following command to enable Flashback Data Archive on the EXCHANGE_RATE table: ALTER TABLE exchange_rate FLASHBACK ARCHIVE...

Which two statements are true regarding Oracle Data Pump? (Choose two.)

Which two statements are true about the Automatic Database Diagnostic Monitor(ADDM)? (Choose two.)

In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting?

Why does performance degrade when many UPDATE, INSERT or DELETE statements are issued on a table that has an associated bitmap index?

Which two are the uses of the ASM metadata backup and restore (AMBR) feature? (Choose two.)

You executed the following PL/SQL block successfully: VARIABLE tname VARCHAR2(20) BEGIN dbms_addm.insert_finding_directive (NULL, DIR_NAME=>'Detail CPU Usage', FINDING_NAME=>'CPU U...

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

To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code: BEGIN dbms_advisor.create_task(dbms_advi...

You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group , you issued the following ASMC...

You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?

You need to create a partitioned table to store historical data and you issued the following command: CREATE TABLE purchase_interval PARTITION BY RANGE (time_id) INTERVAL (NUMTOYMI...

View the Exhibit to examine the Automatic Database Diagnostic Monitor (ADDM) tasks. You executed the following commands: SQL> VAR tname VARCHAR2(60); SQL> BEGIN :tname := 'my_insta...

View the Exhibit exhibit1 to observe the maintenance window property. View the Exhibit exhibit2 to examine the output of the query. Which two statements describe the conclusions? (...

Examine the following PL/SQL block: DECLARE my_plans pls_integer; BEGIN my_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE (sql_id => ?9twu5t2dn5xd?; END; Which statement is true ab...

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