|
| 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 : Table Space : The table space is useful for storing the data in the
database. When a database is created two table spaces are created.
a) System Table Space : This data file stores
all the tables related to the system and ... Latest Answer : information about the database,redologfile and datafile,archivelog file location and current scn no and redo log file ... Latest Answer : USE of Control File:Control file contains control information used to - Start an instance such as location of datafile and redo log files. These file maintain internal consistency and guide recovery operation. Control file is stored in .ctl format and ... 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. ... The primary functional difference between logical and physical standby database setups is that logical standby permits you to add additional objects (tables, indexes, etc) to the database, while physical Latest Answer : A physical or logical standby database is a database replica created from a backup of a primary database. A physical standby database is physically identical to the primary database on a block-for-block basis. It's maintained in managed ... Thhere are 3 different ways :-1) SELECT name, value FROM v$parameter WHERE name = 'spfile'; //This query will return NULL if you are using PFILE2) SHOW PARAMETER spfile // This query will returns Latest Answer : Go to OEM => Databases => ... => Instance => Configuration, in "Database and Instance Information" section, the last row shows spfile ... These are a few of the advantages of using DBCA:You can use its wizards to guide you through a selection of options providing an easy means of creating and tailoring your database. It allows you to provide Latest Answer : The Database Configuration Assistant guides you through the process of creating a new database, changing the configuration of an existing database, or deleting a database. Many of the database creation tasks you would normally perform manually are performed ... What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly? Read Answers (1) | Asked by : Manoj Kumar Latest Answer : I'm sceptical about the .mdb.The simple, answer is Fixed width or Delimited TEXT files. ... Read Answers (3) | Asked by : satyababu What is the difference between .ora and net file or .ora and .net or tnsnames.ora sqlnet.ora listener.ora what ever the differnence makes between ora and net.
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
