1Z0-050 Exam Questions

Which statements are true regarding SecureFile LOBs? (Choose all that apply.)

View the Exhibit for some of the current parameter settings. A user logs in to the HR schema and issues the following commands: SQL> CREATE TABLE emp (empno NUMBER(3), ename VARCHA...

You upgraded Oracle Database 10g to Oracle Database 11g. How would this affect the existing users' passwords?

What recommendations does the SQL Access Advisor provide for optimizing SQL queries? (Choose all that apply.)

Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_EN...

You are managing Oracle Database 11g 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 DI...

View the Exhibit to observe the error. You receive this error regularly and have to shut down the database instance to overcome the error. What can the solution be to reduce the ch...

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

You executed the following commands in an RMAN session for your database instance that has failures: RMAN> LIST FAILURE; After some time, you executed the following command in the...

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

Evaluate the following command: SQL>ALTER SYSTEM SET db_securefile = 'IGNORE'; What is the impact of this setting on the usage of SecureFiles?

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

View the Exhibit to examine a portion of the output from the VALIDATE DATABASE command. Which statement is true about the block corruption detected by the command?

You issued the following RMAN command to back up the database: RMAN> RUN{ ALLOCATE CHANNEL c1 DEVICE TYPE sbt BACKUP DATABASE TAG quarterly KEEP FOREVER RESTORE POINT FY06Q4;} Whic...

Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)

Which two statements are true regarding the starting of the database instance using the following command? (Choose two.) SQL>STARTUP UPGRADE

Which statements are true regarding system-partitioned tables? (Choose all that apply.)

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

Which two statements about Oracle Direct Network File System (NFS) are true? (Choose two.)

You are managing an Oracle Database 11g instance with ASM storage. You lost an ASM disk group DATA. You have RMAN backup of data as well as ASM metadata backup. You want to re- cre...

Evaluate the following command and its output: SQL>SELECT * FROM dba_temp_free_space; TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE ------------ --- --------------- --...

In your database, the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command: SQL>SELECT /*+ RESULT_CACHE */ sale...

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

Which three are the valid statements in relation to SQL plan baselines? (Choose three.)

You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that...

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

Which two statements about the SQL Management Base (SMB) are true? (Choose two.)

Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space, you issued the following command: A...

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

Which two statements are true regarding the SQL Repair Advisor? (Choose two.)

Which setting enables the baselines by default in Oracle Database 11g?

Which two activities are NOT supported by the Data Recovery Advisor? (Choose two.)

In which cases is reference partitioning effective in enhancing performance?

Your database initialization parameter file has the following entry: SEC_MAX_FAILED_LOGIN_ATTEMPTS=3 Which statement is true regarding this setting?

In which of the scenario will the DBA perform recovery? (Choose all that apply)

Which three statements regarding the server parameter file (SPFILE) are true? (Choose three.)

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

On which three can you use Recovery Manager (RMAN) to perform incremental backup? (Choose three.)

You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of I/Os. Which statement des...

You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2. The SALES table has a materialized view, materialize...

Examine the following values of the initialization parameters in the database having the SID ORCL: BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u0...

View the Exhibit to examine the output produced by the following query at three different times since the database instance started and has undergone workloads of different capacit...

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

Your company wants to upgrade the current production database to the RAC environment. To perform testing before migrating to the RAC environment, you performed the workload capture...

Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g? (Choose all that apply.)

The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA's intervention a...

Which statements are true regarding the creation of an incident package file by using the EM Workbench Support? (Choose all that apply.)

The following command is executed to create the baseline template: SQL> EXECUTE DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE(START_TIME=> TO_TIMESTAMP(SYSDATE+2), END_TIME=>TO...

View the Exhibit to examine the details for an incident. Which statement is true regarding the status of the incident?

You issued the following command: CREATE GLOBAL TEMPORARY TABLE admin_work_area (startdate DATE, enddate DATE, class CHAR(20)) ON COMMIT DELETE ROWS TABLESPACE tbs_t1; An index is...