Oracle 1Z0-050 Online Practice Questions and Exam Preparation

Oracle 1Z0-050 Online Questions & Answers

• Question 151:

  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?

  A. A disk in a disk group can be taken offline.
  B. A new disk cannot be added to a disk group.
  C. The client RDBMS instance can access the file as a read-only file.
  D. The client RDBMS instance cannot access the files in the disk group,
  D. The client RDBMS instance cannot access the files in the disk group,

• Question 152:

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

  A. It detects changes in SQL execution plans.
  B. It produces results that can be used to create the SQL plan baseline.
  C. The importance of SQL statements is based on the size of the objects accessed.
  D. It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.
  E. It shows only the overall impact on workload and not the net SQL impact on workload.
  A. It detects changes in SQL execution plans.
  B. It produces results that can be used to create the SQL plan baseline.
  D. It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.

• Question 153:

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

  SQL> SELECT substr(component, 0,10) COMP, current_size CS, user_specified_size US FROM v$memory_dynamic_components

  WHERE current_size!=0;

  

  What do you infer from this?

  A. The database instance is running with manual PGA management.
  B. The database instance is running with manual shared memory management.
  C. The database instance has the MEMORY_TARGET value set to a nonzero value.
  D. All sessions are connected to the database instance in dedicated mode, and no RMAN or parallel query operations have been performed.
  C. The database instance has the MEMORY_TARGET value set to a nonzero value.

• Question 154:

  Evaluate the following command:

  SQL>ALTER SYSTEM SET db_securefile = 'IGNORE1;

  What is the impact of this setting on the usage of Secure Files?

  A. It forces Basic Files to be created even if the SECUREFILE option is specified to create the LOB.
  B. It forces Secure Files to be created even if the BASICFILE option is specified to create the LOB.
  C. It does not allow the creation of Secure Files and generates an error if the SECUREFILE option is specified to create the LOB.
  D. It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a Basic File.
  A. It forces Basic Files to be created even if the SECUREFILE option is specified to create the LOB.

• Question 155:

  Evaluate the following function code:

  CREATE FUNCTION get_dept_avg(dept_id NUMBER)

  RETURN NUMBER

  RESULT_CACHE RELIES_ON (EMPLOYEES)

  IS

  avgsal NUMBER(6);

  BEGIN

  SELECT AVG(SAU\RY)INTO avgsal

  FROM EMPLOYEES

  WHERE DEPARTMENTJD = dept_id;

  RETURN avgsal;

  END get_dept_avg;

  Which statement is true regarding the above function?

  A. The cached result becomes invalid when any structural change is done to the EMPLOYEES table.
  B. If the function execution results in an unhandled exception, the exception result is also stored in the cache.
  C. Each time the function is invoked in a different session, the current result in the result cache gets overwritten.
  D. If the function is invoked with a different parameter value, the existing result in the result cache gets overwritten by the latest value.
  A. The cached result becomes invalid when any structural change is done to the EMPLOYEES table.

• Question 156:

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

  A. The incident metadata is purged when the problem is resolved and the DBA closes the SR.
  B. The incident files and dumps are not retained in the ADR for the manually created incidents.
  C. The incident files are retained but the incident metadata is purged when the problem is resolved and the DBA closes the SR
  D. 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.
  D. 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.

• Question 157:

  You need to create a partitioned table to store historical data and you Issued the following command:

  CREATE TABLE purchas_interval

  PARTITION BY RANGE (time_id)

  INTERVAL (NUMTOYMINTERVAL(1 ,'month1)) STORE IN (tbs1 ,tbs2,tbs3)

  PARTITION p1 VALUES LESS THAN(TO_DATE('1-1-2005I, 'dd-mm-yyyy')), PARTITION p2 VALUES LESS THAN(TO_DATE('1-1-2007', 'dd-mm-yyyy'))) AS

  SELECT *

  FROM purchases

  WHERE time_id < TO_DATE('1-1-2007'l'dd-mm-yyyy');

  What is the outcome of the above command?

  A. It returns an error because the range partitions P1 and P2 should be of the same range.
  B. It creates two range partitions (P1, P2). Within each range partition, it creates monthwise subpartitions.
  C. It creates two range partitions of varying range. For data beyond '1-1-2007,' it creates partitions with a width of |_| one month each
  D. It returns an error because the number of tablespaces (TBS1 ,TBS2,TBS3)specified does not match the number of range partitions (P1 ,P2) specified.
  C. It creates two range partitions of varying range. For data beyond '1-1-2007,' it creates partitions with a width of |_| one month each

• Question 158:

  What is the advantage of setting the ASM-preferred mirror read for the Stretch cluster configuration?

  A. It improves resync operations.
  B. This feature enables much faster file opens.
  C. It improves performance as fewer extent pointers are needed in the shared pool.
  D. It improves performance by reading from a copy of an extent closest to the node.
  D. It improves performance by reading from a copy of an extent closest to the node.

• Question 159:

  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, materialized log, indexes, referential integrity constraint, and triggers with the PRECEDES clause existing on it.

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

  A. The materialized log should be dropped before the online table redefinition process.
  B. Triggers with the PRECEDES clause should be disabled before the online table redefinition process.
  C. Referential integrity constraints must be manually enabled after the online table redefinition process.
  D. The dependent materialized view should have a complete refresh performed after the online table redefinition process.
  D. The dependent materialized view should have a complete refresh performed after the online table redefinition process.

• Question 160:

  Examine the following PL/SQL block:

  DECLARE

  my_plans plsjnteger;

  BEGIN

  My_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE (sql_Id => ? 9twu5t2dn5xd?; END;

  Which statement is true about the plan being loaded into the SQL plan baseline by the above command?

  A. It is loaded with the FIXED status.
  B. It is loaded with the ACCEPTED status.
  C. It is not loaded with the ENABLED status.
  D. It is not loaded with the ACCEPTED status.
  B. It is loaded with the ACCEPTED status.