What happens if the constraint name is left out

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

(Continued from previous question...)

What happens if the constraint name is left out of a constraint clause?

Level: Low
Expected answer: The Oracle system will use the default name of SYS_Cxxxx where xxxx is a system generated number. This is bad since it makes tracking which table the constraint belongs to or what the constraint does harder.

(Continued on next question...)

Other Job Interview Questions

• What is a Text_io Package?
• Where in the Oracle directory tree structure are audit traces placed?
• What are the Large object types suported by Oracle?
• What are the different approaches used by Optimizer in choosing an execution plan?
• What is the purpose of the product order option in the column property sheet?
• How do you reference a parameter indirectly?
• What are the different default triggers created when Master Deletes Property is set to Cascade?
• You see the following on a status report: redo log space requests 23; redo log space wait time 0; Is this something to worry about? What if redo log space wait time is high? How can you fix this?
• How do you create a new session while open a new form?
• What is a master detail relationship?
• More...