Oracle Exam 1Z0-042 Practice

01. Susan, a DBA issues the following command in sqlplus. CREATE DATABASE sample. Which of the tablespaces are automatically created?

(A) SYSTEM, SYSAUX, UNDOTBS, TEMP

(B) SYSTEM, SYSAUX, UNDOTBS, TEMP, USERS

(D) SYSTEM, SYSAUX

02. What of the following statements are true about dropping or truncating a table?

(A) Dropping a table removes the structure and the rows of the table

(B) Truncating a table removes the structure and the rows of the table

(D) While a table is truncated, triggers associated with the table are fired.

03. What is the effect of setting a very high value (say 3600) for FAST_START_MTTR_TARGET?

(A) Checkpoint frequency is increased.

(B) Checkpoint frequency is reduced.

(D) Both A and B

04. What are the initialization parameters to be set for enabling shared servers?

(A) No parameters need to be set. Shared server is enabled by default in Oracle database 10g.

(B) SHARED_SERVERS greater or equal to 1.This is the only parameter to be set.

(D) Both SHARED_SERVERS and DISPATCHERS should be set and should be greater or equal to 1.MAX_SHARED_SERVERS should be set greater than 1.

05. Which of the following statement is not true about segments, extents and tablespaces in an Oracle 10g database?

(A) Segments never cross tablespace boundaries.

(B) An extent is a logically contiguous allocation of space in a data file.

(D) A tablespace can have more than one data file associated with it.

06.Which of the following is not true about Dynamic performance views?

(A) Dynamic performance views are views on virtual tables that record current database activity.

(B) Simple queries can be used to extract information from Dynamic performance views.

(D) The Dynamic performance views can be altered or removed by any database administrator only.

07. In an Oracle 10g database a redo log file belonging to the current group becomes corrupt all of a sudden. There are only two redo log groups in the database. What should the administrator do to handle this situation without shutting down the database?

(A) Issue ALTER DATABASE CLEAR LOGFILE and reinitialize the corrupted log file.

(B) Create a new redo log group and a redo log file in that group and rename corrupted file to new file.

(D) The administrator has to shut down the database and perform media recovery.

08. Susan dynamically changed the value of SORT_AREA_SIZE in the server parameter file (spfile). But now she wants to remove this parameter from spfile, allowing it to assume the default value. How can she do this?

(A) ALTER SYSTEM RESET SORT_AREA_SIZE SCOPE=SPFILE SID =”*”;

(B) ALTER SYSTEM RESET SORT_AREA_SIZE=”0” SCOPE=”SPFILE SID =”*”;

(D) Both A & C

09. The senior DBA of the company “Acme” wants to use the features of the Oracle 10g database to proactively maintain the database. The DBA wants to enable the Automatic Database Diagnostic Monitor (ADDM) in the database to monitor the performance. How can the DBA do this?

(A) Do nothing. ADDM is automatically enabled in an Oracle 10g database.

(B) The STATISTICS_LEVEL parameter should be set to TYPICAL or ALL.

(D) If the STATISTICS_LEVEL parameter is set to BASIC ADDM is enabled by default in an Oracle 10g database.

10. Susan has configured Automatic storage management for her disk storage. She has created a disk group “D01” with redundancy level NORMAL (2 way mirroring). Now she wants to further ensure data integrity and wants to change redundancy level to HIGH (3- way mirroring).How can she do that?

(A) Alter the disk group and change the redundancy to HIGH.

(B) Create another disk group with the required redundancy (HIGH) and move the files to new disk group.

(D) Cannot change the redundancy of the disk group once created.

11. Tom the developer of an Oracle 10g database wants to use the new Data Pump feature. Which of the following is a mandatory step before Tom invokes the Data Pump Export utility?

(A) Tom should be a DBA.

(B) Directory objects have to be created by a DBA, because the dump files are written by the server, rather than by the client.

(D) The load method to be used (whether DIRECT PATH or EXTERNAL TABLE) need to be specified.

12.The default block size of the database as specified by the initialization parameter DB_BLOCK_SIZE is 4K.How many additional block sizes can be created in the database?

(A) One non-default block size greater than 32k can be created.

(B) Five non-default block size from 2K to 32K can be created.

(D) No other non-default block size can be created.

13. Susan inserts one row into employees table and commits. Tom inserts 1000 rows into the same emp table and commits. Which of the following is true?

(A) It takes more time to commit 1000 rows than 1 row.

(B) It takes less time to commit 1000 rows than 1 row.

(D) Cannot determine the time taken for a commit operation.

14. Which of the following statement is not true about temp files in an Oracle database 10g?

(A) Tempfiles are used to store intermediate results of a large sort operation.

(B) Application tables should not be created in tempfiles.

(D) Data entered into a temporary table can be rolled back.

15. Which of the following statements for a Flashback throws an error in an Oracle 10g database?

(A) FLASHBACK DATABASE TO TIME “TO_DATE (‘09/20/00’,’MM/DD/YY’)”;

(B) FLASHBACK DATABASE TO RESTORE POINT BEFORE_CHANGES;

(D) FLASHBACK DATABASE TO INCARNATION 1;

16. Tom the DBA wants to enable the standard audit trial in the Oracle 10g database which is currently disabled. Which of the following correctly details the steps required in enabling the standard audit trial?

(A) Log in as SYSDBA. Issue ALTER SYSTEM SET AUDIT_TRAIL=DB and restart the database.

(B) Log in as SYSDBA. Issue ALTER SYSTEM SET AUDIT_TRAIL=OS and restart the database.

(D) Log in as SYSDBA. Issue ALTER SYSTEM SET AUDIT_TRAIL=ALL and restart the database.

17. Susan administers an Oracle 10g database “db1” which has all Oracle-managed physical files. What will happen if she issues the following statement? DROP DATABASE db1;

(A) Files remain intact and can be reused later.

(B) Files are not deleted, but become obsolete and cannot be used later.

(D) Error occurs. Database cannot be dropped without first deleting all oracle managed files.

18. Which of the following is not true about Oracle instance and a database?

(A) An instance is a set of background process and shared memory area, whereas an Oracle database is a collection of operating system files or disk.

(B) An instance can mount and open more than one database in its entire lifetime, but only one database at a time.

(D) Many instances can mount and open the same database.

19. Susan, the administrator of an Oracle 10g database issues the following command. SET CONSTRAINTS ALL DEFFERED; Which of the following is the correct implication of the above command?

(A) All the constraints defined are not checked until the restart of the database.

(B) All the constraints defined are not validated ever.

(D) All the constraints defined temporarily disabled. They are not checked until the constraints are enabled again.

20. Information about stateless and stateful alerts is available in which of the following dynamic performance view in an Oracle 10g database?

(A) V$ALERT_HISTORY

(B) V$OUTSTANDING_ALERTS

(D) V$ALL_ALERTS

21. Which of the following is not true about DBCA templates in an Oracle 10g database?

(A) A duplicate database can be easily created using DBCA templates.

(B) Database files such as control file and redo log file can be easily configured later as desired after initially using DBCA templates.

(D) When using DBCA templates we need not define the database.

22. Tom, a senior DBA is doing a complete closed database recovery. The control file in the database is lost, but the redo files are intact. He has recreated the control file and about to open the database. What command should he issue?

(A) ALTER DATABASE OPEN;

(B) ALTER DATABASE OPEN RESETLOGS;

(D) ALTER DATABASE OPEN READONLY;

23. Which of the following information is not available in alert.log?

(A) Values of various initialization parameters like db_block_size, control_files, db_name etc.

(B) SQL statements like CREATE/DROP tables/indexes.

(D) Backup and restore information.

24. Which of the following statements for a Flashback throws an error in an Oracle 10g database?

(A) FLASHBACK DATABASE TO TIME “TO_DATE (‘09/20/00’,’MM/DD/YY’)”;

(B) FLASHBACK DATABASE TO RESTORE POINT BEFORE_CHANGES;

25. What is the effect of setting a very high value (say 3600) for FAST_START_MTTR_TARGET?

(A) Checkpoint frequency is increased.

(B) Checkpoint frequency is reduced.

Oracle OCA DBA 10g Practice Exam Questions