DB Administration Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB Administration Interview Questions

Questions Answers Views Company eMail

How would you go about increasing the buffer cache hit ratio?

2 6993

Explain an ORA-01555

2 6695

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 18560

How would you determine the time zone under which a database was operating?

2 10694

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 8939

What command would you use to encrypt a PL/SQL application?

1 4532

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2276

Explain the use of table functions.

1 5469

Name three advisory statistics you can collect.

1 5499

Where in the Oracle directory tree structure are audit traces placed?

1 8400

Explain materialized views and how they are used.

2381

When a user process fails, what background process cleans up after it?

1 9579

What background process refreshes materialized views?

Accenture, FLSmidth,

2 12418

How would you determine what sessions are connected and what resources they are waiting for?

2 8604

Describe what redo logs are.

1 4976

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What is the difference between clustered and non-clustered index? : sql server DBA

1024

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.

1661

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

933

What is transparent data encryption? : sql server DBA

1115

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

2482

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?

1944

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.

2192

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

4289

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?

2447

how can you record information about current session?

977

when does an alert gets signaled?

980

how can you enable flashback feature?

894

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2408

what are the types of connection load-balancing?

938

How to start SQL Server in minimal configuration mode?

7806

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