DataBase Administrator (DBA) Interview Questions and Answers
(Continued from previous part...)
166. What column differentiates the V$ views to the GV$ views and how?
The INST_ID column which indicates the instance in a RAC environment the information came from.
167. What command would you use to create a backup control file?
Alter database backup control file to trace.
168. Give two examples of referential integrity constraints.
A primary key and a foreign key.
169. What is schema?
A schema is collection of database objects of a User.
170. 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 data.
171. What is Hash Cluster?
A row is stored in a hash cluster based on the result of applying a hash function to the row’s cluster key value. All rows with the same hash key value are stores together on disk.
172. What is a Private Synonyms?
A Private Synonyms can be accessed only by the owner.
173. What is Database Link?
A database link is a named object that describes a “path” from one database to another.
174. What is a Tablespace?
A database is divided into Logical Storage Unit called tablespaces. A tablespace is used to grouped related logical structures together
(Continued on next part...)