Category Archives: Database Architecture Interview Questions

What are the factors causing the reparsing of SQL statements in SGA? | Memory Management Questions

Posted on October 13, 2014 by skills9

Due to insufficient Shared SQL pool size. Monitor the ratio of the reloads takes place while executing SQL statements. If the ratio is greater than 1 then increase the SHARED_POOL_SIZE. LOGICAL & PHYSICAL ARCHITECTURE OF DATABASE.

Posted in Database Architecture Interview Questions | Leave a comment

What is an Oracle Data Segment? | Database Architecture Questions

Posted on October 13, 2014 by skills9

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 … Continue reading →

Posted in Database Architecture Interview Questions | Leave a comment

What is an oracle database schema? | Database Architecture Questions

Posted on October 13, 2014 by skills9

A schema is collection of database objects of a User. A schema is collection of database objects of an user and is used synonym of an user. Schema name = user name    

Posted in Database Architecture Interview Questions | Leave a comment

Can a Tablespace hold objects from different Schemes in Oracle? | Database Architecture Questions

Posted on October 13, 2014 by skills9

Yes a Tablespace can hold objects from different Schemes in Oracle

Posted in Database Architecture Interview Questions | Leave a comment

What is an Integrity Constrains in Oracle? | Database Architecture Questions

Posted on October 13, 2014 by skills9

An integrity constraint is a declarative way to define a business rule for a column of a table.

Posted in Database Architecture Interview Questions | Leave a comment

How to define Data Block size in Oracle? | Database Architecture Questions

Posted on October 13, 2014 by skills9

A data block size is specified for each ORACLE database when the database is created. A database users and allocated free database space in ORACLE datablocks. Block size is specified in INIT.ORA file and can?t be changed latter. A data … Continue reading →

Posted in Database Architecture Interview Questions | Leave a comment

Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint? | Database Architecture Questions

Posted on October 13, 2014 by skills9

Yes we can enforce integrity constraint on a table if some existing table does not satisfy the constraint by using “ENABLE NOVALIDATE”

Posted in Database Architecture Interview Questions | Leave a comment

What is an Oracle SYSTEM tablespace and when is it Created? | Database Architecture Questions

Posted on October 13, 2014 by skills9

Every ORACLE database contains a tablespace named SYSTEM, which is automatically created when the database is created. The SYSTEM tablespace always contains the data dictionary tables for the entire database. The SYSTEM tablespace is created automatically for each new Oracle … Continue reading →

Posted in Database Architecture Interview Questions | Leave a comment

What is an Oracle Data Dictionary? | Database Architecture Questions

Posted on October 13, 2014 by skills9

The data dictionary of an ORACLE database is a set of tables and views that are used as a read-only reference about the database. It stores information about both the logical and physical structure of the database, the valid users … Continue reading →

Posted in Database Architecture Interview Questions | Leave a comment

Describe the different type of Integrity Constraints supported by ORACLE? | Database Architecture Questions

Posted on October 13, 2014 by skills9

NOT NULL Constraint – Disallows Nulls in a table’s column. UNIQUE Constraint – Disallows duplicate values in a column or set of columns. PRIMARY KEY Constraint – Disallows duplicate values and Nulls in a column or set of columns. FOREIGN … Continue reading →

Posted in Database Architecture Interview Questions | Leave a comment