| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is bit data type? and what are the information that can
be stored inside a bit column? | | 2 |
| is it possible to use a variable in a query with the IN
clause (a,b,c..z), without getting quotes or conversion
errors? | | 2 |
| What is the system function to get the current user's user
id? | TCS | 3 |
| can we call stored Procedure in Function in Sql Server 2000
and vice versa. | eSoft | 2 |
| How to find the date and time of last updated table? | | 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 difference between a Local temporary table and a
Global temporary table? How is each one used? | | 1 |
| what command is used to create a table by copying the
structure of another table? | | 5 |
| write down the sql query?
Table Name : emp1
empid empname
1 bala
2 guna
Table Name : emp2
empid empname
1 <Null>
2 <Null>
Solution : emp1 names are updated in emp2, write a query?
| | 7 |
| 1. What are the grouping function in SQL ?
2. If base table of a view deleted means, what will happen
while we querying on view ? will give any error ?
3. Difference between DROP, DELETE, TRUNCATE table ?
4. What is constraints and types ?
5. What is max size of nchar & nvarchar ?
6. Define ROLLBACK, COMMIT, SAVE POINT
7. How non-clustered better ? or rank the Clustered,
Non-Clustered and Table scan in performance wise
8. Select 10 rows from a table ?
9. Define DML, DDL, DCL, DTL commands ?
10. What is mean by NULL value ? NULL means "" or 0 or
undefined ?
11. Default constraints ?
12. Can we have more then primary Key in table ?
13. Type of integrity ? Entity, Referential, Domain ?
| Perot-Systems | 8 |
| Difference Between varchar and nvarchar datatype? | Satyam | 2 |
| Lets say due to N/W or Security issues client is not able to
connect to server or vice versa. How do you troubleshoot? | | 1 |
| how to find number of columns in a table in sql server 2000
and 2005 also | Virtusa | 10 |
| What are sub-queries? Give example? In which case
sub-queries are not feasible? | Infosys | 3 |
| how can i store resumes in database? | HCL | 2 |
| how to replace double quotes by single quotes in sql server | CAC | 2 |
| what is physical sort data and logical sort data in index? | | 2 |
| What is the use of placing primary key and foreign key
constrains on columns. | Value-Labs | 2 |
| Accidentally i deleted my table. How can i get that table? | | 4 |
| After using delete statement in sql query to delete some
records...to retrieve the deleted records we can get using
rollback command but till that where it stores means
particular location name i need....(after deleting and
rollback ) | iGate | 2 |
| |
| For more SQL Server Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
