What happens if the constraint name is left out of a constraint clause?
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between a database and instance? What is the relation between them?
When should you increase copy latches?
What is the difference between internal & external schema?
What is an artificial (derived) primary key?
Which is the best option used to move database from one server to another serve on same network and why?
What happens when the default and temp tablespace clauses are left out from create user statements?
A tablespace has a table with 30 extents in it. Is this bad? Why or why not.
Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?
How many redo logs should you have and how should they be configured for maximum recoverability?
What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?
Explain the various modes of normalization?
How can you determine if an index needs to be dropped and rebuilt?