Answer Posted / hari

Sql Server is having Physical database and logical database
in physical database-Filegroups,transcation log
Filegroups contains - datafiles
datafiels contains - tables
tables contains - Extents
Extents contains - pages
Pages contains - Rows
Trancastion log is user defined file group by default it is
primary file group,
Logical database objects like
storedprocedre,views,indexes,trigeers

Can a database be shrunk to 0 bytes, if not, why?

642

---

How to update a field in SQL after ALTERING a row?

689

---

What are the differences between char and varchar in ms sql server?

572

---

Explain about the command-line tool SQLCMD?

552

---

How to create an identity column?

637

---

---

How to find tables without indexes?

626

---

Describe and explain about SQL native client?

614

---

What is row-level compre?

541

---

What is an index in a database?

532

---

Is the log file is a part of file group?

548

---

How do use Having,Group by,Group function in SQL?

1352

---

What is the purpose of the master database?

602

---

What is the datatype of rowid?

506

---

What is resultset concur_updatable?

581

---

Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

701

---