Question

Different types of Indexes. Explain them in brief?

What is a DeadLock?

Table A contains column1 , which has 2 values (1, 2) and Table 2 contains column1,which has 2 values (2, 3). Write a query which returns the values that are not common for the tables and the query should return one column with 2 records.

Table A contains column1 which is primary key and has 2 values (1, 2) and Table B contains column1 which is primary key and has 2 values (2, 3). Write a query which returns the values that are not common for the tables and the query should return one column with 2 records.

There are 3 tables Titles, Authors and Title-Authors. Write the query to get the author name and the number of books written by that author, the result should start from the author who has written the maximum number of books and end with the author who has written the minimum number of books.

Optimizing a sql query

What are different user defined functions? difference between function and stored procedure

Eifference between view and stored procedure?

Advantages of views?

Difference between clustered index and non clustered index?

What are the different types of replications available in sqlserver and brief about each?

What are the different types of back-ups available in sqlserver?

What is Foreign Key?

What is unique Key?

what is replication? Different types of replication?

What are different types of backups?

What are the different types of back-ups available in sqlserver?

What are the different types of replications available in sqlserver and brief about each?

Difference between clustered index and non clustered index?

Advantages of views?

Eifference between view and stored procedure?

What are different user defined functions? difference between function and stored procedure

Optimizing a sql query

What is bcp?

How to performance tune the database queries?

bcp ( Purpose of it).

what are the different authentication modes in Sqlserver? if a user is logged under windows authentication mode, how to find his userid?

A table has a primary field which is an auto-identity field .It has 200 rows of data. Write a SQL query which returns all the rows except the first row ?

What is bcp?

What are joins?

What are the advantages of views?

What is difference between DELETE and TRUNCATE?

you have EMP1 table and EMP2 table where id,name are the columns. using left outerjoin write query to retrieve name from emp1 which are not matching in table emp2 ?

for many – many relation (like one customer many phones and many phones one customer) how may table u will create ?

There is a table named Temperature which contains three fields. The fields are DAYID, daytemperature and day. Get the result with day temp delta(diff of prev day and to day) with out using cursor?

What are sequence diagrams?

What is clustred index?

What is denormalisation?

What are joins, Indexes, cursors, locks, blocking?

Difference between delete and truncate?

How do we open sql server in single user mode?

Query optimizer?

Performance tuning of sql server?

Different types of Normalization with Example?

What are joins?

What is Clusters ?

what is authecation levels in sqlserver explain?

I have a table with one column which has many records which are not distinct. I need to find the distinct values from that column and number of times it’s repeated.

Write a SQL Query to find the second maximum salaried person froma employee table.

We have Two tables namely emp_master and emp_details, in which emp_details have the details about the employee. Relationship between both the tables is One-to-Many (for e.g.: his contact numbers, and his communication addresses and etc). In this situation write a SQL Query to find the employee who has more than one contact numbers?

From authors table Select the City which has more than one author located?

Optimizing a sql query, Give 5 things which you would look at?

Difference b/w union and union all?

What is snap shot replication how is it different from Transactional replication?

After adding 100 rows to a table, if I alter that table or add trigger to that table to maintain referential integrity ,will that work? Justify

What is third normalization? Give an example for the same

What is fillfactor?what is the use of it , and why do we go for it, what happens when we ignore it?

RDBMS: Two tables - Table: Customer Fields: CustID, CustName; Table: Order - Fields: OrderNo, CustID, Delivery Date; Questions with related with Outer joins, Group By clauses

There are two tables named emp1 and emp2. Write a query to get all details which are in table emp1 but not in table emp2

There are two employee tables named emp1 and emp2. Both contains same structure (salary details). But Emp2 salary details are incorrect and emp1 salary details are correct. So, write a query which corrects salary details of the table emp2

There exists an employee table. Write a query to retrieve all the employee details who are more than one.

There is a table named MovieTable with three columns - movie name, person and role. Write a query which gets the movie details where Mr. Amitabh and Mr. Vinod acted and their role is actor.

Two tables are there empA and empB. Select all the records from table A which are not there in table B ?

Two tables are there empA and empB. Select all the duplicate rows from table A ?

There are three fields in a table Name, Person and Roll. Find name where Amithbh and Vinod both acted ?

Two tables are there empA and empB, Both having id as common column.A table having worng salary but table B having right salary so update table A from table B ?

What is the diff. between Union and Union all ?

Select all rows which are in table A and not in Table B

There are two tables A and B. Tables A contains incorrect salaries and Table B contains Correct Salaries. Write a query to update Table A with correct salaries from Table B

Table A contains three columns moviename,role and actorname Write a query to give all the movie names with Amitabh and Vinodh both as actor