Oracle Oracle Database 1Z0-052 Questions & Answers

• Question 31:

  A database user SMITH tries to query the V$SESSION view and fails to access it as follows:

  

  Which are the two possible solutions to enable SMITH to query the data in V$SESSION? (Choose two.)

  A. granting SELECT privilege to SMITH on V$SESSION

  B. granting SELECT privilege to SMITH on V_$SESSION C. asking the user SMITH to run the catalog.sql script

  D. granting SELECT privilege to SMITH on V$FIXED_TABLES

  E. setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE

  F. creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created

  Correct Answer: BF

• Question 32:

  View Exhibit1 and Exhibit2 to examine the current memory allocation and parameter settings, respectively. Why are advisors not available for the shared pool and the buffer cache?

  09 (exhibit):

  

  10 (exhibit):

  

  A. because the DB_CACHE_ADVICE parameter is set to OFF

  B. because Automatic Memory Management (AMM) is disabled for the database instance

  C. because Automatic Shared Memory Management (ASMM) is enabled for the database instance

  D. because the values for the DB_CACHE_SIZE and SHARED_POOL_SIZE parameters were not set initially

  Correct Answer: C

• Question 33:

  You receive complaints from users regarding the high waiting time for their transactions. On investigation, you find that some users are not committing their transactions though they are not performing any activity for a long time. As a result, SQL statements need to wait for rowlevel locks. Which two actions could you take to prevent this locking problem in the future? (Choose two.)

  A. Decrease the IDLE_TIME resource limit in the profile assigned to the blocking users.

  B. Use Database Resource Manager to automatically log out sessions that block others and are idle

  C. Set the limit in the profile of blocking users to control the number of blocks to be accessed in a session.

  D. Decrease the maximum number of interested transaction list (ITL) slots for the segments on which the blocking user performs the transaction.

  Correct Answer: AB

• Question 34:

  Your database instance is functional for the past one month. The Automatic Workload Repository (AWR) snapshot retention is set to 7 and the STATISTICS_LEVEL initialization parameter is set to TYPICAL. You receive a complaint about the poor performance of the database between 7 PM and 9 PM of the previous day. Choose two actions any of which can be referred to first to diagnose the problem. (Choose two.)

  A. Use the Active Session History report.

  B. Use the AWR Compare Periods report.

  C. Use an ADDM analysis between 7 PM and 9 PM of the previous day.

  D. Use the AWR Compare Period report between 7 PM and 9 PM of the previous day.

  Correct Answer: BC

• Question 35:

  View the Exhibit and examine the PL/SQL package and procedure. You made changes to the COMPUTE_TAX function inside the EMP_ADMIN package body. Which statement is true after you recompile the EMP_ADMIN package body? Exhibit:

  

  A. The USE_P procedure remains valid.

  B. The USE_P procedure becomes invalid.

  C. The SHOW_DETAIL procedure becomes invalid.

  D. The EMP_ADMIN package specification becomes invalid and needs to be recompiled.

  Correct Answer: A

• Question 36:

  Which two statements are true about checkpointing? (Choose two.)

  A. The checkpoint frequency decreases with the smaller redo log file size.

  B. It ensures that all committed data is written to the data files during normal shutdown.

  C. The frequent full checkpoint in a database can cause the overall degradation of the database performance.

  D. It prompts the Checkpoint (CKPT) process to write data to the data files and redo information to the online redo log files.

  Correct Answer: BC

• Question 37:

  Which two statements are true regarding the Oracle Data Pump export and import operations? (Choose two.)

  A. You cannot export data from a remote database.

  B. You can rename tables during an import operation.

  C. You can overwrite existing dump files during an export operation.

  D. You can compress the data during export but not the metadata because it is not supported.

  Correct Answer: BC

• Question 38:

  View the Exhibit.

  

  You are creating an additional database by using the Database Configuration Assistant (DBCA). You opted to create a General Purpose database and during the database creation realize that the Block Size field is not enabled.

  What could be the reason for this?

  A. You have chosen the File System option as the storage option.

  B. You have chosen the Automatic Storage Management (ASM) as the storage option.

  C. The data block size can be increased only when DBCA is invoked from Oracle Universal Installer (OUI).

  D. You are using General Purpose template and not the Custom Database template to create the database.

  Correct Answer: D

• Question 39:

  Your database is functional with a peak load for the last one hour. You want to preserve the performance statistics collected during this period to be used for comparison when you analyze the performance of the database in the future.

  What action would you take to achieve this task?

  A. Insert finding directives for ADDM tasks in the future.

  B. Create a baseline on a pair of snapshots spanning the peak-load period.

  C. Decrease the snapshot interval in the AWR to collect more snapshots during the peakload period.

  D. Set the snapshot retention period in the Automatic Workload Repository (AWR) to zero to avoid automatic purging of snapshots.

  Correct Answer: B

• Question 40:

  Which of these is true about undo tablespace?

  A. Undo tablespace is a temporary tablespace

  B. Undo tablespace has only one datafile

  C. Undotablespace has a datafile which is reused in cyclic manner

  Correct Answer: A