A developer is trying to create a view and the d

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

(Continued from previous question...)

A developer is trying to create a view and the database won?t let him. He has the "DEVELOPER" role which has the "CREATE VIEW" system privilege and SELECT grants on the tables he is using, what is the problem?

Level: Intermediate
Expected answer: You need to verify the developer has direct grants on all tables used in the view. You can?t create a stored object with grants given through views.

(Continued on next question...)

Other Job Interview Questions

• How is it possible to select generate a select set for the query in the query property sheet?
• Give the two types of tables involved in producing a star schema and the type of data they hold.
• Is it possible to insert comments into sql statements return in the data model editor?
• How would you determine the time zone under which a database was operating?
• What is the effect of setting the value “ALL_ROWS” for OPTIMIZER_GOAL parameter of the ALTER SESSION command?
• How do you reference a Parameter?
• Implicit Cursor attributes
• What is the remove on exit property?
• How would you determine the time zone under which a database was operating?
• Logical DB Structure
• More...