What is a schema?

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

(Continued from previous question...)

77. What is a schema?

Answer1
The set of objects owned by user account is called the schema.

Answer2
Schema is the complete design of the database or data objects.

(Continued on next question...)

Other Job Interview Questions

• How do you resize a data file?
• What is new_form built-in?
• What are the built-in used for getting cell values?
• How do you reference a parameter indirectly?
• What are the Referential actions supported by FOREIGN KEY integrity constraint?
• What is synchronize?
• How can you enable automatic archiving?
• Why is a Where clause faster than a group filter or a format trigger?
• What is the effect of setting the value “CHOOSE” for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command?
• What is the User-Named Editor?
• More...