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  

---

one datafile is lost in standy side how can you recover that??

2 Answers  

---

what is asm?

0 Answers   Oracle,

---

by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers   CSC, Logica CMG,

---

What is blocking and how would you troubleshoot it?

1 Answers  

---

---

how do see how much space is used and free in a tablespace

2 Answers   Genpact,

---

How do you add a data file to a tablespace?

3 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,

---

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers  

---

Can you redefine a table online?

0 Answers   Oracle,

---

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers  

---

Name three advisory statistics you can collect.

1 Answers  

---