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

583

---

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

558

---

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

570

---

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

544

---

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

546

---

How many control files should you have?

553

---

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

566

---

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

507

---

How do you prevent output from coming to the screen?

483

---

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

512

---

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

582

---

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

511

---

What are the requirements of simple database?

523

---

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?

533

---

What command is used to type files to the screen?

546

---