Oracle database 10g:Administration I - 1Z0-042 Exam Practice Test
You are working on the 24X7 database with high transaction volume, to ensure faster instance recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low value. What effect it will have on the database?
Correct Answer: C
Vote an answer
Examine the following commands executed in your database:
SQL> ALTER SESSION RECYCLEBIN=ON;
Session altered
SQL> CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees;
Table created.
Further, you executed the following command to drop the table:
SQL> DROP TABLE emp; Table dropped.
What happens in this scenario?
SQL> ALTER SESSION RECYCLEBIN=ON;
Session altered
SQL> CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees;
Table created.
Further, you executed the following command to drop the table:
SQL> DROP TABLE emp; Table dropped.
What happens in this scenario?
Correct Answer: A
Vote an answer
You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA?
Correct Answer: C
Vote an answer
Your database is not configured for session failover. Your tnsnames.ora file contains the following details:
test.us.oracle.com= (DESCRIPTION= (ADDRESS_LIST= (LOAD_BALANCE=off) (FAILOVER=ON) (ADDRESS=(PROTOCOL=tcp)(HOST=test1-server)(PORT=1521)) (ADDRESS=(PROTOCOL=tcp)(HOST=test2-server)(PORT=1521)))
(CONNECT_DATA=(SERVICE_NAME=test.us.oracle.com)))
Which feature is enabled in this case?
test.us.oracle.com= (DESCRIPTION= (ADDRESS_LIST= (LOAD_BALANCE=off) (FAILOVER=ON) (ADDRESS=(PROTOCOL=tcp)(HOST=test1-server)(PORT=1521)) (ADDRESS=(PROTOCOL=tcp)(HOST=test2-server)(PORT=1521)))
(CONNECT_DATA=(SERVICE_NAME=test.us.oracle.com)))
Which feature is enabled in this case?
Correct Answer: D
Vote an answer
You execute the following command to audit the database activities:
SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;
What is the effect of this command?
SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;
What is the effect of this command?
Correct Answer: E
Vote an answer
You created a response file and want to check it before starting installations in silent mode. You started installation of Oracle software in interactive mode by providing the response file. In the middle of the installation, you realize that the behavior of the Oracle Universal Installer (OUI) is not consistent with the response file. What action would you take to detect the cause of this behavior?
Correct Answer: D
Vote an answer
Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2, and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk. Which command would you execute to proceed further?
Correct Answer: D
Vote an answer
Which statement is true when you run the SQL Tuning Advisor with limited scope?
Correct Answer: D
Vote an answer
In the middle of a transaction, a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario? (Choose two.)
Correct Answer: C,D
Vote an answer
In your database, the snapshot interval is set to 10 minutes for the Automatic Workload Repository (AWR). The database instance is running for the past 30 days.
View the Exhibit to examine the Automatic Database Diagnostic Monitor (ADDM) task.
The ADDM task is performed every 10 minutes, except the last task. What could be the reason for this?
View the Exhibit to examine the Automatic Database Diagnostic Monitor (ADDM) task.
The ADDM task is performed every 10 minutes, except the last task. What could be the reason for this?
Correct Answer: A
Vote an answer