What is a production dba?
No Answer is Posted For this Question
Be the First to Post Answer
How does one create a new database?
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?)
When configuring sqlnet on the server what files must be set up?
What exactly does a dba do?
How can you determine if the sqlnet process is running for sqlnet v1? How about v2?
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?
Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?
What is a dba certification?
What command is used to type files to the screen?
You see multiple fragments in the system tablespace, what should you check first?
Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?
Does dba need to know programming?