What are the types of locks in database?
No Answer is Posted For this Question
Be the First to Post Answer
You see a wait on lms process in statspack, what does that mean?
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?
What is a dba why is this position necessary?
Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?
What is main function of database administrator?
What is the relation between database and instance?
Explain procedure to change characterset of a database.
How can you find dead processes?
What is the difference between raid 5 and raid 10? Which is better for oracle?
You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?
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?)
Why are recursive relationships bad? How do you resolve them?