Guaranteed of 1z0 052 pdf exam price materials and braindump for Oracle certification for consumer, Real Success Guaranteed with Updated 1z0 052 pdf pdf dumps vce Materials. 100% PASS Oracle Database 11g: Administration I exam Today!

Q11. For which database operation would you need the database to be in the MOUNT state?

A. Renaming the control files

B. Re-creating the control files

C. Dropping a user in your database

D. Dropping a tablespace in your database

E. Configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes

Answer: E


Q12. In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value?

A. When the data file of the undo tablespace is autoextensible

B. When there are more than one undo tablespace available in the database

C. When the undo tablespace is of a fixed size and retention guarantee is not enabled

D. When the undo tablespace is autoextensible and retention guarantee is not enabled

Answer: C


Q13. Which two statements are true regarding a tablespace? (Choose two.)

A. It can span multiple databases

B. It can consist of multiple data files

C. It can contain blocks of different files

D. It can contains segments of different sizes

E. It can contains a part of nonpartitioned segment

Answer: BD


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

Answer: C


Q15. 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."

Answer: AE


Q16. You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups.

Which three statements are true about these backups? (Choose three.)

A. The backups would be consistent.

B. The backups would be inconsistent.

C. The backups would be possible only if the database is running in ARCHIVELOG mode.

D. The backups would be possible only if the database is running in NOARCHIVELOG mode.

E. The backups need to be restored and the database has to be recovered in case of a media failure.

Answer: BCE


Q17. You receive complaints from users regarding the high waiting time for their transactions. On investigation, you find that some users are not committing their transactions though they are not performing any activity for a long time. As a result, SQL statements need to wait for rowlevel locks.

Which two actions could you take to prevent this locking problem in the future? (Choose two.)

A. Decrease the IDLE_TIME resource limit in the profile assigned to the blocking users.

B. Use Database Resource Manager to automatically log out sessions that block others and are idle

C. Set the limit in the profile of blocking users to control the number of blocks to be accessed in a session.

D. Decrease the maximum number of interested transaction list (ITL) slots for the segments on which the blocking user performs the transaction.

Answer: AB


Q18. Note the following structures in your database server:

1. Extents

2. OS Blocks

3. Tablespace

4. Segments

5. Oracle Data Block

Which option has the correct arrangement of these structures from the smallest to the largest?

A. 2, 5, 1, 4, 3

B. 1, 2, 3, 4, 5

C. 5, 2, 1, 3, 4

D. 2, 1, 5, 4, 3

Answer: A


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

Answer: A


Q20. View the Exhibit and examine the undo tablespace attributes. Your database instance is experiencing a large volume of transactions from non-DBA users in the last one hour. The undo tablespace NDOTBS1 is full with transactions and no transaction was committed more than one hour ago. The database has two more undo tablespaces.

What happens to the new DML operations in this scenario?

Exhibit:

A. The DML commands will fail

B. The undo data generated by the DML is stored in one of the two other undo tablespace

C. The undo data generated by the DML will overwrite the extents that contain committed undo data

D. The undo data generated by the DML is stored in the SYSTEM undo segment of the SYSTEM tablespace

Answer: A