What is explain plan and how is it used?
No Answer is Posted For this Question
Be the First to Post Answer
Are database administrators in demand?
If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?
What is a junior dba?
The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?
What is a dba?
What are the daily activities of oracle dba?
What do you understand by a control file?
Explain the wait events in statspack report 'enqueue'?
Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?
What do you understand by the oracle?
What skills do you need to be a database administrator?
What are the different types of backup available in the oracle?