Answer Posted / muruga nandhini.p

create table student
(
roll_no int,
name varchar(20),
class int,
address varchar(50),
phone int
)
++++++++++++++++run select than press f5

insert into student values(1,'Bhagwat',10,'Mathura',9268450493)
+++++++++++++run select than press f5

select * from student where roll_no=1
+++++++++++++++++++++++++++run select than press f5

Will sql server 2005 allow you to reduce the size of a column?

916

---

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

963

---

Tell me about pre-defined functions of sql?

1071

---

What happens to a trigger with multiple affected rows?

864

---

Do you know the different ddl commands in sql?

993

---

What is the default value of an integer data type in sql server 2005?

909

---

Detail about query optimizer?

1035

---

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

1013

---

What does the not null constraint do?

998

---

What is the exact numeric data type in sql?

960

---

What is side by side migration in sql server?

1019

---

What is the main difference between ‘between’ and ‘in’ condition operators?

1102

---

What are the different index configurations a table can have?

898

---

How to bind a view to the schema of the underlying tables?

945

---

Can we join two tables without primary key?

978

---