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 logon trigger?

1069

---

Why do we partition data?

1007

---

How will you monitor replication latency in transactional replication? : sql server replication

1122

---

How do I start sql server?

956

---

What is truncate table?

921

---

What is default constraint in ms sql server?

1003

---

What is the significance of master, tempdb and model databases?

1063

---

What is isolation levels?

1009

---

How we can refresh the view?

1093

---

Can we delete data from a view?

906

---

Can we add our custom code in ssis?

971

---

Which autogrowth database setting is good?

1033

---

You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

121

---

What is NOT NULL Constraint in sql server 2012?

976

---

Explain the use of containers in ssis and also their types?

950

---