DB Administration Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB Administration Interview Questions

Questions Answers Views Company eMail

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1888

If CPU is very slow What can u do to speed up?

1 4399

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 3927

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1665

How many memory layers are in the shared pool?

3 7581

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

IBM,

2 11181

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

2451

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3699

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2410

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1948

How do you tell what your machine name is and what is its IP address?

4 7109

How would you go about verifying the network name that the local_listener is currently using?

3161

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

4387

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

2483

What is the recommended interval at which to run statspack snapshots, and why?

1 3176

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

Why does Oracle not permit the use of PCTUSED with indexes?

2882

how can a session indicate its interest in receiving alerts?

984

What is the difference between dropping a database and taking a database offline? : sql server DBA

1015

how can you generate profile of pl/sql applications to identify performance bottlenecks?

1024

How would you best determine why your MVIEW couldn't FAST REFRESH?

2296

What are the different types of database compression introduced in sql server 2008? : sql server DBA

1042

How would you go about verifying the network name that the local_listener is currently using?

3161

how can you find out if a table can be redefined?

964

what are the benefits of flashback feature?

958

Explain about your sql server dba experience? : sql server DBA

1025

Explain materialized views and how they are used.

2386

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

2402

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

958

Query processing is slow(eg select query)how will u solve that

7766

what is logical system in sap basis

1583

For More Un-Answered { DB Administration } Questions Click Here