Find jobs | Company-wise jobs
Jobseekers | Employer login
About us Sitemap of www.CareerRide.com Sitemap FAQ related with www.CareerRide.com FAQ Click here to Contact us Contact
       
Submit Resume Free ! | Access Resume Free !
Home Interview Q&A Tutorials .NET Java Soft skills CV GD Work from home IT practice test MBA practice test FAQs in PDF Books Jobs FAQs

Database Interview Questions


Database concepts Interview questions - Part 1

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

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

Explain the ETL process in Data warehousing.

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

What is Data mining?

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

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

Explain the types of indexes?

Clustered index
Non-clustered..................... 
Read answer

Define SQL.

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

What is RDBMS? Explain its features.

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

What is an Entity-Relationship diagram?

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

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

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

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
Check
Unique
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

Next>>

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....

 

 
Want to be hunted by potential employers? Just submit your key skills!

Popular FAQs

.NET .Net Architecture ADO.NET Java Oracle C#.NET
VB.NET DOT.NET AJAX ASP.NET NET Framework OOPS in .NET
C++ Sql Server Data warehousing EJB MySQL Linux
PHP UML Networking Testing XML  
 
Copyright © 2008 - 2010 CareerRide.com. All rights reserved.