A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?
No Answer is Posted For this Question
Be the First to Post Answer
When should the default values for oracle initialization parameters be used as is?
What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?
What database block size should I use?
If you see the value for reloads is high in the estat library cache report is this a matter for concern?
What do you understand by the term 'normalization'? Explain the various modes of normalization?
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?
You see a wait on lms process in statspack, what does that mean?
What is explain plan and how is it used?
What are types of data model?
What is the use of the drop option in the alter table command?
You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?
What degree do database administrators need?