|
| 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 : datafile,control file and redo logs ... Latest Answer : Data objects are used to stored data when needs to grow take chunks of space that is called extents and an data objects multiple extents are stored in segment. ... Latest Answer : an oracle object contains information in rows and columns ... Latest Answer : A view is a named query. It is “a tailored presentation of the data contained in one or more tables (or other views).” For SQL, view = a named or derived virtual table • For users, view = a table (which in fact does not exist!) • ... Latest Answer : A sequence is a database object created by a user that can be used to generate unique integers. A typical usage of sequences is to generate primary key values which are unique for each row. It is generated and incremented (or decremented) by an ... Latest Answer : An Index is based on tree structre that allow direct access to a row in a table, oracle uses different type of index 1) B-Tree Index2) Bitmap Index ... Latest Answer : Index is an object in the oracle database used to speed up the performance of the queries ie. it improves the access speed and response of query will be good when the query makes use of Index.ThanksHarsha ... Latest Answer : It consists of - one or more data files - one or more control files - two or more redo log files The database contains - Multiple users/schema's - one or more rollback segments - one ... A deadlock is a condition where two or more users are waiting for data locked by each other. Oracle automatically detects a deadlock and resolves them by rolling back one of the statements involved in Latest Answer : Deadlock occurs when two or more users are waiting for data locked by each other. When this happens, these users are stuck (deadly embraced) and cannot continue processing. Oracle automatically detects deadlocks and resolves them by rolling back ... A database instance (Server) is a set of memory structure and background processes that access a set of database files. The process can be shared by all users. The Latest Answer : Database instance(server) is the combination of memory structure and background process. It's a way to connect to the oracle database. ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
