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

680

---

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

641

---

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

642

---

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

645

---

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

638

---

How many control files should you have?

629

---

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

663

---

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

583

---

How do you prevent output from coming to the screen?

575

---

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

621

---

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

684

---

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

600

---

What are the requirements of simple database?

610

---

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?

630

---

What command is used to type files to the screen?

635

---