Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?
No Answer is Posted For this Question
Be the First to Post Answer
How can you find out how many users are currently logged into the database?
What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
What are the functions of administration?
How should a many-to-many relationship be handled?
using hot backup without being in archive log mode, can you recover in the event of a failure? Why or why not?
Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.
How many types of database software are there?
You see multiple extents in the temporary tablespace. Is this a problem?
What do you mean by oracle dba and what is its role?
You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.
Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?
What are the five main functions of a database administrator?