What are the main benefits of using spfile over pfile?
No Answer is Posted For this Question
Be the First to Post Answer
A tablespace has a table with 30 extents in it. Is this bad? Why or why not.
A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?
What is the relation between database and instance?
Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?
What degree do database administrators need?
What is the main function of database?
What does database administrator do?
What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?
What operator tests column for the absence of data?
What are database skills?
If you see statistics that deal with "undo" what are they really talking about?
Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?