1 What are the new features in Oracle 9i compared to earlier ones?
2.What is undo tablespace and why is called so?What was it called in earlier versions?
3.Now if you are appointed as a Oracle DBA in a company, can you tell what all are the databases that are running on a particular server?
4.Now if a database is in mount stage how can you find that database name since you are totally new to the company and know nothing how many databases and its status.
5.Assume if one user tells you that the database has failed, what all things would you check to find the failure?
6.What is sp file?
7.What are the important contents of init.ora?
8.What is db_block_size?In Oracle 9i if the db_block_size is 16K and I want to change it to 8k, is it possible?
9.What are the basic parameters to be set while installing Oracle on unix?
10.What is hot backup?
1. What is an Instance?
2. What is a Role?
3. Can a privilege be assigned to role with grant option?
4. What is Package?
5. Have you created the database? What are the scripts that are run after database creation and what are they meant for? Each of them?
6. Have you ever replicated the Database? (Cloning)
7. Write a query on Employee table emp (eno,ename,deptno,sal) and select employees whose sal is greater than average sal of their departments?
8. Write a Query to display student information student (sno,sname,marks) show four columns i.e., sno,sname,marks and grade?
Criteria: If marks between 60 to 70 then “C”
If marks between 70 to 80 then “B”
If marks between 80 to 90 then “A”
9. Write a query to show all the tablespaces in the database and the sizes of each tablespace?
10. Have you ever user SQL*Loader?
11. How would you replicate or create another Database?
12. Can the table along with table data exported? Can only the table structure be exported?
13. What is the differences between PFILE and SPFILE?
1. What are you day-to-day activities? Backups?
2. What are the new features in Oracle 9i?
3. Explain the Architecture of Oracle?
4. Have you used Raw Devices?
5. Can two Undo Tablespaces exist at a same time being Active?
6. What happens when there are transctions left in undo1 and mean while we make undo1 offline & undo2 online?
7. What do you do to check whether there is any problems in the Database?
8. What are the different types of recoveries? What is cancel-based recovery?
9. What has to be done after performing recovery? After opening DB with resetlogs can you apply previous archived logs?
10. What is difference between Dictionay managed and Locally Managed?
11. Can we assign AUTO to the dictionary managed tablespaces?
12. What are the steps involved in the installation process?
13. What are Kernel parameters?
14. What is the procedure involved to bring the database down and up along with the server turning on & off?
(What has to be done if there are more than one instance what has to be done to bring all the instances, databases down or running them all at the same time)
15. What are the main statistics obtained and where are they stored after performing STATSPACK statistics?
No comments:
Post a Comment