-
Relationship Between Database and Data Warehouse
What is the relationship between a company's databases and its data warehouse?
Hirru
- Feb 10th, 2012
Database is a structured collection of relational data. Database is used to store the relational, network or hierarchical data. It contains some sort of data and it is being used by the organization...
Lokesh M
- Nov 20th, 2011
In simple words, a database is used to store information, and a data warehouse is used to query and analyse the stored data in several ways. Data warehouse helps business management to take important...
-
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...
-
What is codd's rule?
nishant s mevawala
- Aug 30th, 2011
1.Information Rule
2.Guaranteed Access Rule
3.Systematic Treatment of Nulls Rule
4.Active On-line catalog based on the relational model
5.Comprehensive Data Sub-language Rulerajakumar_na
- Nov 14th, 2007
Dr. E.F. Codd, an IBM researcher, first developed the relational data model in 1970. In 1985, Dr. Codd published a list of 12 rules that concisely define an ideal relational database, which have provi...
-
What is the difference bwtween view and join
NOTNULL
- May 18th, 2009
View is mainly created to provide security for the data and data definitions. Mainly used to retrieve the data in a secure manner.View cannot use space in the physical memory means virtually it w...
-
Is it possible to have primary key and foreign key in one table if yes so what is the use of foreign key?
rubin2008
- Jan 31st, 2010
Yes it is possible to have primary key and foreign key in one table.For e.g the schema for table category is as followsCategory_id: int primary keyCategory_title: varchar(30)parent_id: int(3)In the ab...
Shri
- Nov 1st, 2007
Dear Vivek,If I understand your question well, you mean to say that "is there any possibility to have both?primary & foreign keys in the same table".Well, the answer is No. The foreign key (by defini...
-
Hi all...Can you please tell me how to delete the duplicate records in a table.
shibraj
- Jan 23rd, 2008
find the rowid for the duplicate row and delete the max id no keeping the min id. thats it...
sowmya
- Nov 19th, 2007
Here != works bcoz the inner query returns only a single value. NOT IN is used when multiples values are returned by the inner query
-
How to delete multiple tables at a time? e.g like c* means all the tables starts with c have to be deleted at a time.
anand.managoli
- Nov 26th, 2010
As per my knowledge we cannot use Regular Expressions with drop stmt. You can delete multiple tables in a single statement by separating them with a comma.Ex:mysql> show tables;+--------------...
dinu_26
- Nov 12th, 2008
There is no way to delete multiple table at a time.You can just drop a single table at a time.Syntax: table name.
-
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...
-
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.
-
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?
-
What parameters define RDBMS?
sangam.princesalim
- Apr 8th, 2010
There are a set of rules known as Codd's rules. In all there are 13 rules. 12 were defined by Codd & the 0th rule is interpreted by Subject experts. Altough there is no Database which is fully compliant with the Codd's rules and hence we do not have a perfect / accurate RDBMS as of now.
-
If we have a table which is accessed by multiple users and two or more user's are simultaniously trying to modify the table. Then what happens and how can we manage such situations?
dj_dj_dj
- Mar 18th, 2010
Simultaneously modification of same table by two or more users cause Oracle server to go into hang state, to avoid such a state first user who used dml statement should issue commit or rollback comand...
Gajanan
- Jul 13th, 2007
There are two ways of changing the rows in particular table.One to delete the rowSecond to modify/Change the data of row in table.In every case we opt for exclusive locks So when one user has exclusiv...
-
Database Design
You have been asked to design the following database diagram:“We would like to store a list of user’s in the database with their corresponding network of friends, groups, as well as any messages which are swapped between them. A user consists of a username, password, first name, last name and profile picture. A message is a string. User’s can have many friends but usually start off with none or...
-
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...
-
Data Validation Life Cycle
Explain the lifecycle regarding validating data from start to finish?
-
ILRM
IRLM is a module of DB2 which doesA. LoggingB. Thread creationsC. Concurrency controlD. Both logging and thread creation.
-
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...
-
What is Sub-schema?
Madhu Kalla
- Feb 10th, 2009
The subschema is the logical view of the data as it appears to the applications program
Dheeraj
- Aug 29th, 2006
In database management, an individual user's partial view of the database. The schema is the entire database.
-
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...
Database Interview Questions
Sub Category
Questions
Answers
Last Updated
Ans