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

1928

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

1 4502

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 4003

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.

1716

How many memory layers are in the shared pool?

3 7719

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

IBM,

2 11303

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?

2494

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

3752

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

2454

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?

1982

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

4 7270

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

3203

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

4421

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

2538

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

1 3255

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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

1115

What are the operating modes in which database mirroring runs? : sql server DBA

1171

what is the diffrence between core dba and apps dba?

2561

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

2238

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

2083

what are the performance views in an oracle rac environment?

1044

internal architecture

2183

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

1170

what is logical system in sap basis

1633

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

1051

. 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?

2440

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

2612

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

1058

What is dbcc? : sql server DBA

1274

What are the different sql server versions you have worked on? : sql server DBA

1005

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