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

1940

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

1 4512

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 4017

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.

1736

How many memory layers are in the shared pool?

3 7754

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

IBM,

2 11350

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?

2505

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

3764

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

2467

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?

1987

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

4 7311

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

3221

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

4431

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

2554

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

1 3270

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What are statistics, under what circumstances they go out of date, how do you update them?

2255

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2642

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.

2285

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1051

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2050

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

1018

How do you trace the traffic hitting a sql server? : sql server DBA

1579

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

2235

What happens on checkpoint? : sql server DBA

1099

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2414

what functionality does oracle provide to secure sensitive information?

1002

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

2947

What purpose does the model database server? : sql server DBA

1199

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

1000

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

2439

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