Database Interview Questions and Answers Differentiate between SQL and PL/SQL? 1. SQL is simpleified statement for Selecting and Manipulating the data. Whereas PL/SQL is a Procedu.... Category: Database Date: 10/1/2010 12:24:08 PM What is ACID property? ACID is the acronym for Atomicity,Consistency,Isolation and Durability. Whenever a transaction is ex.... Category: Database Date: 10/1/2010 11:46:07 AM How are one-to- one,one to many and many to many relationships implemented while designing the table.... 1. One to one relationship:- This is the relationship which is used very rarely and is implemented o.... Category: Database Date: 10/1/2010 11:39:07 AM What is meant by RDBMS? RDBMS means Relational Database Management System.This system manages the data records and indices i.... Category: Database Date: 10/1/2010 11:14:20 AM What is the difference between OLTP & OLAP? OLTP:- 1. It is based on entity relational model. 2. It inherits the concept of normalization so the.... Category: Database Date: 10/1/2010 11:14:07 AM What do you mean by OLTP? OLTP means Online Transaction Processing systems which deals with relational database design and use.... Category: Database Date: 10/1/2010 11:13:07 AM How are Primary Key and Foreign key inter-related? Primary Key is a column or combination of columns to have unique records in the table. There can onl.... Category: Database Date: 10/1/2010 11:07:06 AM What is the purpose of Triggers? Triggers are some set of business rules. It consist of some set of commands or statements like Store.... Category: Database Date: 10/1/2010 10:59:06 AM What is DKNF? DKNF is one of the Normalization forms. It is Domain-Key Normal Form(DKNF). According to this normal.... Category: Database Date: 10/1/2010 10:58:06 AM Why is De-normalisation Required? Fully normalized database can only be attained at logical level. Truly normalized databse can not be.... Category: Database Date: 10/1/2010 10:57:06 AM What do you mean by normalization? Basically normalization is a process in realational databse design to organise the data and avoid da.... Category: Database Date: 10/1/2010 10:56:06 AM I have 1-year gap between my 10th & 12th. So what should I answer regarding this? Category: Database Date: 12/6/2009 5:05:27 AM Explain Data Integrity? Data integrity means the correctness and consistency of data. Enforcing data integrity ensures the q.... Category: Database Date: 10/7/2009 4:43:37 AM How do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? One-to-One relationship can be implemented as a single table and rarely as two tables with primary a.... Category: Database Date: 10/7/2009 2:51:09 AM What is Database Denormalization? Database denormalization is the reverse process of database normalization. Denormalization is the pr.... Category: Database Date: 10/7/2009 2:29:21 AM 1 2

Recent Answers How do you declare destructor in c#? kumar answered: by implementing finalize and dispose method What will be the result of this code Console.WriteLine(3/4 == 3.0/4.0); kumar answered: answer is 'false'