Answer Posted / monal

ONLINE INDEX CREATION
ONLINE BACKUP (WHICH IS HOT BACKUP IN ORACLE)

How to use linked server?

593

---

What is multi-statement table-value user-defined function?

539

---

Can you tell me about the concept of ER diagrams?

600

---

what are acid properties? : Sql server database administration

497

---

Explain some stored procedure creating best practices or guidelines?

525

---

---

How will you go about resolving deadlocks?

556

---

What is attribute relationships, why we need it? : sql server analysis services, ssas

508

---

Explain database normalization?

649

---

What are character string data types in ms sql server?

639

---

Does full backup break log chain?

552

---

Explain sql server authentication modes?

617

---

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

593

---

How you would rewrite the sql query to return the customerid sorted numerically?

575

---

if no size is defined while creating the database, what size will the database have? : Sql server administration

550

---

In which format does an image save in SQL Server database ?

596

---