Oracle Database 11g: Administration I - 1Z1-052 Exam Practice Test
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: C
Vote an answer
In a system, large online transaction processing (OLTP) jobs run during the daytime that require a large database buffer cache. In the night, the system supports batch jobs that require a higher value to be set for the large pool. You must simultaneously configure the memory components to accommodate the peak requirement.
What would you do to automate this configuration for the memory components with change in mode of working?
What would you do to automate this configuration for the memory components with change in mode of working?
Correct Answer: B
Vote an answer
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?
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?
Correct Answer: A
Vote an answer
Which two events always cause the LGWR to write? (Choose two.)
Correct Answer: A,D
Vote an answer
View the Exhibit and examine the output of the query.
What do you infer from this?
What do you infer from this?
Correct Answer: C
Vote an answer
View the Exhibit and note the files available in the $ORACLE_HOME/dbs folder. The ASM instance is already running. You used the following steps to start the database instance and open the database:
Which file is used to start the instance in this case?
Exhibit:
Which file is used to start the instance in this case?
Exhibit:
Correct Answer: B
Vote an answer
In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value?
Correct Answer: D
Vote an answer
You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area of your database to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order:
1) Shut down the instance.
2) Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value.
3) Execute the ALTER DATABASE FLASHBACK OFF command.
4) Start up the instance and mount the database.
5) Execute the ALTER DATABASE FLASHBACK ON command.
6) Open the database.
Select the correct order in which these tasks need to be performed.
1) Shut down the instance.
2) Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value.
3) Execute the ALTER DATABASE FLASHBACK OFF command.
4) Start up the instance and mount the database.
5) Execute the ALTER DATABASE FLASHBACK ON command.
6) Open the database.
Select the correct order in which these tasks need to be performed.
Correct Answer: A
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
Which two statements are true regarding a PL/SQL package body? (Choose two.)
Correct Answer: A,C
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct path load method to perform this task. The table in which you plan to load data in an important table having various integrity constraint defined on it.
Which constraints will remain enabled by default during this operation? (Choose all that apply.)
Which constraints will remain enabled by default during this operation? (Choose all that apply.)
Correct Answer: B,C,E
Vote an answer