-
What are the uses of Rollback Segment ?
Rollback Segments are used :To generate read-consistent database information during database recovery to rollback uncommitted transactions for users.
-
What is a Redo Log ?
The set of Redo Log files for a database is collectively known as the database's redo log.
-
What does a Control file Contain ?
A Control file records the physical structure of the database. It contains the following information.Database NameNames and locations of a database's files and redolog files.Time stamp of database creation.
-
-
What is a Data Dictionary ?
The data dictionary of an ORACLE database is a set of tables and views that are used as a read-only reference about the database.It stores information about both the logical and physical structure of the database, the valid users of an ORACLE database, integrity constraints defined for tables in the database and space allocated for a schema object and how much of it is being used.
-
What is Data Block ?
ORACLE database's data is stored in data blocks. One data block corresponds to a specific number of bytes of physical database space on disk.
-
Error Process Dumps
Where does the process dumps information about the error?
-
-
What is difference between DNS & GNS ?
What are the advantages & disadvantages of both two.
-
What is the use of Redo Log Information ?
The Information in a redo log file is used only to recover the database from a system or media failure prevents database data from being written to a database's data files.
-
Describe Referential Integrity ?
A rule defined on a column (or set of columns) in one table that allows the insert or update of a row only if the value for the column or set of columns (the dependent value) matches a value in a column of a related table (the referenced value). It also specifies the type of data manipulation allowed on referenced data and the action to be performed on dependent data as a result of any action on referenced...
-
Explain the relationship among Database, Tablespace and Data file.
Each databases logically divided into one or more tablespaces one or more data files are explicitly created for each tablespace.
-
What is schema?
A schema is collection of database objects of a User.
-
What is a Data Segment ?
Each Non-clustered table has a data segment. All of the table's data is stored in the extents of its data segment. Each cluster has a data segment. The data of every table in the cluster is stored in the cluster's data segment.
-
What is the difference between SID and Global Database Name ?
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 less; at least on Oracle 9i. The system identifier is included in the CONNECT_DATA parts of the connect descriptors in a tnsnames.ora file. The SID defaults to the database name. Global Database Name...
-
-
-
Identify Database Size
How will you identify database size when you create a database first time?
-
What is Database Link ?
A database link is a named object that describes a "path" from one database to another.
-
Oracle Architecture Interview Questions
Ans