Answer Posted / swapna

Sql Server can be started from command line, using the
Sqlserver.exe. This exe has some very important parameters
with which a Dba should be familiar with.

-m is used for starting Sql Server in single user mode and -
f is used to start the Sql Server in minimal confuguration
mode

What are cursors stored procedures and triggers?

935

---

What is transaction server isolation?

975

---

Can a rule be bound to any column of any data type?

911

---

Mention the different authentication modes in sql server.

962

---

What does indexation mean?

916

---

What is the full meaning of dml?

903

---

Explain how does the report manager work in ssrs?

902

---

What is normalization? What number of normalization shapes are there?

1054

---

How to create a new table in a given schema?

1112

---

How to convert numeric expression data types using the cast() function?

1004

---

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

854

---

What does sql server mean?

974

---

List out the different types of locks available in sql server?

932

---

How to write an inner join with the where clause in ms sql server?

1028

---

Explain the first normal form(1nf)?

967

---