Database Administration Interview Questions
- What is ORA-1555?
- Do View contain Data?
- What is Parallel Server?
- How do you sort a table?
- How is locking implemented?
- What is network database link?
- What is a deadlock and Explain?
- What is the function of redo log?
- What are the advantages of views?
- Can we decrease the Data file size?
- What are the types of database links?
- What are the uses of rollback segment?
- What is the use of redo log information?
- What is a database instance and Explain?
- What are the characteristics of data files?
- What are the different types of segments?
- Do you need a commit after DDL statements?
- How would you pass hints to the SQL processor?
- What type of index should you use on a fact table?
- How can you find all the tables created by an user?
- What are the large object types suported by Oracle?
- What is SYSTEM table space and when is it created?
- Whats the difference between indexes, views, synonyms?
- Shall we create procedures to fetch more than one record?
- What rule optimizations are possible in SQL query tuning?
- What is the relation between free list and buffer busy wait?
- Where would you look for errors from the database engine?
- How do you handle exceptions / errors in stored procedures?
- Name some built-in functions that can be used in SQL queries?
- Can objects of the same schema reside in different table spaces?
- What is an index and how it is implemented in Oracle database?
- How do you find which database the user is connected in oracle 10g?
- What are the basic element of Base configuration of an oracle Database?
- Whenever a DBA creates a user in which data file that will be get created?
- What are the components of logical database structure of Oracle database?
- Why is it important to write to the log before changing the database values?
- Do you consider yourself a development DBA or a production DBA and why?
- What are the different modes of mounting a Database with the Parallel Server?
- Is it advisable to force an index when you want to select most of the entries in the table?
- Explain how a database could be recovered via reprocessing. Why is this generally not feasible?