Oracle 1Z0-052 Online Practice Questions and Exam Preparation

Oracle 1Z0-052 Online Questions & Answers

• Question 101:

  Identify the two situations in which the alert log file is updated with details. (Choose two.)

  A. Running a query on a table returns "ORA-600: Internal Error"
  B. Inserting a value in a table returns "ORA-01722: Invalid Number"
  C. Creating a table returns "ORA-00955: name is already used by an existing object'
  D. Inserting a value in a table returns "ORA-00001: unique constraint (SYS.PK_TECHP) violated."
  E. Rebuilding an index using ALTER INDEX ... REBUILD fails with an error "ORA-01578: ORACLE data block corrupted (file # 14, block @ 50)."
  F. Rebuilding an index using ALTER INDEX .... REBUILD fails with an error "ORA-01578: ORACLE data block corrupted (file #14, block #50)."
  A. Running a query on a table returns "ORA-600: Internal Error"
  E. Rebuilding an index using ALTER INDEX ... REBUILD fails with an error "ORA-01578: ORACLE data block corrupted (file # 14, block @ 50)."

• Question 102:

  Which three descriptions are correct about the effects of the TRUNCATE command on a table? (Choose three.)

  A. The corresponding indexes for the table are also truncated.
  B. Delete triggers on the table are fired during the execution of the TRUNCATE command.
  C. The child table is truncated when the TRUNCATE command is applied on the parent table.
  D. The highwater mark (HWM) is set to point to the first usable data block in the table segment.
  E. No undo or very little undo data is generated during the execution of the TRUNCATE command.
  A. The corresponding indexes for the table are also truncated.
  D. The highwater mark (HWM) is set to point to the first usable data block in the table segment.
  E. No undo or very little undo data is generated during the execution of the TRUNCATE command.

• Question 103:

  Automatic Shared Memory Management is disabled for your database instance. You realize that there are cases of SQL statements performing poorly because of repeated parsing activity, resulting in degradation of performance. What would be your next step to improve performance?

  A. Run the SQL Access Advisor
  B. Run the memory Advisor for the SGA
  C. Run the memory Advisor for the PGA
  D. Run the memory advisor for the shared pool
  E. Run the memory advisor for the buffer cache
  D. Run the memory advisor for the shared pool

• Question 104:

  The ORCL database has CONTROL FILE AUTOBACKUP and BACKUP OPTIMIZATION enabled.

  TBS1 and TBS2 are the only user-defined tablespaces in ORCL.

  USER1.EMP is a table in TBS1.

  Examine these commands:

  

  From which files are modified blocks backed up?

  A. SYSTEM, SYSAUX, UNDO, and TBS1 only
  B. SYSTEM and SYSAUX only
  C. SYSTEM, SYSAUX, UNDO, and TBS2 only
  D. SYSTEM, SYSAUX and UNDO only
  E. SYSTEM, SYSAUX, UNDO, TEMP, TBS1 and TBS2
  A. SYSTEM, SYSAUX, UNDO, and TBS1 only

• Question 105:

  The tnsnames.ora file has an entry for the service alias ORCL as follows:

  ORCL =

  ( DESCRIPTION =

  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.24.216)(PORT = 1521))

  (CONNECT_DATA =

  (SERVER = DEDICATED)

  (SERVICE_NAME = orcl.oracle.com)

  )

  )

  The TNSPING command executes successfully when tested with ORCL, but you are not able to connect to the database instance with the following command:

  SQL> CONNECT scott/tiger@orcl

  What could be the reason for this?

  A. The listener is not running on the database node.
  B. The TNS_ADMIN environmental variable is set to a wrong value.
  C. The orcl.oracle.com database service is not registered with the listener.
  D. The DEFAULT_DOMAIN parameter is set to a wrong value in the sqlnet.ora file.
  C. The orcl.oracle.com database service is not registered with the listener.

• Question 106:

  Which two are true about undo tablespaces? (Choose two.)

  A. They must have only one data file
  B. Single instance databases can have only one active undo tablespace
  C. They always retain undo for the time period defined by UNDO_RETENTION
  D. They can be recovered only when an instance is in MOUNT state
  E. Tables can be created in undo tablespaces by SYS
  C. They always retain undo for the time period defined by UNDO_RETENTION
  E. Tables can be created in undo tablespaces by SYS

• Question 107:

  Which two affect the time taken for instance recovery? (Choose two.)

  A. size of archivelogs
  B. size of existing RMAN backupsets
  C. UNDO_RETENTION value
  D. size of UNDO tablespace
  E. FAST_START_MTTR_TARGET value
  F. size of redo logs
  E. FAST_START_MTTR_TARGET value
  F. size of redo logs

• Question 108:

  Which two statements are true regarding a PL/SQL package body? (Choose two.)

  A. It cannot be created without a package specification.
  B. It cannot invoke subprograms defined in other packages.
  C. It can contain only the subprograms defined in the package specification.
  D. It can be changed and recompiled without making the package specification invalid.
  A. It cannot be created without a package specification.
  D. It can be changed and recompiled without making the package specification invalid.

• Question 109:

  Note the following functionalities of various background processes:

  1.

  Record the checkpoint information in data file headers.

  2.

  Perform recovery at instance startup.

  3.

  Cleanup unused temporary segments.

  4.

  Free the resources used by a user process when it fails.

  5.

  Dynamically register database services with listeners.

  6.

  Monitor sessions for idle session timeout.

  Which option has the correct functionalities listed for a background process?

  A. Archiver Process (ARCn): 1, 2, 5
  B. System Monitor Process (SMON): 1, 4, 5
  C. Process Monitor Process (PMON): 4, 5, 6
  D. Database Writer Process (DBWn): 1, 3, 4
  C. Process Monitor Process (PMON): 4, 5, 6

• Question 110:

  Where is an expdp operation tracked?

  A. dump files
  B. log files
  C. control file
  D. Automatic Diagnostic Repository (ADR)
  E. master table (MT)
  C. control file