Practice Exams Add To Favourite
Practice Exams provides numerous Tests, Course Sample Papers with solution for Microsoft Certification like MCSE, MCSA, and A+ Cisco Certified Associate level CCNA, CCNP, Certification Exams, Linux, Oracle and Juniper Certifications.
    

Oracle OCA DBA 10g Practice Exam Questions

Practice Exams provide free Oracle OCA DBA 10g Certification tests for help you to prepare for final exam.

Oracle OCA DBA 10g Exam 1Z0-042 Practice Test Questions
01. Susan, a DBA issues the following command in sqlplus. CREATE DATABASE sample. Which of the tablespaces are automatically created?

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

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

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

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

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

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?

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?

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?

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?

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?

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?

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?

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

15. Which of the following statements for a Flashback throws an error in an Oracle 10g database?
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?

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;

18. Which of the following is not true about Oracle instance and a 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?

20. Information about stateless and stateful alerts is available in which of the following dynamic performance view in an Oracle 10g database?
21. Which of the following is not true about DBCA templates in an Oracle 10g 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?
23. Which of the following information is not available in alert.log?
24. Which of the following statements for a Flashback throws an error in an Oracle 10g database?
25. What is the effect of setting a very high value (say 3600) for FAST_START_MTTR_TARGET?

    
      Home                                                                                                                                                                   Contact us