Answer / nikhil

Global Index: A global index is a one-to-many relationship,
allowing one index partition to map to many table
partitions. A global index can only be a range partition!

Local Index: A local index is a one-to-one mapping between a
index partition and a table partition. In general, local
indexes allow for a cleaner “divide and conquer” approach
for generating fast SQL execution plans with partition pruning.

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers  

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

0 Answers  

---

Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?

11 Answers   FA, GE, Wipro,

---

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

0 Answers  

---

Where would you look for errors from the database engine?

0 Answers   IBM,

---

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 Answers  

---

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

0 Answers  

---

How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers  

---

What the different topologies in which replication can be configured? : sql server DBA

0 Answers  

---

What view would you use to determine free space in a tablespace?

3 Answers  

---

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

0 Answers  

---

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

---