Database Interview Questions
10 Apr, 2007
- What is clusters? - Group of tables physically stored together because they share common columns and are often used together is called Cluster.
- What is an Index? - How it is implemented in Oracle Database? - An index is a database structure used by the server to have direct access of a row in a table. An index is automatically created when a unique of primary key constraint clause is specified in create table command (Ver 7.0)
10 Apr, 2007
- What is Privilege Auditing? - Privilege auditing is the auditing of the use of powerful system privileges without regard to specifically named objects.
- What is Object Auditing? - Object auditing is the auditing of accesses to specific schema objects without regard to user.
- What is Auditing? - Monitoring of user access to aid in the investigation of database use.
- What are the responsibilities of a Database Administrator?
- Installing and upgrading the Oracle Server and application tools.
- Allocating system storage and planning future storage requirements for the database system.
- Managing primary database structures (tablespaces)
10 Apr, 2007
- What are the dictionary tables used to monitor a database spaces? - DBA_FREE_SPACE DBA_SEGMENTS DBA_DATA_FILES.
- What are the roles and user accounts created automatically with the database? - DBA - role Contains all database system privileges. SYS user account - The DBA role will be assigned to this account. All of the base tables and views for the database’s dictionary are store in this schema and are manipulated only by ORACLE. SYSTEM user account - It has all the system privileges for the database and additional tables and views that display administrative information and internal tables and views used by oracle tools are created using this username.
10 Apr, 2007
- What are the various type of snapshots? - Simple and Complex.
- Describe two phases of Two-phase commit? - Prepare phase - The global coordinator (initiating node) ask a participants to prepare (to promise to commit or rollback the transaction, even if there is a failure) Commit - Phase - If all participants respond to the coordinator that they are prepared, the coordinator asks all nodes to commit the transaction, if all participants cannot prepare, the coordinator asks all nodes to roll back the transaction.
10 Apr, 2007
- Is the After report trigger fired if the report execution fails? - Yes.
- Does a Before form trigger fire when the parameter form is suppressed? - Yes.
- Is it possible to split the print reviewer into more than one region? - Yes
- Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size? - Yes
- For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame? - Yes
