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

668

---

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

633

---

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

596

---

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

605

---

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

593

---

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

600

---

How many control files should you have?

589

---

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

611

---

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

540

---

How do you prevent output from coming to the screen?

521

---

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

556

---

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

633

---

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

545

---

What are the requirements of simple database?

568

---

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?

584

---