What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers   TCS,

---

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  

---

How do you tell what your machine name is and what is its IP address?

4 Answers  

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers  

---

How do you open a cluster administrator? : sql server DBA

0 Answers  

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

0 Answers  

---

What column differentiates the V$ views to the GV$ views and how?

3 Answers  

---

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

0 Answers  

---

how can you initialize log miner?

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  

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

0 Answers  

---

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

---