 Related Questions Latest Answer : The database is actually a collection of objects, which are made up of tablespaces and each tablespace must have datafile associate with it. The tablespace cannot be created without datafile. The tablespaces are two kind physical and logical.The logical ... Latest Answer : SGA+Background Process = InstanceAs soon as user process starts and server process takes control from user process, instance created with help of background processes and most important background processes are dbwriter, logwriter, checkpoint, SMON, PMON ... 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. ... 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 : PGA Program global area Contains Session variables ,Stack space,Cursor status ,Sort Areas ... Latest Answer : Function-based indexes can use any Function or Object method that is declared as repeatable. Queries using expressions can use the index. Ex:- CREATE INDEX sales_margin_inx ON sales(revenue - cost); Sql> SELECT ... Virtual Indexes are another undocumented feature used by Oracle. Virtual indexes, as the name suggests are pseudo-indexes that will not behave the same way that normal indexes behave, and are meant for View Question | Asked by : David Latest Answer : Export is one of taking backup. In export backup you can specify many parameters in par file or at command line. One of the parameter is statistics=y or n. If you specify y it is going to export statistics generated in the database placed ... How you spend a day as a DBA. Explain DBA activities in detail.
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
