|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions Latest Answer : an oracle object contains information in rows and columns ... An index is a database structure used by the server to have direct access of a row in a table. An index is automatically created when a unique of primary key constraint clause Latest Answer : Indexes are used both to improve performence and to ensure uniquness of a column. Oracle automatically creates an index when a UNIQUE or PRIMARY key constarints clause is specified in a create table command.We can manually create our own indexes via the ... It consists ofone or more data files.one or more control files.two or more redo log files.The Database containsmultiple users/schemasone or more rollback segmentsone or more tablespacesData dictionary Two processes wating to update the rows of a table which are locked by the other process then deadlock arises. In a database environment this will often happen Latest Answer : Oracle automatically detect deadlock , but not occar ... Latest Answer : 1. Parse: a. Search for identical statementb. Check syntax, object names, and privilegesc. Lock objects used during parsed. Create and store execution plan2. Execute: Process the Statement3. Fetch: Return rows to User Process ... Enqueues are another type of locking mechanism used in Oracle. An enqueue is a more sophisticated mechanism which permits several concurrent processes to have varying degree of sharing of "known" Latest Answer : An enqueue is a sophisticated locking mechanism that permits several concurrent processes to share known resources to varying degrees. Any object that can be used concurrently can be protected with enqueues. For example, Oracle allows varying levels of ... This is extract from Oracle10g Advanced Replication Book. How Materialized Views Work with Object Types and CollectionsOracle object types are user-defined datatypes that make it possible to model complex You have taken import of a table in a database. you have got the Integrity constraint violation error. How you are going to resolve it. Read Answers (4) | Asked by : Gaurav Latest Answer : You can set primary key on table upto 16 columns of table in oracle 9i and 10g ... Read Answers (1) | Asked by : Sachin Talwar Latest Answer : Try using substitution variable likeDROP TABLE &table_name ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
