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

611

---

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

580

---

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

555

---

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

566

---

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

542

---

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

540

---

How many control files should you have?

548

---

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

565

---

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

506

---

How do you prevent output from coming to the screen?

479

---

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

510

---

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

577

---

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

507

---

What are the requirements of simple database?

521

---

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?

530

---