Explain what partitioning is and what its benefit is.

2 Answers  

---

why we use cursors

1 Answers  

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  

---

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers  

---

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers  

---

What are the commands used in dcl? : sql server DBA

0 Answers  

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers   Infosys,

---

what are the performance views in an oracle rac environment?

0 Answers   Oracle,

---

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  

---

How would you extract DDL of a table without using a GUI tool?

0 Answers  

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

0 Answers  

---

what are the types of connection load-balancing?

0 Answers   Oracle,

---