Answer / 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

Answer / bhushan

SQL server Architechture is basically a partition of
Logical and Physical data database.

What is amo? : sql server analysis services, ssas

0 Answers  

---

What is the default value of CHAR type?

10 Answers   Bosch,

---

What is the purpose of update statistics and scope_identity() function?

0 Answers  

---

What is difference between process and thread? Explain lazy writer funcationality.

2 Answers   Microsoft,

---

Can you get second highest salary from the table?

0 Answers   QuestPond,

---

What are the properties and different types of sub-queries?

0 Answers  

---

What is the difference between 2-Tier architecture and 3-Tier architecture

15 Answers   CTS, MCN Solutions, Oracle,

---

Ek lifafa 10 noto se bhara hai usme 2 or 5 ke note nahi hai aur usme total 50Rs hai, to batao lifafe me kon se not kitne hia it’s a challenge thank’s

6 Answers   Broadridge,

---

Explain the use of keyword with encryption. Create a store procedure with encryption?

0 Answers  

---

is there more the two primary key in a single table?

26 Answers   Eforce, Systematix,

---

A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?

8 Answers   Infosys,

---

What are the different types of upgrades that can be performed in sql server?

0 Answers  

---