-
What is Table ?
A table is the basic unit of data storage in an ORACLE database. The tables of a database hold all of the user accessible data. Table data is stored in rows and columns.
-
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.)
-
What are synonyms used for ?
Synonyms are used to : Mask the real name and owner of an object.Provide public access to an objectProvide location transparency for tables, views or program units of a remote database.Simplify the SQL statements for database users.
-
-
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.
-
Regarding query and a view in oracle
Hi,
If a user executes a query which is already being used by a view exactly will oracle use already existing view to retrieve data or use the query executed by user?
Regards,
Shashi -
What is Private Database Link ?
Private database link is created on behalf of a specific user. A private database link can be used only when the owner of the link specifies a global object name in a SQL statement or in the definition of the owner's views or procedures.
-
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.
-
What is schema?
A schema is collection of database objects of a User.
-
Error Process Dumps
Where does the process dumps information about the error?
-
Archive Log File
What is the use of archive log file? How will you apply archive log file? How does archive log file helps to make backup consistent?
-
-
Physical architecture of oracle
How we can determine the physical architecture of oracle?
-
SMON Process Instance Failure
How does the SMON process performs recovery after instance failure?
-
-
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 is Database Link ?
A database link is a named object that describes a "path" from one database to another.
-
-
What is difference between DNS & GNS ?
What are the advantages & disadvantages of both two.
Oracle Architecture Interview Questions
Ans