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 do you understand by the oracle?
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 can you find out how many users are currently logged into the database?
What is the full form of dba?
How much money does a dba make?
If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?
What happens if a tablespace clause is left off of a primary key constraint clause?
What kinds of responsibilities does a dba have in a database environment?
Can you remove an open file under unix?
What causes the "snapshot too old" error? How can this be prevented or mitigated?
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?
Which dba certification is best?