Answer Posted / hari

Sql server is having Physical database & logical database
On Physical Database contians file groups and Transcation
log
in file group Contains data files-36,767 TB
data file contains of tabel -
tabel containts extents
Extents contains Pages
pages Contains rows
Transcation log is Userdefined filegroup by default it's
primary file group
Logical - database objects like
view,Sp,functions,Triggers,Indexes and roles etc

What is difference between join and natural join?

956

---

How many columns can we include on clustered index ?

975

---

What is 'Join' and explain its various types.

1129

---

Can you use order by when defining a view?

964

---

What is the need for group functions in sql?

1072

---

What happens if the update subquery returns multiple rows in ms sql server?

1113

---

What is policy management?

987

---

What is difference between joins and subqueries?

1107

---

What is sql server query analyzer?

1016

---

Does view occupy space?

930

---

Characterize join and name diverse sorts of joins?

960

---

What are the types of table?

974

---

Can we perform backup restore operation on tempdb?

999

---

What is a full text index?

916

---

How to remove duplicate rows from table except one?

998

---