What is the difference between internal & external schema?
No Answer is Posted For this Question
Be the First to Post Answer
What is explain plan and how is it used?
A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.
What do you mean by oracle dba?
How do you set up your tablespace on installation level: low?
What does >> do?
How many databases should a dba manage?
How do you install statspack?
Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)
What happens if the constraint name is left out of a constraint clause?
What are functions of dba?
How can you find out how many users are currently logged into the database? How can you find their operating system id?
What is a database instance?