Database concepts Interview questions - Part 1
Next>> Part
1 |
Part 2 |
Part 3 |
Part 4
Fact tables are central tables in data warehousing. They
contain the aggregate values that are used in business
process..............
Read answer
Extraction, Transformation and loading are different stages
in data warehousing................
Read answer
Data mining is a process of analyzing current data and
summarizing the information in more useful manner..................
Read 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...............
Read answer
Clustered index
Non-clustered.....................
Read
answer
SQL stands for Structured Query Language. It allows access,
insert/update/delete records and retrieve data from the
database...................
Read answer
RDBMS stands for Relational Database Management System. It
organizes data into related rows and columns...................
Read answer
It is a graphical representation of tables with the
relationship between them................
Read answer
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
A column or combination of columns that identify a row of
data in a table is Primary Key............
Read answer
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.
Next>>
Also read
Answer - A data warehouse can be considered as a storage area
where interest specific or relevant data........
Answer - OLTP: Online Transaction and Processing helps and
manages applications based........
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]....................
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?..................
Answer - Truncate command is used to remove all rows of the
column.The removed records are not recorded in the transaction log......
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.....
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.........
Answer - It is the process of organizing data into related
table. To normalize database, we divide database into tables.....
Answer - SQL Server Provides three types of Transact-SQL
statements namely DDL, DCL, and DML....
|
