Latest Answer: Bitmap index:------------A type of index that uses a string of bits to quickly locate rows in a table. Bitmap indexes are normally used to index low cardinality columns in a warehouse environment.Btree index:------------A type of index that ...
Latest Answer: Blob datatype is used for storing large Binary data Like Photos,signatures etc Clob datatype is used for stoeing large character data upto 4GB like resume and other docs ...
A data file can be associated with only one database. Once created a data file can't change size.One or more data files form a logical unit of database storage called a tablespace.
Latest Answer: Oracle architecture: Database->Tablespace->DatafilesData ...
SID (System Identifier) : A SID (almost) uniquely identifies an instance. Actually, $ORACLE_HOME, $ORACLE_SID and $HOSTNAME identify an instance uniquely. The SID is 64 characters, or
Latest Answer: SID is used when we want to login as a local user Global Database name is used when we want to login as a remote login user ...
A materialized view is a replica of a target master from a singlepoint in time. The concept was first introduced with Oracle7 termed asSNAPSHOT. In Oracle release 7.1.6 snapshots were enhanced to enableDMLs
Latest Answer: Both are mirror copy of tables but in that main difference is in snapshot we cannot edit the data. in the case of materialized view we can edit the data. ...
ORACLE database is comprised of three types of files. One or more Data files, two are more Redo Log files, and one or more Control files.
Latest Answer: The components of a Physical Structure of a Database are as Follows:1.Control Files2.Redolog Files3.Data Files. ...
Rollback Segments are used :To generate read-consistent database information during database recovery to rollback uncommitted transactions for users.
Latest Answer: Rollback Segment Stores Undo Information and are used for the following purposes.1. To undo the previous command2. For read consistency and3. For crash recovery. ...
Temporary segments are created by ORACLE when a SQL statement needs a temporary work area to complete execution. When the statement finishes execution, the temporary segment extents are released to the
Latest Answer: temporary segments are basically used for sort operations in oracle,,when the user tries to execute the query through order by clause. so system needs an space for an sort operation, and system will use temporary segments for this query. ...
Every ORACLE database has one or more physical data files. A database's data files contain all the database data. The data of logical database structures such as tables and indexes is physically stored
Latest Answer: the data of logical database, say tables,indeses etc are stored in datafile.they can be associated with only one database. once created their size can not be altered. but we can add new data file to the table space. ...
The set of Redo Log files for a database is collectively known as the database's redo log.
Latest Answer: Oracle maintains logs of all transactions against the databse. These transactions are recorded in files called Online Redo log files.These logs are used to recover the database's transaction in their proper order in the evnt of database crash. The ...
View page << Previous 1 [2] 3 4 5 6 7 8 Next >>
Go Top
