If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
No Answer is Posted For this Question
Be the First to Post Answer
What file will give you oracle instance status information? Where is it located?
What are the types of schemas?
What does a senior database administrator do?
Is oracle dba in demand?
What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
What is the difference between truncate and delete? How would a full table scan behave after?
Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?
How many types of database software are there?
What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?
What is explain plan and how is it used?
How should a many-to-many relationship be handled?
When configuring sqlnet on the client what files need to be set up?