| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| We create an index to fast the search. How it fast the
query? Do we write any special keyword with query? | | 3 |
| how do we find every fifth record in a table | | 11 |
| Can you tell me the difference between DELETE & TRUNCATE
commands? | | 11 |
| how to get the automatic backup of the database in the sql
server | | 3 |
| What is the difference between distinct clause and group by
clause? | Value-Labs | 1 |
| How to write a script for upate the data in prod , i have
50000 row are there | TCS | 2 |
| In performance wise distinct is good or group by is good?
eg:select name from emp group by name;
select distinct name from emp; | Infosys | 4 |
| how can we use a composite key for two tables and how can
we represent it | BoA | 1 |
| Plz tell about backup&recovery? | | 2 |
| can any one please send sql quries most used in applications. | | 1 |
| What's the difference between a primary key and a unique key? | Wipro | 8 |
| how to select a field with firstletter as capital and
remaining are small letters | | 8 |
| 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 | 5 |
| can primery key be a non clustered index? | | 8 |
| what is the order of execution of where,having,group by in
select stement | Tanla-Solutions | 5 |
| 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 is the difference between UNION and UNIONALL? | CTS | 2 |
| Can we create a clustered index on composite primary key. | | 2 |
| How to Check Whether a Global Temporary Exists in a SQL
Database or not? | | 2 |
| What is the difference between OLEDB and ODBC | CFCI | 3 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
