Are database administrators in demand?
No Answer is Posted For this Question
Be the First to Post Answer
What do you understand by the term 'normalization'? Explain the various modes of normalization?
You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.
Who is a database user?
You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?
What does a senior database administrator do?
When configuring sqlnet on the server what files must be set up?
What are the main benefits of using spfile over pfile?
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 is ora-1555 snapshot too old error? Explain in detail?
What is oracle log switch?
What does an oracle dba do?
What is the difference between truncate and delete? How would a full table scan behave after?