Oracle Oracle Certifications 1Z0-052 Questions & Answers

• Question 51:

  You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOG mode.

  Which two statements are true in this scenario? (Choose two.)

  A. You must shut down the database instance to perform the backups.

  B. You must configure the Flash Recovery Area (FRA) for the database.

  C. You can perform complete database backups without closing the database.

  D. All the previous closed database backups including control files become invalid afteryou configure the database to ARCHIVELOG mode.

  Correct Answer: CD

• Question 52:

  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.

  Correct Answer: BC

• Question 53:

  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.

  Correct Answer: C

• Question 54:

  You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows:

  Warning (%): 90

  Critical (%): 95

  Which background process is responsible for issuing alerts when the threshold is crossed?

  A. System monitor (SMON)

  B. Process monitor (PMON)

  C. Memory manager process (MMAN)

  D. Manageability Monitor process (MMON)

  Correct Answer: D

• Question 55:

  You are working on a database that must be functioning 24 hours a day, 7 days a week. The database is configured in ARCHIVELOG mode.

  Which two options do you have for performing user-managed backups? (Choose two.)

  A. You can perform consistent backups only.

  B. You can perform a complete database backup without shutting down the database instance.

  C. You can back up data files only when all data files have the same SCN recorded in the control file.

  D. You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGIN BACKUP or ALTER DATABASE BEGIN BACKUP commands.

  Correct Answer: BD

• Question 56:

  Which three statements are correct about temporary tables? (Choose three.)

  A. Indexes and views can be created on temporary tables.

  B. Both the data and the structure of temporary tables can be exported.

  C. Temporary tables are always created in a user's temporary tablespace.

  D. The data inserted into a temporary table in a session is available to other sessions.

  E. Data manipulation language (DML) locks are never acquired on the data of temporary tables.

  Correct Answer: ACE

• Question 57:

  Identify the two situations in which you use the alert log file in your database to check the 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. Inserting a row in a table returns "ORA-00060: deadlock detected while waiting for resource."

  Correct Answer: AE

• Question 58:

  You execute the following command to change the status of the SALES tablespace:

  SQL> ALTER TABLESPACE sales OFFLINE;

  Which statements describe the effect of the command? (Choose all that apply.)

  A. The tablespace would require recovery to go back online.

  B. A checkpoint is taken on all data files that are associated with the SALES tablespace.

  C. The sessions that subsequently try to access the objects in the SALES tablespace receivean error.

  D. The new status of the SALES tablespace is recorded in the control file when the database instance is closed.

  Correct Answer: BC

• Question 59:

  Examine the following statement that is used to modify the primary key constraint on the SALES table:

  SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE;

  Which three statements are true regarding the above command? (Choose three.)

  A. The constraint remains valid.

  B. The index on the constraint is dropped.

  C. It allows the loading of data into the table using SQL *Loader.

  D. New data conforms to the constraint, but existing data is not checked.

  E. It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

  Correct Answer: ABC

• Question 60:

  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.

  Correct Answer: BD