Oracle 1Z0-052 Online Practice Questions and Exam Preparation

Oracle 1Z0-052 Online Questions & Answers

• Question 271:

  Which two statements are true regarding listeners? (Choose two.)

  A. Listeners use only the TCP/IP protocol.
  B. Multiple listener processes can run simultaneously on a host.
  C. Multiple database instances can be registered with a single listener.
  D. The listener-related errors can be traced only at the administrative level.
  E. Only one database instance can be registered with a single listener at any time.
  B. Multiple listener processes can run simultaneously on a host.
  C. Multiple database instances can be registered with a single listener.

• Question 272:

  Which two are true about space management in tablespaces? (Choose two.)

  A. Extent allocation must be specified as automatic for automatic segment space management (ASSM) tablespaces
  B. Free lists are used for managing free space for segments in locally managed tablespaces
  C. ASSM tablespaces prevent row chaining
  D. Locally managed tablespaces track adjacent free space automatically by using bitmaps
  E. Locally managed tablespaces have either ASSM or manual segment space management (MSSM), and all the segments in these tablespaces are managed one way or the other
  B. Free lists are used for managing free space for segments in locally managed tablespaces
  D. Locally managed tablespaces track adjacent free space automatically by using bitmaps

• Question 273:

  View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes, you executed the following command:

  

  What could be the reason for the elimination of the other rows in the output? Exhibit:

  

  A. An Automatic Workload Repository snapshot has been taken recently.
  B. The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.
  C. The threshold alerts conditions are cleared and the alerts are transferred to BA_ALERT_HISTORY.
  D. The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.
  C. The threshold alerts conditions are cleared and the alerts are transferred to BA_ALERT_HISTORY.

• Question 274:

  Given below is a list of scenarios:

  1.

  A user terminates his session abnormally.

  2.

  The connection between the server and the client application terminates because of a network failure.

  3.

  A schema is accidentally dropped.

  4.

  The tablespace is accidentally dropped from the database.

  5.

  The hard disk gets corrupted and the data files in the disk are lost.

  6.

  The database instance abnormally shuts down because of power failure. Which scenarios require DBA intervention to perform recovery?

  A. 1, 3, and 6
  B. 4, 5, and 6
  C. 3, 4, and 5
  D. 1, 2, and 6
  C. 3, 4, and 5

• Question 275:

  Examine the values for the following initialization parameters:

  FAST_START_MTTR_TARGET=0

  LOG_CHECKPOINT_INTERVAL=0

  Which two will be the implications of these values in your database? (Choose two.)

  A. The SGA advisor will be disabled
  B. The MTTR advisor will be disabled
  C. Automatic checkpoint tuning will be disabled
  D. Checkpoint information will not be written to the alert log file
  B. The MTTR advisor will be disabled
  C. Automatic checkpoint tuning will be disabled

• Question 276:

  You execute a command to resize a data file, sales.dbf, of size 200 MB in your database:

  ALTER DATABASE DATAFILE '/remorse/sales.dbf' RESIZE 150M;

  Which statement is true about this command?

  A. The command must be issued in MOUNT state.
  B. The command succeeds only if the data file is offline.
  C. The command must be issued when the database is in the archivelog mode.
  D. The command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.
  D. The command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.

• Question 277:

  Which two statements are true regarding transactions in an Oracle database? (Choose two.)

  A. Multiple transactions can use the same undo segment.
  B. A transaction is assigned an undo segment when it is started.
  C. More than one transaction cannot share the same extent in the undo tablespace.
  D. The transactions use system undo segment to store undo data if all the segments in the undo tablespace are used.
  A. Multiple transactions can use the same undo segment.
  B. A transaction is assigned an undo segment when it is started.

• Question 278:

  Which are three of the various resources that must be accessible to keep a database open?

  A. SYSTEM tablespace
  B. spfile
  C. all members of a redo log group
  D. SYSAUX tablespace
  E. control file
  A. SYSTEM tablespace
  D. SYSAUX tablespace
  E. control file

• Question 279:

  In your database, the current status of a PL/SQL procedure has become INVALID. Which action would fix the problem and make the PL/SQL procedure usable?

  A. Recompile the PL/SQL procedure.
  B. Modify the procedure to run with a definer's right.
  C. Modify the procedure to run with an invoker's right.
  D. Grant the EXECUTE privilege on the PL/SQL procedure to PUBLIC.
  A. Recompile the PL/SQL procedure.

• Question 280:

  Which two statements are true regarding the SGA_TARGET initialization parameter? (Choose two.)

  A. It can be increased up to the value of the SGA_MAX_SIZE parameter.
  B. Increasing the value of the SGA_TARGET parameter distributes the increased memory among all the autotuned components.
  C. Reducing the value of the SGA_TARGET parameter deallocates memory from both autotuned and manually sized components.
  D. Increasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic shared memory management feature.
  A. It can be increased up to the value of the SGA_MAX_SIZE parameter.
  B. Increasing the value of the SGA_TARGET parameter distributes the increased memory among all the autotuned components.