Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 Answers  

---

Name two files used for network connection to a database.

5 Answers  

---

how can you get actual data change values from previous transactions in oracle?

0 Answers   Oracle,

---

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  

---

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

2 Answers   TCS,

---

What is a system database and what is a user database? : sql server DBA

0 Answers  

---

why we use cursors

1 Answers  

---

What background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,

---

What is replication? : sql server DBA

0 Answers  

---

the process of adding a cpu in sql server is called..?

2 Answers   TCS,

---

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

0 Answers  

---

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

1 Answers  

---