Oracle 1Z0-052 Online Practice Questions and Exam Preparation

Oracle 1Z0-052 Online Questions & Answers

• Question 31:

  In a new installation of Oracle Database 11g, you perform these activities:

  1.

  Organize software and data on different subdirectories to avoid poor performance.

  2.

  Use consistent naming conventions for database files.

  3.

  Separate administrative information pertaining to the database in different directories. Which option corresponds to the type of activities you performed?

  A. Oracle Managed Files
  B. Oracle Grid Architecture
  C. Optimal Flexible Architecture
  D. Oracle database architecture
  E. Automatic Storage Management
  C. Optimal Flexible Architecture

• Question 32:

  USER1.EMP has a referential integrity constraint defined on EMP.DNO that references USER1.DEPT.DNO.

  USER1 executes these commands:

  

  What will be the outcome and why?

  A. It will execute successfully and drop the DEPT.DNO and EMP.DNO columns
  B. It will fail because there is an uncommitted transaction on USER1.EMP
  C. It will execute successfully and drop DEPT.DNO
  D. It will fail because a referential integrity constraint is defined on USER1.EMP
  E. It will fail because there is an uncommitted transaction on USER1.DEPT
  C. It will execute successfully and drop DEPT.DNO

• Question 33:

  The session of user SCOTT receives the following error after executing an UPDATE command on the EMP table:

  ERROR at line 1:

  ORA-00060: deadlock detected while waiting for resource

  On investigation, you find that a session opened by user JIM has a transaction that caused the deadlock.

  Which two statements are true regarding the session of SCOTT in this scenario? (Choose two.)

  A. The session is terminated after receiving the error and JIM can continue with his transaction.
  B. SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.
  C. The session is rolled back after receiving the error and JIM can continue with his transaction.
  D. SCOTT has to reexecute the last command in the transaction after he commits the transaction.
  B. SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.
  D. SCOTT has to reexecute the last command in the transaction after he commits the transaction.

• Question 34:

  Note the functionalities of various background processes:

  1: Perform recovery at instance startup.

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

  3: Cleanup the database buffer cache when a process fails.

  4: Dynamically register database services with listeners.

  5: Monitor sessions for idle session timeout.

  6: Cleanup unused temporary segments.

  7:

  Record the checkpoint information in control file.

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

  A. Checkpoint (CKPT): 1, 2, 5
  B. System Monitor (SMON): 1, 6
  C. Process Monitor (PMON): 4, 6, 7
  D. Database Writer (DBWR): 1, 3, 4
  B. System Monitor (SMON): 1, 6

• Question 35:

  You want to configure and schedule offline database backups to run automatically. Which tool or utility would you use to achieve this?

  A. The XML script
  B. The PL/SQL script
  C. The DBMS_SCHEDULER package
  D. Enterprise Manager to schedule the backup
  D. Enterprise Manager to schedule the backup

• Question 36:

  In which of the scenario will the DBA perform recovery? (Choose all that apply.)

  A. The alert log file is corrupted
  B. A tablespace is accidentally dropped
  C. One of the redo log members is corrupted
  D. A database user terminates the session abnormally
  E. The hard disk on which the data files is stored is corrupted
  B. A tablespace is accidentally dropped
  E. The hard disk on which the data files is stored is corrupted

• Question 37:

  Your database is in shutdown state. What will happend if you issue next command: SQL> startup

  A. instance will started
  B. instance started and DB is mounted
  C. instance started, DB opened and finally mounted
  D. instance started, DB mounted and finally opened
  D. instance started, DB mounted and finally opened

• Question 38:

  Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup. What would you do to recover the data file?

  A. Take the USERS tablespace offline and re-create the lost data file
  B. Shutdown the instance, restore the data file from the last consistent backup and restart the database instance
  C. Shutdown the instance, restores all the database files from the last consistent backup and restart the database instance
  D. Take the USERS tablespace offline, restore all the data files of the USERS tablespace from the last consistent backup and make the tablespace online
  C. Shutdown the instance, restores all the database files from the last consistent backup and restart the database instance

• Question 39:

  You created a profile APP_USER and assigned it to the users. After a month, you decide to drop the profile. Some user sessions are currently connected to the database instance and are using the APP_USER profile.

  This command is used to drop the profile:

  SQL> DROP PROFILE app_user;

  Which statement describes the result?

  A. The command produces an error.
  B. The profile is dropped and current user sessions use the DEFAULT profile immediately.
  C. The profile is dropped and only the subsequent user sessions use the DEFAULT profile.
  D. The profile is dropped, the sessions are terminated, and the subsequent user sessions use the DEFAULT profile.
  A. The command produces an error.

• Question 40:

  The instance abnormally terminates because of a power outage. Which statement is true about redo log files during instance recovery?

  A. Inactive and current redo log files are required to accomplish recovery
  B. Online and archived redo files are required to accomplish instance recovery
  C. All redo log entries after the last checkpoint are applied from redo log files to data files
  D. All redo log entries recorded in the current log file until the checkpoint position are applied to data files
  C. All redo log entries after the last checkpoint are applied from redo log files to data files