-
-
-
Integrity Rules
List the rules used to enforce table level integrity.
Sandhya.Kishan
- Apr 5th, 2012
There are 3 rules to enforce table level integrity. 1.Foreign key value can be modified only if we want to match the corresponding primary key value. 2.We cannot delete records either from parent or c...
-
Type of Participation
What is meant by type of participation? Name the three types of relationship participation.
chaitra murthy
- Jan 16th, 2009
I just know two types of Participation: Total and Partial.Lets take an example of 2 entities Department and Employee. Relation: For each department there is an Head of the Department (who is an emplo...
-
Requirement Gathering
Name three activities involved in requirement gathering
Sandhya.Kishan
- Apr 5th, 2012
Three activities involved in requirement gathering are
1.Eliciting requirement
2.Analyzing requirement
3.Recording requirement -
One to many
Explain the representation of a one-to-many strong entity relationship in a relational database design.
chaitra murthy
- Jan 16th, 2009
Department-Employees Under one Department many employees are working.Project-Employees
-
Converting extended E-R model
Describe the process of converting an extended E-R model into a relational database design.
chaitra murthy
- Jan 16th, 2009
ER Model->Logical schema->Normalization->Creating database with tables.
-
Data Redundancy
Explain what are controlled and uncontrolled data redundancy?
dhs01
- Apr 15th, 2009
I view this as planned and unplanned. Generally planned redundancy for performance reasons has some steps taken to ensure that there is syncronicity between the data. I am not sure if there are formal...
-
Size of Oracle package
“Bigger the size of a Oracle package, the better”. Do you agree? Justify.
dhiren21
- Sep 20th, 2009
No - I do not agreeFunctionality depends..What are you trying to do in a package depends a lot...A Package can call Views, Functions and Triggers, Update, Insert, Delete.. Purpose of a Package, For...
-
Error Trapping Functions
Functions for error trapping are contained in which section of a PL/SQL block?
Sandhya.Kishan
- Apr 5th, 2012
The Exception section of the PL/SQL block contains the functions for error handling.
-
DDL Operation Trigger
Which types of trigger can be fired on DDL operation?
A. Instead of triggerB. DML triggerC. System triggerD. DDL trigger -
Data Models
Explain the three data models and examine a range of issues that are intergral to database environment such as the end user and different platforms compatibility?
-
Defragmentation and Re-organization
What is the difference between defragmentation (coalescing) and re-organization (rebuilding, moving)?
Mwanamume
- Jun 21st, 2010
Defragmentation is to make data take a small space in storing (to compress data) while re-og=rganization is to rebuild or rearrange the data
-
RDBMS Relation
What is the relation between the store and the customers when they shop the products at that store?
vasirev
- Jun 15th, 2010
The store table and the customer table would not have any direct relation. Instead, both of them would be pointing to a transaction table which would contain the store id and the customer id.
-
Indexes Searching Capabilities
How do indexes increase the searching capabilities?
Sandhya.Kishan
- Jul 25th, 2012
By using the concept of serial scanning the indexes can increase the searching capabilities.
-
Table Indexes
What is the disadvantage of creating large number of indexes on a table?
trupti11
- Nov 15th, 2010
There are a couple of reasons that I can think of for this:(1) The indexes that are created on a table occupy physical disc space, the more the number of indexes created, the more would be the s...
-
Difference between Data abstraction, schema and instance
Difference between the three levels of data abstraction, and between a schema and instances.. Consider a two dimensional integer array of size n*m that is to be used in your favorite programming language. Using the array as an example, illustrate the difference (a) between the three levels of data abstraction, and (b) between a schema and instances.
Lokesh M
- Nov 20th, 2011
Data Abstraction means suppression of information / details of data organization and storage. Data Abstraction gives importance to mainly essential aspects in order to help better understanding of th...
-
Organization problems
Consider an organization by which you are familiar. If the organization is using file processing system then what are the problems organization will face?Explain with suitable examples.
-
-
What is meant by Ontology?
Read Best Answer
Editorial / Best Answer
daniel.doboseru- Member Since Feb-2013 | Feb 6th, 2013
An ontology refers to a model that contains a set of classes (individuals) plus a set of relations between them. Lets consider a relational database model, having three tables: Human, Man, Woman. As you can observe, there is no relation defined between them. Well, in an ontology, besides that, you might also have a set of rules like: - Object X is Man, if and only if is Human, but is not Woman. - If object X is Human, then it is either Man or Woman, but not both. For defining ontologies there are several languages developed, the most representative being OWL (Web Ontology Language. And for querying them one must also use a specialized language (eg. SPARQL).
daniel.doboseru
- Feb 6th, 2013
An ontology refers to a model that contains a set of classes (individuals) plus a set of relations between them. Lets consider a relational database model, having three tables: Human, Man, Woman. As ...
Database Interview Questions
Sub Category
Questions
Answers
Last Updated
Read Best Answer
Ans