|
|
|
Welcome to Sql Server Interview Quesitons and Answers section.
The Sql Server Interview Questions listed below have been collected
through various forums, websites, blogs and other resources. We have included
the references to the originators where we can but if you feel that you should
be credited for a given problem please contact us.
If you have a product or service that you would like to be included in the FAQ
section, please contact us at FAQs@megasolutions.net
|
|
|
| 1.1
What is RDBMS?
|
| 1.2
What is normalization?
|
| 1.3
What are different normalization forms?
|
| 1.4
What is Stored Procedure?
|
| 1.5
What is Trigger?
|
| 1.6
What is View?
|
1.7
What is Index?
|
| 1.8
What is the difference between clustered and a non-clustered index?
|
| 1.9
What are the different index configurations a table can have?
|
| 1.10
What is cursors?
|
| 1.11
What is the use of DBCC commands?
|
| 1.12
What is a Linked Server?
|
| 1.13
What is Collation?
|
| 1.14
What are different type of Collation Sensitivity?
|
| 1.15
What's the difference between a primary key and a unique key?
|
| 1.16
WHow to implement one-to-one, one-to-many and many-to-many relationships while
designing tables?
|
| 1.17
What is a NOLOCK?
|
| 1.18
What is difference between DELETE & TRUNCATE commands?
|
| 1.19
Difference between Function and Stored Procedure?
|
| 1.20
When is the use of UPDATE_STATISTICS command?
|
|
|
| 2.1
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
|
| 2.2
What is sub-query? Explain properties of sub-query.
|
| 2.3
What are types of sub-queries?
|
| 2.4
What is SQL Profiler?
|
| 2.5
What kind of User-Defined Functions can be created?
|
| 2.6
Scalar User-Defined Function
|
| 2.7
Inline Table-Value User-Defined Function
|
| 2.8
Multi-statement Table-Value User-Defined Function
|
| 2.9
Which TCP/IP port does SQL Server run on? How can it be changed?
|
| 2.10
What are the authentication modes in SQL Server? How can it be changed?
|
| 2.11
Where are SQL server users names and passwords are stored in sql server?
|
| 2.12
Which command using Query Analyzer will give you the version of SQL server and
operating system?
|
| 2.13
What is SQL server agent?
|
| 2.14
Can a stored procedure call itself or recursive stored procedure? How many
level SP nesting possible?
|
| 2.15
What is @@ERROR?
|
| 2.16
What is Raiseerror?
|
| 2.17
What is log shipping?
|
| 2.18
What is the difference between a local and a global variable?
|
|
|
| 3.1
What command do we use to rename a db?
|
| 3.2
What is sp_configure commands and set commands?
|
| 3.3
What are the different types of replication? Explain.
|
| 3.4
What are the OS services that the SQL Server installation adds?
|
| 3.5
What does it mean to have quoted_identifier on? What are the implications of
having it off?
|
| 3.6
What is the STUFF function and how does it differ from the REPLACE function?
example?
|
| 3.7
Using query analyzer, name 3 ways to get an accurate count of the number of
records in a table?
|
| 3.8
How to rebuild Master Database?
|
| 3.9
What is the basic functions for master, msdb, model, tempdb databases? files
contain?
|
| 3.10
What are primary keys and foreign keys?
|
| 3.11
What is data integrity? Explain constraints?
|
| 3.12
What are the properties of the Relational tables?
|
| 3.13
What is De-normalization?
|
| 3.14
How to get @@error and @@rowcount at the same time?
|
| 3.15
What is Identity?
|
| 3.16
What is a Scheduled Jobs or What is a Scheduled Tasks?
|
| 3.17
What is a table called, if it does not have neither Cluster nor Non-cluster
Index? What is it used for?
|
| 3.18
What is BCP? When does it used?
|
3.19
How do you load large data to the SQL server database?
|
| 3.20
Can we rewrite subqueries into simple select statements or with joins?
|
|
|
| 4.1
Can SQL Servers linked to other servers like Oracle?
|
| 4.2
How to know which index a table is using?
|
| 4.3
How to copy the tables, schema and views from one SQL server to another?
|
| 4.4
What is Self Join?
|
| 4.5
What is Cross Join?
|
| 4.6
Which virtual table does a trigger use? mysql_fetch_row()?
|
| 4.7
List few advantages of Stored Procedure.
|
|
|
| 5.1
What is Data Warehousing?
|
| 5.2
What are fundamental stages of Data Warehousing?
|
| 5.3
What is Dimensional Modeling?
|
| 5.4
What is Fact table?
|
| What
is Dimension table?
|
| 5.6
What are the Different methods of loading Dimension tables?
|
| 5.7
What is OLTP?
|
| 5.8
What is OLAP?
|
| 5.9
What is the difference between OLTP and OLAP?
|
| 5.10
Describes the foreign key columns in fact table and dimension table?
|
| 5.11
What is Data Mining?
|
| 5.12
What is the difference between view and materialized view?
|
| 5.13
What is ER Diagram?
|
| 5.14
What is ODS?
|
| 5.15
What is ETL?
|
| 5.16
What is VLDB?
|
| 5.17
Is OLTP database is design optimal for Data Warehouse?
|
| 5.18
If de-normalized is improves data warehouse processes, why fact table is in
normal form?
|
| 5.19
What are lookup tables?
|
| 5.20
What are Aggregate tables?
|
|
|
| 6.1
What is real time data-warehousing?
|
| 6.2
What are conformed dimensions?
|
| 6.3
What is conformed fact?
|
| 6.4
How do you load the time dimension?
|
| What
is a level of Granularity of a fact table?
|
| 6.6
What are non-additive facts?
|
| 6.7What
is factless facts table?
|
| 6.8
What are slowly changing dimensions (SCD)?
|
| 6.9
What is hybrid slowly changing dimension?
|
| 6.10
What is BUS Schema?
|
| 6.11
What is a Star Schema?
|
| 6.12
What Snow Flake Schema?
|
| 6.13
Differences between star and snowflake schema?
|
| 6.14
What is Difference between ER Modeling and Dimensional Modeling?
|
6.15
What is degenerate dimension table?
|
| 6.16
Why is Data Modeling Important?
|
| 6.17
What is surrogate key?
|
| 6.18
What is Data Mart?
|
| 6.19
What is the difference between OLAP and data warehouse?
|
| 6.20
What is a Cube and Linked Cube with reference to data warehouse?
|
|
|