Oracle 11g (1z0-052) exam

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



 

 

 

 

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




 

 

 

 

3. The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in your database instance. At a certain point of time, the maintenance window closes before the statistics are gathered for all objects.

Which statement is true in this scenario?




 

 

 

 

4. SQL> CREATE BIGFILE TABLESPACE MRKT
2 DATAFILE ‘/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING
3 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
Tablespace created.
SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT;
Database altered.
Which two statements are true regarding the MRKT tablespace? (Choose two.)




 

 

 

 

5. In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC.
What is the impact of this setting?




 

 

 

 

 

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



 

 

 

 

 

7. Examine the values for the following initialization parameters:
FAST_START_MTTR_TARGET=0
LOG_CHECKPOINT_INTERVAL=0
Which two will be the implications of these values in your database? (Choose two.)




 

 

 

 

8. Examine the command:
SQL>ALTER USR skd ACCOUNT LOCK;

Which two statements are true after the command is executed? (Choose two.)




 

 

 

 

9. You executed the following command to create a tablespace called SALES_DATA:

SQL> CREATE TABLESPACE sales_data
DATAFILE SIZE 100M
SEGMENT SPACE MANAGEMENT AUTO;

Which two statements are true about the SALES_DATA tablespace? (Choose two)



 

 

 

 

 

10. 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?




 

 

 

 

11. Which three statements regarding the server parameter file (SPFILE) are true? (Choose three.)




 

 

 

 

 

 

12. You want to check the details of few errors that users have reported. You search for the alert log file and execute few commands to find the location of the alert log file.
View the Exhibit and check the commands executed.

What is the location of the alert_orcl.log file?




 

 

 

 

 

 

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




 

 

 

 

 

14. You want to move all objects of the APPS user in the test database to the DB_USR schema of the production database. Which option of IMPDP would you use to accomplish this task?




 

 

 

 

 

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




 

 

 

 

 

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




 

 

 

 

17. You notice that the performance of the database has degraded because of frequent checkpoints.
Which two actions resolve the issue? (Choose two.)




 

 

 

 

18. You have recently collected statistics on certain objects of a schema in your database. But you observe suboptimal execution plans for the queries on these objects after two days of statistics collection. The optimizer statistics retention period is set to its default value.

Which action would help to use the previous set of statistics on the objects?




 

 

 

 

19. You executed the following command to create a password file in the database server:
$ orapwd file = orapworcl entries = 5 ignorecase=N
Which statement describes the purpose of the above password file?




 

 

 

 

20. Examine the command:
SQL>DBMS_STATS.SET_TABLE_PREFS(‘SH’,’CUSTOMERS’,’PUBLISH’,’false’);

Which statement describes the effect of the above command?




 

 

 

 

Share this
Share

Question 1 of 20

Share this
Share
Share