Answer Posted / sandeep kumar

Transaction is a one or more database operation that is
execute logical unit of work
Acid properties
A-Atomacity
C-Consistancy
I-Isolation
D-Durability

How do you handle datasets larger than 50 gb?

162

---

What does dml stand for?

929

---

When columns are added to existing tables, what do they initially contain?

1013

---

What is a user-defined function in the sql server and what is its advantage?

1072

---

If no size is defined while creating the database, what size will the database have?

966

---

What are the new features are introduced in sql server 2012 reporting services?

147

---

How can you start sql server in different modes?

952

---

Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

143

---

What is recompile sql server?

1017

---

What is a non equi join?

953

---

How to enter unicode character string literals in ms sql server?

1051

---

What are relationships and mention different types of relationships in the dbms

946

---

How many columns can we include on clustered index ?

967

---

What are the different types of columns types constraints in the sql server?

1059

---

What are the differences between clustered and non-clustered index?

1003

---