Oracle 1Z0-050 Online Practice Questions and Exam Preparation

Oracle 1Z0-050 Online Questions & Answers

• Question 31:

  Observe the following PL/SQL block:

  BEGIN

  dbms_spm .configure('SPACE_BUDGET_PERCENT', 30); END;

  Which statement is correct regarding the above PL/SQL block?

  A. It reserves 30% of the space in the SYSTEM tablespace for SMB.
  B. It reserves 30% of the space in the SYSAUX tablespace for SQL Management Base (SMB).
  C. It generates a weekly warning in the alert log file when SMB occupies more than 30% of the SYSAUX tablespace.
  D. It automatically purges the SQL management objects when SMB occupies more than 30% of the SYSAUX tablespace.
  C. It generates a weekly warning in the alert log file when SMB occupies more than 30% of the SYSAUX tablespace.

• Question 32:

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

  A. All triggers on the table remain valid.
  B. All triggers on the table are invalidated and are automatically revalidated with the next DML execution on the table '
  C. All triggers on the table are invalidated and must be manually recompiled before the next DML execution on the table.
  D. Only triggers that are affected by the changes to the structure of the table are invalidated and automatically revalidated with the next DML execution on the table.
  B. All triggers on the table are invalidated and are automatically revalidated with the next DML execution on the table '

• Question 33:

  Which tasks can be accomplished using the DBMS_LOB.SETOPTIONS procedure?

  A. only encryption and compression settings for all SecureFile LOBs
  B. only encryption and deduplication settings for only SecureFile CLOBs
  C. deduplication, encryption, and compression settings for all SecureFile LOBs
  D. deduplication, encryption, and compression settings only for SecureFile CLOBs
  C. deduplication, encryption, and compression settings for all SecureFile LOBs

• Question 34:

  Which three statements are true regarding persistent lightweight jobs? (Choose three.)

  A. The user cannot set privileges on persistent lightweight jobs.
  B. The use of a template is mandatory to create persistent lightweight jobs.
  C. Persistent lightweight jobs modify several tables in the data dictionary to generate a lot of redo.
  D. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time.
  E. Persistent lightweight jobs are useful when users need to create a small number of jobs that run infrequently.
  A. The user cannot set privileges on persistent lightweight jobs.
  B. The use of a template is mandatory to create persistent lightweight jobs.
  D. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time.

• Question 35:

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

  A. The clients must be created manually on the test machines to perform more realistic testing.
  B. Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.
  C. Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.
  D. The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.
  C. Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.
  D. The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.

• Question 36:

  While performing the backup of the flash recovery area, you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files. What implications does it have on the backup of the flash recovery area?

  A. The backup succeeds but it would be without the missing archived log.
  B. The backup fails because one of the archived redo log files is missing.
  C. The backup succeeds because it fails over to one of the alternative archived redo log destinations.
  D. During backup, you are prompted for the alternative destination for the missing archived redo log file.
  C. The backup succeeds because it fails over to one of the alternative archived redo log destinations.

• Question 37:

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

  A. All passwords automatically become case-sensitive.
  B. All passwords remain non-case-sensitive till they are changed.
  C. All passwords remain non-case-sensitive and cannot be changed.
  D. All passwords remain non-case-sensitive until their password attribute in the profile is altered.
  B. All passwords remain non-case-sensitive till they are changed.

• Question 38:

  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 operations are performed by the optimizer in this scenario? (Choose two.)

  A. The optimizer adds the new plan to the plan history.
  B. The optimizer selects the new plan for the execution of the SQL statement.
  C. The optimizer adds the new plan to the SQL plan baseline as an accepted plan.
  D. The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.
  E. The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.
  A. The optimizer adds the new plan to the plan history.
  E. The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.

• Question 39:

  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 same session:

  RMAN> ADVISE FAILURE;

  But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?

  A. It produces a warning for new failures before advising for CRITICAL and HIGH failures.
  B. It ignores new failures and considers the failures listed in the last LIST FAILURE command only.
  C. It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.
  D. It produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignored.
  A. It produces a warning for new failures before advising for CRITICAL and HIGH failures.

• Question 40:

  Which statements are true regarding table compression? (Choose all that apply.)

  A. It requires uncompress operation during I/O.
  B. It saves disk space and reduces memory usage.
  C. It saves disk space but has no effect on memory usage.
  D. It incurs extra CPU overhead during DML but not direct loading operations.
  E. It incurs extra CPU overhead during DML as well as direct loading operations.
  B. It saves disk space and reduces memory usage.
  E. It incurs extra CPU overhead during DML as well as direct loading operations.