| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to Execute an Operating System Command From Within SQL
Server ? | | 2 |
| 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 | 7 |
| any one can explain
Self mapping
Delegation
Remote Credentials | | 1 |
| What are the differences between stored procedure and
functions in SQL Server 2000? | TCS | 7 |
| How to Display, Amount of Disk Activity Generated by
Transact-SQL Statements?
| | 1 |
| What is the system function to get the current user's user
id? | TCS | 1 |
| we have emp table like Ename,EDOJ,EDOB with Column
structure.but we want to know the employee Age.How? Any
Body Plz | | 6 |
| create procedure proc1 (@a int)
as
begin
if @a=1
create table #temp(a1 int)
else
create table #temp(a1 int)
end
while executeing the above code it shows error
like '#temp already exist' .why it shows an error? | IBM | 1 |
| What are three SQL keywords used to change or set someone?s
permissions? | | 3 |
| Well sometimes sp_reanmedb may not work you know because if
some one is using the db it will not accept this command so
what do you think you can do in such cases? | | 2 |
| How do we get month name in SQL Server 2000, Oracle, MS Access? | | 4 |
| What is a trigger? | | 3 |
| How to delete particular value in the column of a table.Is
it possible or not?if possible give it as in query. | | 2 |
| what is differece between union and union all | | 3 |
| i have 4 tables.. T1, T2, T3, T4..
these tables have the same structure and they store the
information entered in different years..
T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored
2005..
i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and
T4 to T1..
how do i do that? Temp tables cannot be used.. | | 1 |
| can we call stored Procedure in Function in Sql Server 2000
and vice versa. | eSoft | 1 |
| Explain some DBCC commands? | | 3 |
| when we use function instead of procedure? plz tell me the
situation with ex? | | 1 |
| What is an extended Stored Procedure? | | 1 |
| Difference Between varchar and nvarchar datatype? | Satyam | 1 |
| |
| For more SQL Server Interview Questions Click Here |