What column differentiates the V$ views to the G

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

(Continued from previous question...)

166. What column differentiates the V$ views to the GV$ views and how?

The INST_ID column which indicates the instance in a RAC environment the information came from.

(Continued on next question...)

Other Job Interview Questions

• What is a SQL * NET?
• How do you resize a data file?
• Where is a procedure return in an external pl/SQL library executed at the client or at the server?
• What are the roles and user accounts created automatically with the database?
• Give one method for transferring a table from one schema to another
• What is Archived Redo Log?
• What are the different Parameter types?
• What type of index should you use on a fact table?
• Define Transaction?
• If you have an example table, what is the best way to get sizing data for the production table implementation?
• More...