-
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 ...
-
Remove one duplicate column value from multiple
How to remove only one column values from the duplication of values in that column without using any other column references in that table?
-
MultiSet table with UPI
Multiset table with UPI will allow duplicates or not?
Read Best Answer
Editorial / Best Answer
daniel.doboseru- Member Since Feb-2013 | Feb 6th, 2013
UPI stands for Unique Primary Key, which constrain us to have unique keys, thus unique rows. Now even if the Multiset table allows duplicate rows by definition, the UPI constraint overrules it. Answer: No.
daniel.doboseru
- Feb 6th, 2013
UPI stands for Unique Primary Key, which constrain us to have unique keys, thus unique rows. Now even if the Multiset table allows duplicate rows by definition, the UPI constraint overrules it.
Answer: No. -
SQL Query
How to display nth lowest record in a table for example? How to display 4th lowest (salary) record from customer table?
Read Best Answer
Editorial / Best Answer
Answered by: Yadnesh
- Jun 1st, 2013
-- First of all Customers table wont have salary attribute. we need to use employees/employeesSalary table -- where we can find salary attribute. -- for finding nth lowest salary record we can obtain derived column using DENSE_RANK() in a subquery and -- obtain temporary result set and finding nth record in a temporary result set using WHERE clause -- for the given example, following is the solution.
CodeYadnesh
- Jun 1st, 2013
-- First of all Customers table wont have salary attribute. we need to use employees/employeesSalary table -- where we can find salary attribute. -- for finding nth lowest salary record we can obtai...
-
Diplay Records using ROWNUM, MINUS & UNION
Display 6th & 9th records only from the table using ROWNUM & MINUS & UNION ?
-
RowSet Vs ResultSet
Why is RowSet implementation is beneficial over ResultSet?
Database Interview Questions
Sub Category
Questions
Answers
Last Updated
Read Best Answer
Ans