SQL Interview Questions
1) What is RDBMS?
2) What are the Properties of the Relational Tables?
3) What is Normalization?
4) What is De-normalization?
5) How is ACID property related to Database?
6) What are the Different Normalization Forms?
7) What is a Stored Procedure?
8) What is a Trigger?
9) What are the Different Types of Triggers?
10) What is a View?
11) What is an Index?
12) What is a Linked Server?
13) What is a Cursor?
14) What is Collation?
15) What is the Difference between a Function and a Stored Procedure?
16) What is subquery? Explain the Properties of a Subquery?
17) What are Different Types of Join?
18) What are Primary Keys and Foreign Keys?
19) What is User-defined Functions? What are the types of User-defined Functions that can be created?
20) What is an Identity?
21) What is DataWarehousing?
22) What languages BI uses to achieve the goal?
23) What is Standby Servers? Explain Types of Standby Servers.
24) What is Dirty Read?
25) Why can’t I use Outer Join in an Indexed View?
26) What is the Correct Order of the Logical Query Processing Phases?
27) Which TCP/IP port does the SQL Server run on? How can it be Changed?
28) What are the Difference between Clustered and a Non-clustered Index?
29) What are the Different Index Configurations a Table can have?
30) What are Different Types of Collation Sensitivity?
31) What is OLTP (Online Transaction Processing)?
32) What’s the Difference between a Primary Key and a Unique Key?
33) What is Difference between DELETE and TRUNCATE Commands?
34) What are Different Types of Locks?
35) What are Pessimistic Lock and Optimistic Lock?
36) When is the use of UPDATE_STATISTICS command?
37) What is the Difference between a HAVING clause and a WHERE clause?
38) What is Connection Pooling and why it is Used?
39) What are the Properties and Different Types of Sub-Queries?
40) What are the Authentication Modes in SQL Server? How can it be Changed?
41) Which Command using Query Analyzer will give you the Version of SQL Server and Operating System?
42) What is an SQL Server Agent?
43) Can a Stored Procedure call itself or a Recursive Stored Procedure? How many levels of SP nesting is possible?
44) What is Log Shipping?
45) Name 3 ways to get an Accurate Count of the Number of Records in a Table?
46) What does it mean to have QUOTED_IDENTIFIER ON? What are the Implications of having it OFF?
47) What is the Difference between a Local and a Global Temporary Table?
48) What is the STUFF Function and How Does it Differ from the REPLACE Function?
49) What is PRIMARY KEY?
50) What is UNIQUE KEY Constraint?
51) What is FOREIGN KEY?
52) What is CHECK Constraint?
53) What is NOT NULL Constraint?
54) What is the difference between UNION and UNION ALL?
55) What is B-Tree?
56) How to get @@ERROR and @@ROWCOUNT at the Same Time?
57) What is a Scheduled Job or What is a Scheduled Task?
58) What are the Advantages of Using Stored Procedures?
59) What is a Table Called, if it has neither Cluster nor Non-cluster Index? What is it Used for?
60) Can SQL Servers Linked to other Servers like Oracle?
61) What is BCP? When is it Used?
62) What Command do we Use to Rename a db, a Table and a Column?
63) What are sp_configure Commands and SET Commands?
64) How to Implement One-to-One, One-to-Many and Many-to-Many Relationships while Designing Tables?
65) What is Difference between Commit and Rollback when Used in Transactions?
66) What is an Execution Plan? When would you Use it? How would you View the Execution Plan?
67) What is Difference between Table Aliases and Column Aliases? Do they Affect Performance?
68) What is the difference between CHAR and VARCHAR Datatypes?
69) What is the Difference between VARCHAR and VARCHAR(MAX) Datatypes?
70) What is the Difference between VARCHAR and NVARCHAR datatypes?
71) Which are the Important Points to Note when Multilanguage Data is Stored in a Table?
72) How to Optimize Stored Procedure Optimization?
73) What is SQL Injection? How to Protect Against SQL Injection Attack?
74) How to Find Out the List Schema Name and Table Name for the Database?
75) What is CHECKPOINT Process in the SQL Server?
76) How does Using a Separate Hard Drive for Several Database Objects Improves Performance Right Away?
77) How to Find the List of Fixed Hard Drive and Free Space on Server?
78) Why can there be only one Clustered Index and not more than one?
79) What is Difference between Line Feed (\n) and Carriage Return (\r)?
80) Is It Possible to have Clustered Index on Separate Drive From Original Table Location?
81) What is a Hint?
82) How to Delete Duplicate Rows?
83) Why the Trigger Fires Multiple Times in Single Login?
84) What is Aggregate Functions?
85) What is Use of @@ SPID in SQL Server?
86) What is the Difference between Index Seek vs. Index Scan?
87) What is the Maximum Size per Database for SQL Server Express?
88) How do We Know if Any Query is Retrieving a Large Amount of Data or very little data?
89) What is the Difference between GRANT and WITH GRANT while Giving Permissions to the User?
90) How to Create Primary Key with Specific Name while Creating a Table?
91) What is T-SQL Script to Take Database Offline – Take Database Online
92) How to Enable/Disable Indexes?
93) Can we Insert Data if Clustered Index is Disabled?
94) How to Recompile Stored Procedure at Run Time?
95) Is there any Performance Difference between IF EXISTS (Select null from table) and IF EXISTS (Select 1 from table)?
96) What is Difference in Performance between INSERT TOP (N) INTO Table and Using Top with INSERT?
97) Does the Order of Columns in UPDATE statements Matter?
98) What are the basic functions for master, msdb, model, tempdb and resource databases?
99) What is the Maximum Number of Index per Table?
No comments:
Post a Comment