| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the system function to get the current user's user
id? | TCS | 3 |
| SQL stops working in every 15 days displaying message that
database log file is full. Log file size is 3.95 GB. It is
happening after shrinking the database also. What is
solution to overcome this problem. Please help me as it's
urgent. | | 5 |
| What is the differecne between equi-join and inner-join and
natural join..Is there any difference or all are same? | Microsoft | 2 |
| What all db objects can be found in MSDB database of a SQL
Server instance? | Accenture | 1 |
| how many types of store procedre in sqlserver 2000? | ATI | 2 |
| What is user stored procedure & it purpose? | Wipro | 3 |
| Which command using Query Analyzer will give you the version
of SQL server and operating system? | | 3 |
| How to write stored procedure to update the data in 10
tables | | 4 |
| how insert selected column only ? | Robert-Half | 2 |
| I have a huge amount of data which is displayed in a
report. The data is viewed every day. Every day the data is
displayed in 30 secs but suddenly today it is giving an
timeout message today. Data has not been changed. The
situation is same as yesterday. What might be the reason???
Please Answer. | Satyam | 4 |
| Can you explain the role of each service? | | 1 |
| What are mdf,ndf,ldf files and how to see the data in those
files? | Accenture | 5 |
| What is excution Plan in sql server | TCS | 1 |
| WHAT IS DIFFRENCE BETWEEN TRUNCATE AND DELETE STATEMENT | CTS | 10 |
| What is the basic difference between clustered and a
non-clustered index? | | 3 |
| How to Generate a Series of Random Integers With T-SQL? | | 1 |
| How to Debug a Stored Procedure? | Allianz | 4 |
| Can store procedure call by user define function in SQL
server? | HCL | 6 |
| What are explicit and implicit transactions? | | 2 |
| Can a stored procedure call another stored procedure. If yes
what level and can it be controlled? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |