-
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.
-
-
Log Sequence Number and Checkpoint ID
What is the difference between log sequence number and checkpoint id? How it is used for instance recovery?
-
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...
-
-
-
Redo-log Buffer
When does the LGWR writes all redo-enteries to the redo-log buffer?
-
Identify Database Size
How will you identify database size when you create a database first time?
-
What are the components of Logical database structure of ORACLE database?
Tablespaces and the Database's Schema Objects.
-
DBWn Processes
Which parameter specifies the number of DBWn processes?
-
What are the components of Physical database structure of Oracle Database?.
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.
-
-
High water mark
What is high watermark in oracle ?
-
What is cluster Key ?
The related columns of the tables in a cluster is called the Cluster Key.
Oracle Architecture Interview Questions
Ans