IBM SQL Server Interview Questions Answers, IBM Placement Papers, IBM Technical, HR Interview Questions, IBM Aptitude Test Questions, IBM Campus Placements Exam Questions

Company Name Starts with ...

# A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

IBM SQL Server Interview Questions

Questions Answers Views Company eMail

what is the order of execution of where,having,group by in select stement

6 22493

I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000

17 20549

Difference between sql server 2000 and sql server 2005?

11 52758

how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.

6 10126

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?

8 10537

how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?

16 25228

when we use function instead of procedure? plz tell me the situation with ex?

3 10949

What are the different types of backup avaible in SQL SErver

6 10034

what is Constraint? How many types of constraints in SQL ?

38 88289

how can you attach more than 20 ldf files in sql server

1948

how to select 5 to 7 rows from a table, which contains 10 rows?

21 26335

1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

2437

What do u mean by orphan users, how will u list them in the DB

2 6575

What is the use of MOVE keyword in restore command

3 5949

How will u find the query which is running in some other machine

4 6704

Post New IBM SQL Server Interview Questions

IBM SQL Server Interview Questions

IBM SQL Server Interview Questions (69)

Un-Answered Questions

Why truncate is faster than delete?

1053

Can you call one constructor from another if a class has multiple constructors?

969

What is the use of mrp group?

1014

Compare ansible with chef.

How to Calculate Current Rating of SDFU (Switch Disconnector Fuse unit) for Protectionof Capacitor Bank connected to Busbar of 800Amp,in LV side of 11/0.433KV, 250KVA Transformer?

5353

How do you comment out code in c#?

846

What are the two categories of data types in the java programming language?

918

What is a c token and types of c tokens?

1011

What do you mean by bootstrap collapsing elements?

How can we use tkprof?

What do chmod command do?

1137

What is a data annotator?

707

What is wpf visual studio?

145

How to do cable earhing? whether by grounding Armour to ground or by running extra G.I wire along with cable? which one is preferred mostly amoung them? If the second one is more preferable how many GI wires to be run along with cable (1 or 2)?

2077

What are the possible razor view extensions?

942