Oracle 1Z0-050 Online Practice Questions and Exam Preparation

Oracle 1Z0-050 Online Questions & Answers

• Question 131:

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

  A. Partitions of PURCHASE_ORDER_ITEMS have system-generated names.
  B. Both PURCHASEjDRDERS and PURCHASEJDRDERJTEMS tables are created with four partitions each.
  C. Partitions of the PURCHASEJDRDERJTEMS table exist in the same tablespaces as the partitions of the PURCHASEJDRDERS table.
  D. The PURCHASEJDRDERJTEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.
  E. Partition maintenance operations performed on the PURCHASEJDRDERJTEMS table are automatically reflected in the PURCHASEjDRDERS table.
  B. Both PURCHASEjDRDERS and PURCHASEJDRDERJTEMS tables are created with four partitions each.
  C. Partitions of the PURCHASEJDRDERJTEMS table exist in the same tablespaces as the partitions of the PURCHASEJDRDERS table.

• Question 132:

  Your database initialization parameter file has the following entry:

  SEC_MAX_FAILED_LOGIN_ATTEMPTS=3

  Which statement is true regarding this setting?

  A. It is enforced only if the password profile is enabled for the user.
  B. It locks the user account after the specified number of attempts.
  C. It drops the connection after the specified number of login attempts fail for any user.
  D. It drops the connection after the specified number of login attempts fail only for users who have the SYSDBA privilege.
  C. It drops the connection after the specified number of login attempts fail for any user.

• Question 133:

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

  A. It requires relinking of the Oracle binary.
  B. It does not require database instance shutdown.
  C. It can detect conflicts between two online patches.
  D. It is available for installing all patches on all platforms.
  E. It works only in a single database instance environment.
  B. It does not require database instance shutdown.
  C. It can detect conflicts between two online patches.

• Question 134:

  View the Exhibit to examine the error obtained during the I/O calibration process. There are no data files on raw devices. What is the reason for this error?

  

  A. The DISK_ASYNCH_IO parameter is set to TRUE.
  B. The FILESYSTEMIOJDPTIONS parameter is set to NONE.
  C. Another session runs the I/O calibration process concurrently.
  D. The pending area has not been created before running the I/O calibration process.
  B. The FILESYSTEMIOJDPTIONS parameter is set to NONE.

• Question 135:

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

  A. The amount of undo retained is user controlled.
  B. SecureFile LOBs can be used only for nonpartitioned tables.
  C. Fragmentation is minimized by using variable-sized chunks dynamically.
  D. SecureFile encryption allows for random reads and writes of the encrypted data.
  E. It automatically detects duplicate LOB data and conserves space by storing only one copy.
  C. Fragmentation is minimized by using variable-sized chunks dynamically.
  D. SecureFile encryption allows for random reads and writes of the encrypted data.

• Question 136:

  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 execution of SQLs in a SQL Tuning Set? (Choose two.)

  A. Every SQL statement in the STS is considered only once for execution.
  B. The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics.
  C. The execution plan and execution statistics are computed for each SQL statement in the STS.
  D. The effects of DDL and DML are considered to produce the execution plan and execution statistics.
  A. Every SQL statement in the STS is considered only once for execution.
  C. The execution plan and execution statistics are computed for each SQL statement in the STS.

• Question 137:

  You have the following requirements in relation to the detection of block corruption for your database instance:

  1.

  Check for logical self-consistency of data blocks when modified in memory.

  2.

  Checksums are calculated before and after the block change.

  3.

  Checks are performed for the lost writes to the physical standby database. Which method would help you perform the above checks automatically?

  A. Set the DB_SECUREFILE parameter to PERMITTED.
  B. Set the DB_ULTRA_SAFE parameter to DATAJDNLY.
  C. Set the DB_LOCK_CHECKSUM parameter to TYPICAL.
  D. Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL.
  B. Set the DB_ULTRA_SAFE parameter to DATAJDNLY.

• Question 138:

  The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA's intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?

  A. statistics recommendations
  B. SQL profile recommendations
  C. index-related recommendations
  D. restructuring of SQL recommendations
  B. SQL profile recommendations

• Question 139:

  The ADMIN_EMP table has columns EMPNO, ENAME, DEPTNO, and SAL. It has a materialized view EMP_MV with a materialized log and an ENAMEJDX index on the ENAME column.

  You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema.

  What action is required for the dependent objects when you perform online redefinition on the table?

  A. The materialized view should have a fast refresh performed after the online table redefinition is completed.
  B. The materialized view should have a complete refresh performed after the online table redefinition is completed.
  C. The materialized view, materialized log, and the index should be dropped and re- created after the online table redefinition is complete.
  D. The materialized view and materialized log should be dropped and all constraints disabled and re- created after the online table redefinition is complete.
  B. The materialized view should have a complete refresh performed after the online table redefinition is completed.

• Question 140:

  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_advisor.sqlaccess_advisor,lTASK1l); END; /

  BEGIN

  dbms_advisor.set_task_parameter(lTASK1l,lANALYSIS_SCOPElllALLl); dbms_advisor.set_task_parameter(lTASK1,,,MODE,llCOMPREHENSIVEl); END; /

  BEGIN

  dbms_advisor.execute_task('TASK1');

  dbms_output.put_line(dbms_advisor.get_task_script('TASK11)); END; /

  The blocks of code execute successfully; however, you do not get the required outcome.

  What could be the reason?

  A. A template needs to be associated with the task.
  B. A workload needs to be associated with the task.
  C. The partial or complete workload scope needs to be associated with the task.
  D. The type of structures (indexes, materialized views, or partitions) to be recommended need to be specified for the task.
  B. A workload needs to be associated with the task.