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

1934

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

1 4506

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 4011

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.

1726

How many memory layers are in the shared pool?

3 7733

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

IBM,

2 11328

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?

2500

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

3761

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

2462

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?

1985

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

4 7291

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

3215

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

4425

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

2547

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

1 3263

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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?

1985

What would you do with an "in-doubt" distributed transaction?

1885

What are the commands you'd issue to show the explain plan for "select * from dual"?

2228

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2107

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

2438

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

3761

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

2279

What the different topologies in which replication can be configured? : sql server DBA

1265

how can you connect from 10g user to 11g user??

2113

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

2547

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

1079

What is the default fill factor value? : sql server DBA

1126

How would you extract DDL of a table without using a GUI tool?

2487

who owns the operating system files created by the utl_file package?

1072

What types of replication are supported in sql server? : sql server DBA

1294

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