All About Approved 1Z0-052 exam dumps

Q1. 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

View Answer

Q2. 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.

View Answer

Q3. Identify the memory component from which memory may be allocated for:

Session memory for the shared serverBuffers for I/O slavesOracle Database Recovery Manager (RMAN) backup and restore operations

A. Large Pool

B. Redo Log Buffer

C. Database Buffer Cache

D. Program Global Area (PGA)

View Answer

Q4. You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sunday to tape:

Which two statements are true about differential incremental backups? (Choose two.)

A. The backup performed on Sundays contains all the blocks that have ever been used in the database

B. The backup performed on Sundays contains all the blocks that have changed since the last level 1 backup

C. The backup performed on each working day contains all the blocks that have changed since the last level 0 backup

D. The backup performed on Monday contains all the blocks that have changed since the level 0 backup and every other working day contains all the blocks that have changed since the level 1 backup

View Answer

Q5. You want to enable archiving on your database. Presently, the database is running in NOARCHIVELOG mode.

Given below are the steps to accomplish the task in random order:

1. Shut down the instance.

2. Execute the ALTER DATABASE ARCHIVELOG command.

3. Start up the instance and mount the database.

4. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1.

5. Open the database.

Which is the correct sequence of steps for accomplishing the task?

A. 4, 1, 3, 2, 5

B. 1, 3, 4, 5, 2

C. 1, 3, 2, 5; 4 not required

D. 4, 1, 5, 2; 3 not required

E. 1, 3, 4, 5; 2 not required

View Answer

Q6. View the Exhibit and examine the user information.

The user has been granted CONNECT and RESOURCE roles and no individual system privileges.

The SL_REP user executes this command to create a table:

SQL> CREATE TABLE orders (

oid number(6),

odate date,

ccode number(4),

oamt number(10,2)

) TABLESPACE purchase_space;

The PURCHASE_SPACE tablespace already exists in the database.

Which statement describes the effect of the command?

Exhibit:

A. The command executes successfully and creates the table in the USERS tablespace.

B. The command executes successfully and creates the table in the PURCHASE_SPACE tablespace.

C. The command produces an error because the user does not have the privilege to createthe table.

D. The command produces an error because the user does not have quota in the PURCHASE_SPACE tablespace.

View Answer

Q7. See the Exhibit:

Which statements are true regarding the USERS tablespace? (Choose all that apply.)

A. A bitmap is used to record free extents

B. Free extents information is managed within the tablespace

C. Free extents information is managed in the SYSAUX tablespace

D. The data dictionary tables are updated when extents are allocated or deallocated

View Answer

Q8. You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add a new column to the EMPLOYEE table to achieve this.

Which data types would you use for the new column?

A. CLOB

B. BLOB

C. BFILE

D. LONG RAW

View Answer

Q9. 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.

View Answer

Q10. Your database instance is configured with automatic undo management and the UNDO_RETENTION parameter is set to 900 seconds. You executed the following command to enable retention guarantee:

SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;

What affect would this command have on the database?

A. The extents in the undo tablespace retain data until the next full database backup

B. The extents containing committed undo in the undo tablespace are not overwritten for at least 15 minutes

C. The extents containing committed data in the undo tablespace are not overwritten until the instance is shut down

D. The extents containing committed undo in the undo tablepace are transferred to Flash Recovery Area before being overwritten

View Answer