Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between truncate and delete? Why is one faster?
- 0 Answers
- 692 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
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 end user in database?
What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?
Tell me about standby database? What are some of the configurations of it?
If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
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 are dba privileges?
Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?
You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?
How do I become a dba?
Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)
How would you find total size of database in os level?
Oracle General 
