| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Explain Active/Active and Active/Passive cluster
configurations? | | 1 |
| What is the difference between views and stored procedures?
Can we have input parameters for views? | | 3 |
| What is a job? | | 3 |
| How many max. conditions can b written under the WHERE
clause?
Like select * from [tabnam] WHERE
(cond1...or..cond2....or...cond3...and.....so on.....???
(upto how much extent))????? | SAP-Labs | 2 |
| What are the different types of replication? How are they used? | | 3 |
| which one will take 1st priority in case of insert statement
and select statement??? | | 2 |
| How do you use DBCC statements to monitor various aspects of
a SQL server installation? | | 1 |
| i need some interview questions on sql server developer plz
any onee send some links. | | 1 |
| 1.How to check the backup file details if we do not have
access to that folder
2.how to check the backup file size without connecting to
the folder
| IBM | 1 |
| what are batch in sql server?
| Satyam | 2 |
| What is Covering Indexes?
Plz explain with example | | 2 |
| what is syntex second or third highest salary.
thanks & Regards
Dhirendra sinha | | 4 |
| what purpose does OPENXML clause have in sql server stored
procedure? | | 1 |
| table:employee
EID ENAME MID(manager ids)
101 rama null
102 sita 101
103 siva 101
104 ganesh 103
. . .
. . .
for 103 ID the manager ID is 101(RAMA) and for 104 manager
is SIVA
if i give employee id (EID) you have to tell the manager for
that EID write query?
eample:if i give 102 .The query output should be manager for
102 ID that it should print RAMA as output
| | 5 |
| hi,
how to match retrieve the unmatched records from 2 tables
in which we dont have any primary key. example : table1 has
1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want
the numbers from 6 to 10 to be displayed and should not
come as null. i need the numbers. please reply as soon as
possible.
| | 2 |
| How to write stored procedure to update the data in 10
tables | | 4 |
| in tabase table having a column in it empname field is
there which having 5 duplicate values is there i want
deleted all the duplicates i want showing only one name
only. | | 7 |
| What is Trigger? | Misys | 2 |
| What is the difference between 2-Tier architecture and
3-Tier architecture | Oracle | 10 |
| i have table students with fields classname,studname
select * from students
classname studname
1 xxxxx
1 yyyy
1 zzzz
2 qqqq
2 tttt
3 dsds
3 www
i want the output should be
No of students in class 1 : 3
No of students in class 2 : 2
No of students in class 3 : 2
| HCL | 2 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
