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

1892

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

1 4420

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 3940

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.

1673

How many memory layers are in the shared pool?

3 7600

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

IBM,

2 11198

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?

2458

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

3709

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

2419

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?

1954

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

4 7128

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

3167

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

4392

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

2496

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

1 3182

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

what is asm?

1005

What is transparent data encryption? : sql server DBA

1130

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

981

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

2419

what is a user-defined lock?

998

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2283

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1948

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

2523

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

1839

Where do you find the default index fill factor and how to change it? : sql server DBA

1035

What are the different ways you can create databases in sql server? : sql server DBA

1089

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

2024

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

1053

What is fill factor? : sql server DBA

1187

how can you enable flashback feature?

900

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