-
-
Redo-log Buffer
When does the LGWR writes all redo-enteries to the redo-log buffer?
-
-
What are the Characteristics of Data Files ?
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.
-
-
-
What are the components of Logical database structure of ORACLE database?
Tablespaces and the Database's Schema Objects.
-
SMON Process Instance Failure
How does the SMON process performs recovery after instance failure?
-
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.
-
What is a View ?
A view is a virtual table. Every view has a Query attached to it. (The Query is a SELECT statement that identifies the columns and rows of the table(s) the view uses.)
-
Physical architecture of oracle
How we can determine the physical architecture of oracle?
-
High water mark
What is high watermark in oracle ?
-
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 Database Link ?
A database link is a named object that describes a "path" from one database to another.
-
-
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.
-
-
-
Identify Database Size
How will you identify database size when you create a database first time?
Oracle Architecture Interview Questions
Ans