Oracle 1Z0-050 Online Practice Questions and Exam Preparation

Oracle 1Z0-050 Online Questions & Answers

• Question 171:

  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 on the production database to record the peak

  workload. You set up the test RAC database and want to replay the recorded workload on the test machine. Note the following steps that you may require to replay the database workload:

  1) Preprocess the captured workload.

  2) Restart the database in RESTRICTED mode.

  3) Set up the Replay Clients.

  4) Restore the test database to the point when the capture started.

  5) Remap connections.

  Arrange the steps required in the correct sequence to accomplish this task on the test machine.

  A. 2, 1,5,3,4
  B. 1,2,4,5,3
  C. 1,4, 5, 3 (2 is not required.)
  D. 1, 2,4, 5 (3 is not required.)
  E. 1,4, 3, 5 (2 is not required.)
  C. 1,4, 5, 3 (2 is not required.)

• Question 172:

  You issued the following command on the temporary tablespace LMTEMP in your database:

  SQL>ALTER TABLESPACE Imtemp SHRINK SPACE KEEP 20M;

  Which requirement must be fulfilled for this command to succeed?

  A. The tablespace must be locally managed.
  B. The tablespace must have only one temp file.
  C. The tablespace must be made nondefault and offline.
  D. The tablespace can remain as the default but must have no active sort operations.
  A. The tablespace must be locally managed.

• Question 173:

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

  A. multiplexing of the control file
  B. database and operating system upgrades
  C. adding the redo log member to the database
  D. changing the database storage to ASM-managed storage
  B. database and operating system upgrades
  D. changing the database storage to ASM-managed storage

• Question 174:

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

  A. The plans can be manually loaded to the SQL plan baseline.
  B. The plans in the SQL plan baseline are verified and accepted plans.
  C. The plans generated for every SQL statement are stored in the SQL plan baseline by default.
  D. The plan baselines are stored temporarily in the memory as long as the database instance is running.
  E. For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online.
  A. The plans can be manually loaded to the SQL plan baseline.
  B. The plans in the SQL plan baseline are verified and accepted plans.
  E. For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online.

• Question 175:

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

  A. Undo retention guarantee must be enabled.
  B. Database must be running in archivelog mode.
  C. Automatic undo management must be enabled.
  D. The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).
  C. Automatic undo management must be enabled.
  D. The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).

• Question 176:

  Evaluate the following command and Its output:

  SQL>SELECT * FROM dba_temp_free_space;

  TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE LMTEMP 250609664 101048576 149561088

  Which two statements correctly interpret the output? (Choose two.)

  A. FREE_SPACE indicates only the space that is currently unallocated.
  B. ALLO CAT ED_S PACE indicates only the space currently allocated and in use.
  C. FREE_SPACE indicates only the space that is currently allocated and available for reuse.
  D. ALLO CAT ED_S PACE indicates both the space currently allocated and used, and the space that is available for reuse.
  E. FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.
  D. ALLO CAT ED_S PACE indicates both the space currently allocated and used, and the space that is available for reuse.
  E. FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.

• Question 177:

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

  A. Cursor cache
  B. Stored outline
  C. SQL Tuning Set
  D. Automatic Workload Repository (AWR) snapshots
  A. Cursor cache
  C. SQL Tuning Set

• Question 178:

  Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window? (Choose al that apply.)

  A. generating the SQL profile
  B. testing and accepting the SQL profile
  C. generating a list of candidate SQLs fortuning
  D. adding tuned SQL plans into the SQL plan baseline
  E. tuning each SQL statement in the order of importance F- generating baselines that include candidate SQLs fortuning
  A. generating the SQL profile
  B. testing and accepting the SQL profile
  C. generating a list of candidate SQLs fortuning
  E. tuning each SQL statement in the order of importance F- generating baselines that include candidate SQLs fortuning

• Question 179:

  In which situations will the ASM metadata backup help you recover the ASM disk in a disk group? (Choose all that apply.)

  A. when one or more disks in an ASM disk group are lost
  B. when the data file on an ASM disk group gets corrupted
  C. when one of the disks in a disk group is accidentaly unplugged
  D. wnen one or more file directory paths are accidentally deleted from an ASM disk group
  A. when one or more disks in an ASM disk group are lost
  D. wnen one or more file directory paths are accidentally deleted from an ASM disk group

• Question 180:

  ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?

  A. The data is decrypted during SORT and JOIN operations.
  B. The data remains encrypted when it is read into memory.
  C. The data remains encrypted when it is stored in the redo logs.
  D. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.
  C. The data remains encrypted when it is stored in the redo logs.