Un-Answered Questions { Oracle DBA (Database Administration) }

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

416


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

445


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

425


How many control files should you have?

428


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

443


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

395


How do you prevent output from coming to the screen?

373


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

407


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

415


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

368


What are the requirements of simple database?

408


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?

409


What command is used to type files to the screen?

407


How can you find out how many users are currently logged into the database?

447


How can you determine if an index needs to be dropped and rebuilt?

415