-
Degree of Relationship
What is the degree of relationship? Name the three degrees.
-
-
Names of Constraints
Oracle stores information regarding the names of all the constraints on which table? A)USER_CONSTRAINTS B)DUAL C)USER D)None of these
-
-
-
-
Remove one duplicate column value from multiple
How to remove only one column values from the duplication of values in that column without using any other column references in that table?
-
MultiSet table with UPI
Multiset table with UPI will allow duplicates or not?
Excessive redo generation.
Why excessive redo generation in hot backups ?How to resolve it ?
SQL Query
How to display nth lowest record in a table for example? How to display 4th lowest (salary) record from customer table?
SQL Loader
How does Export/Import feature differ from that of SQL Loader?
Primary Key
Why is the choice of primary key important and are three characteristics of an ideal primary key?
Controlled and Uncontrolled Redundancy
Differentiate between Controlled and Uncontrolled Redundancy
Ans