DBA > Job Interview Questions > DATABASE Administrator (DBA) Interview Questions and Answers

A user is getting an ORA-00942 error yet you kno

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

A user is getting an ORA-00942 error yet you know you have granted them permission on the table, what else should you check?

Level: Low
Expected answer: You need to check that the user has specified the full name of the object (select empid from scott.emp; instead of select empid from emp;) or has a synonym that points to the object (create synonym emp for scott.emp;)

(Continued on next question...)

Other Job Interview Questions