Oracle DBMS Interview Questions and Answers - 1
Question: 1
Define relationships?
A relationship is an association between entities (or tables). It is based on having common data values in the designated columns of each table.
A relationship is defined by linking the common columns in the two tables,
Relationships are actual objects in the database.
Following are the three types of relationships:
One to one : Implies that a single records from the first table can be linked to multiple records in the second table and vice versa.
One to many: Implies that a single record form the first table can be linked to multiple records in the second table while a single record in the second table relates to only a single record in the first table.
Many to many: Implies that multiple records from the first table can be linked to multiple records in the second table and vice versa.
Question: 2
What is a primary key?
A primary key is an attribute (or a collection of attributes) that uniquely identifies each row in the table.
In other words, each entity instance in a table must be unique; and therefore, primary key is a way of ensuring this.
Question: 3
What is a foreign key?
A foreign key is an attribute in a child table that matches the primary key value in the parent table.
Question: 4
What is de-normalization?
OLTP databases are intended more for DML operations; therefore these databases are designed to reduce redundancy; whereas, Online Analytical Processing (OLAP) database or warehousing applications are primarily used for reporting.
OLAP databases are not used for day–to-day transactions in general and reporting performance is more critical for such database; therefore, these databases are designed to store data to support easy access without requiring too many joins.
Redundancy of data is not of much concern in these databases; therefore, tables are designed as a join of two or more tables from a typical OLTP application. This is called de-normalization.
Question: 5
What is full functional dependency?
Full functional dependency is the situation when an attribute depends on a group of attributes completely but not on the subset of the attributes.
7000+ Subject Verb Agreement Exercises for Class 6, 7, 8, 9, 10 More
7000+ Tenses MCQ Questions for Class 6, 7, 8, 9, 10 More
7000+ Tenses English Grammar Exercises with Answers Pdf More
7000+ Simple Compound Words Quiz with Answers More
7000+ Compound Words Worksheet with Answers for Grade 10 More
1000+ Fluid Mechanics Questions and Answers Pdf More
100+ Logical Reasoning Questions for TNPSC Exams More
C++ Inheritance MCQs in Java Questions & Answers More
Top 100+ Logarithm Aptitude Questions and Answers More
Hyperion Drm Interview Questions and Answers More