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

1936

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.

1728

How many memory layers are in the shared pool?

3 7741

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

IBM,

2 11335

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?

2502

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?

2464

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 7301

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

3217

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

4427

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

2549

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 }

internal architecture

2195

What is a correlated sub-query? : sql server DBA

1087

how to restore files with rman?

2304

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2619

what is ora 24313?what is the procedure to exclude that error?

2570

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

1268

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

1760

what is logical system in sap basis

1641

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

2297

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

2443

what functionality does oracle provide to secure sensitive information?

994

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1116

1728

how does an oracle clusterware manage crs resources?

1088

what is grd?

1096

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