Database interview questions and answers


Database interview questions and answers

Part 1 | Part 2 | Part 3 | Part 4   Next>> 

1.Define Fact tables and dimension tables.

Fact tables are central tables in data warehousing. They contain the aggregate values that are used in business process.............. 
Read answer

Test your Database skills!

Database (20 questions)
Sql server part 1 (40 questions)
Oracle part 1 (40 questions)
Oracle DBA (30 questions)

RDBMS interview questions

2.Explain the ETL process in Data warehousing.

Extraction, Transformation and loading are different stages in data warehousing................
Read answer

3.What is Data mining?

Data mining is a process of analyzing current data and summarizing the information in more useful manner..................
Read answer

4.What are indexes?

Index can be thought as index of the book that is used for fast retrieval of information. 
Index uses one or more column index keys and pointers to the record to locate record............... 
Read answer

5.Explain the types of indexes?

Clustered index
Read answer

6.Define SQL.

SQL stands for Structured Query Language. It allows access, insert/update/delete records and retrieve data from the database...................
Read answer

7.What is RDBMS? Explain its features.

RDBMS stands for Relational Database Management System. It organizes data into related rows and columns...................
Read answer

8.What is an Entity-Relationship diagram?

It is a graphical representation of tables with the relationship between them................
Read answer

9.Define referential integrity.

It is the rules that are applied when the relationships are created. It ensures integrity of data and prevents inconsitent data into the tables...............
Read answer

10.Define Primary key and Foreign key.

A column or combination of columns that identify a row of data in a table is Primary Key............
Read answer

11.Define alternate key.

There can be a key apart from primary key in a table that can also be a key. This key may or may not be a unique key..............
Read answer

Database interview questions- April 06, 2009, 17:40 pm by Nishant Kumar

Delete vs. Truncate table.

Delete logs the deletion of each row whereas Truncate doesn't log deleted rows in the transaction log. This makes truncate command is bit faster than Delete command.

Define constraints.

Constraints enforce integrity of the database. Constraints can be of following types

Not Null
Primary key
Foreign key

Database interview questions- April 12, 2009, 14:50 pm by Nishant Kumar

Define stored procedure.

Stored procedure is a set of pre-compiled SQL statements, executed when it is called in the program.

Define Trigger.

Triggers are similar to stored procedure except it is executed automatically when any operations are occurred on the table.

Part 1 | Part 2 | Part 3 | Part 4


Write your comment - Share Knowledge and Experience

Discussion Board
SQL levels

I am watching your website. It's nice. I want some details. I think I saw in your website, about SQL Levels. ie. Beginner level, Intermediate level, Advanced level of learning. or so. I did not remember correctly. If I am correct, please inform me about these details. I want to learn basics very well. Please reply me.I am not knowing where to start and how to start SQL. That's why I am asking you. Please help me

madhu 06-7-2013 07:57 AM

Database interview

Thanks for all these questions on database. Please upload more questions.

dighe 03-11-2013 01:40 AM


the quation hav't answer

haylay 02-13-2013 02:31 AM


very good

javed 03-13-2012 10:41 AM


Also read

What is Data warehousing?

Answer - A data warehouse can be considered as a storage area where interest specific or relevant data........

What is an OLTP system and OLAP system?

Answer - OLTP: Online Transaction and Processing helps and manages applications based........

SQL Server 2005 Analysis Services Interview Questions

What is SQL Server 2005 Analysis Services (SSAS)?
What are the new features with SQL Server 2005 Analysis Services (SSAS)?
What are SQL Server Analysis Services cubes?
Explain the purpose of synchronization feature provided in Analysis Services 2005.
Explain the new features of SQL Server 2005 Analysis Services (SSAS). [Hint - Unified Dimensional Model, Data Source View, new aggregation functions and querying tools]....................

OLAP interview questions

Explain the concepts and capabilities of OLAP.
Explain the functionality of OLAP.
What are MOLAP and ROLAP?
Explain the role of bitmap indexes to solve aggregation problems.
Explain the encoding technique used in bitmaps indexes.
What is Binning?
What is candidate check?..................

Define Truncate and Delete commands.

Answer - Truncate command is used to remove all rows of the column.The removed records are not recorded in the transaction log......

Define Primary and Unique key.

Answer - The column or columns of the table whose value uniquely identifies each row in the table is called primary key. You can define column as primary key using primary key constraint while you create table.....

What is index? Define its types.

Answer - Index can be thought as index of the book that is used for fast retrieval of information. Index uses one or more column index keys and pointers to the record to locate record.........

Define Normalization and De- Normalization.

Answer - It is the process of organizing data into related table. To normalize database, we divide database into tables.....

What is transact-SQL? Describe its types?

Answer - SQL Server Provides three types of Transact-SQL statements namely DDL, DCL, and DML....


Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us