Oracle 1Z0-052 Actual Free Exam Questions & Community Discussion
Which three can be used to schedule automated backups of the database? (Choose three.)
Correct Answer: B,D,F
Vote an answer
Which two statements are true about tablespaces? (Choose two.)
Correct Answer: A,C
Vote an answer
For which database operation would you need the database to be in the MOUNT state?
Correct Answer: E
Vote an answer
You are installing Oracle Database 11g on your server. During the installation Oracle Universal Installer (OUI) prompts you to enter the path of the inventory directory and also prompts you to specify an operating system group name.
Which statement is true in this case?
Which statement is true in this case?
Correct Answer: E
Vote an answer
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
Session memory for the shared serverBuffers for I/O slavesOracle Database Recovery Manager (RMAN) backup and restore operations
Correct Answer: A
Vote an answer
Examine the commands executed in the following sequence:
Which statement is true about the above commands?
Which statement is true about the above commands?
Correct Answer: B
Vote an answer
In your production database, data manipulation language (DML) operations are executed on the SALES table.
You have noticed some dubious values in the SALES table during the last few days. You are able to track users, actions taken, and the time of the action for this particular period but the changes in data are not tracked. You decide to keep track of both the old data and new data in the table long with the user information.
What action would you take to achieve this task?
You have noticed some dubious values in the SALES table during the last few days. You are able to track users, actions taken, and the time of the action for this particular period but the changes in data are not tracked. You decide to keep track of both the old data and new data in the table long with the user information.
What action would you take to achieve this task?
Correct Answer: B
Vote an answer
A database instance was terminated due to a lost data file and has not been restarted.
You wish to restore database availability by using the Data Recovery Advisor.
Examine this list of RMAN commands:
What are the minimum required commands and in what order must they be executed to achieve this?
You wish to restore database availability by using the Data Recovery Advisor.
Examine this list of RMAN commands:
What are the minimum required commands and in what order must they be executed to achieve this?
Correct Answer: A
Vote an answer
Which two statements are true about alerts? (Choose two.)
Correct Answer: B,C
Vote an answer
You are working on a new Oracle Database 11g server, where only the software is installed and no database is created. You plan to create a database on this server using the Database Configuration Assistant (DBCA).
Some of the requirements set for your database creation task are:
1 . Configure the database to operate in shared server mode.
2 . Disable automatic maintenance tasks such as optimizer statistics collection.
3 . Configure a naming method to help the remote user connect to the database instance.
4 . Use Automatic Storage Management (ASM) for storing the database files.
5 . Configure daily database backup to flash recovery area.
6 . Configure Enterprise Manager Database Control to manage the database.
Which of these requirements can be met while creating the database?
Some of the requirements set for your database creation task are:
1 . Configure the database to operate in shared server mode.
2 . Disable automatic maintenance tasks such as optimizer statistics collection.
3 . Configure a naming method to help the remote user connect to the database instance.
4 . Use Automatic Storage Management (ASM) for storing the database files.
5 . Configure daily database backup to flash recovery area.
6 . Configure Enterprise Manager Database Control to manage the database.
Which of these requirements can be met while creating the database?
Correct Answer: A
Vote an answer
View the Exhibits and examine lock waits. Users HR and SH complain that their transactions on one of the application tables, EMP, are waiting for response.
Which action would you take to release the lock and enable users HR and SH to continue with their transactions?
07 (exhibit):
08 (exhibit):
Which action would you take to release the lock and enable users HR and SH to continue with their transactions?
07 (exhibit):
08 (exhibit):
Correct Answer: D
Vote an answer
0
0
0
10