How do you set up your tablespace on installation level: low?
No Answer is Posted For this Question
Be the First to Post Answer
What kinds of responsibilities does a dba have in a database environment?
A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?
What does >> do?
What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?
What is the purpose of the grep command?
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?
What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?
What happens if a tablespace clause is left off of a primary key constraint clause?
What do you mean by oracle database?
What do you understand by the term 'normalization'? Explain the various modes of normalization?
When should the default values for oracle initialization parameters be used as is?