| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How do you load large data to the SQL server database? | | 2 |
| 1.what is the purpose of using alias name in sql server?
with certain example?
2.what is cursor?will u plz explain me in detail with
certain example? | | 1 |
| What is a trigger? | | 6 |
| What is a job? | | 3 |
| What is a Linked Server? | | 1 |
| How to Debug a Stored Procedure? | Allianz | 3 |
| What are the different types of backup avaible in SQL SErver | Emphasis | 3 |
| how to get 25th row in any table in sqlserver can u tell me
syntax | | 4 |
| How do you find the error, how can you know the number of
rows effected by last SQL statement? | | 1 |
| Can we use Truncate command on a table which is referenced
by FOREIGN KEY? | | 1 |
| How to delete duplicate records from a table?(for suppose in
a table we have 1000 Records in that we have 200 duplicate
Records , so ,how to findout that duplicate Records , how to
delete those Records and arranged into sequence order? one
more thing that there is no primary key at all) | McAfee | 3 |
| what is meant by sql injection with example and one more
question how to catch the errors in sqlserver | | 1 |
| Explain the architecture of SQL Server? | | 2 |
| 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. | | 2 |
| Which system tables contain information on privileges
granted and privileges obtained | | 1 |
| how to know description of a table in sqlserver 2000
| | 6 |
| Difference between Triggers and Stored Procedure | Protech | 7 |
| What should we do to copy the tables, schema and views from
one SQL Server to another? | | 3 |
| Suppose in a situation if two list boxes are there and if
you select multiple options based on that the options
related to those selected items should display in second
list box.
Again if we select multiple items in second listbox then the
related to those selected items should display .
In this scenario how will you design database,tables? | HP | 1 |
| What is the advantage of specifying WITH GRANT OPTION in
the GRANT command? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map