What is a dba programmer?
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?
When should an artificial (or derived) primary key be used?
What is the difference between truncate and delete? How would a full table scan behave after?
Do you need a commit after ddl statements?
If you see the value for reloads is high in the estat library cache report is this a matter for concern?
How do you set up your tablespace on installation level: low?
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?
If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)
Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?
What is the use of the drop option in the alter table command?
What is a junior dba?
How can you find dead processes?