Answer Posted / hloni

A transaction is a sequence of database operations that
access the database. It must be a logical unit of work,
meaning that no portion of the transaction can exist on its
own. Either all parts are executed or the transaction is
aborted.

Transaction has five main properties called ACIDS:

1. Atomicity -- all parts of the transaction are executed
or else the transaction is aborted.

2. Consistency -- indicates the permanence of the
database's consistent state. When a transaction is
completed the database reaches a consistence state.

3. Isolation -- means that the data used during the
exercution of a transaction cannot be used by the a second
transaction until the first transaction is complete.

4. Durability -- ensures that once transaction changes are
commited, they cannot be lost even in the event of system
failure.

5. Serializability -- ensures that concurrent execution of
several transaction yields consistent results. This
property is important in a multi-user and distributed
datbases, where multiple transaction are likely to be
executed concurrently.

What is parameterized reports in ssrs ?

150

---

Why would you call update statistics?

1024

---

Explain active/passive and active/active cluster configurations?

1063

---

What is 4nf in normalization form?

1031

---

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

982

---

What is row_number()?

988

---

What is a transact-sql statement?

1068

---

What are the differences between stored procedure and the dynamic sql?

1101

---

How to modify an existing user defined function?

1115

---

What is a bit datatype?

991

---

What are examples of triggers?

1089

---

What is the use of RDBMS?

1008

---

What is not null constraint?

1133

---

What is the new security features added in sql server 2016? : sql server security

1121

---

Why is replication required on the sql server?

1067

---