Oracle DBA Interview questions

0. What is the database holding Capacity of Oracle ?

1. Why in 10G, when you use real time apply feature in conjunction with Maximum Protection, you can achive

2. You have taken import of a table in a database. you have got the Integrity constraint violation error.

3. what are the diffrent file types that are supported by SQL*Loader?

4. How to find how many database reside in Oracle server in query?

5. Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given

6. What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement

7. HOW 2 ENABLE PARTITIONING FEAUTURE IN ORACLE 8i

8. How many memory layers are in the shared pool?

9. What are the attributes of the Virtual Indexes

10. Virtual Indexes in Oracle

11. What are materialized views? when are they used?

12. What is a functional index - explain?

13. Where we use bitmap index ?

14. What is an extent

15. How to you move from Dedicated server Process to a Shared Server Process

16. What are the components of physical database structure of Oracle database

17. What are the components of logical database structure of Oracle database

18. How can be determine the size of the log files

19. How can be determine the size of the database?