When should the default values for oracle initialization parameters be used as is?

672

---

What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?

638

---

What is the purpose of the import option ignore? What is its default setting?

600

---

Which process writes data from data files to database buffer cache?

611

---

When should an artificial (or derived) primary key be used?

597

---

Give one method for transferring a table from one schema to another?

605

---

How many control files should you have?

591

---

Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?

616

---

What happens if the constraint name is left out of a constraint clause?

547

---

How do you prevent output from coming to the screen?

528

---

What is dump destination? What are bdump, cdump and udump?

563

---

When configuring sqlnet on the server what files must be set up?

636

---

I have applied the following commands: now what will happen, will the database will give an error / it will work?

549

---

What are the requirements of simple database?

570

---

Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?

591

---