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 7143

Explain an ORA-01555

2 6811

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 18731

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

2 10823

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 9030

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

1 4641

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2344

Explain the use of table functions.

1 5559

Name three advisory statistics you can collect.

1 5598

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

1 8495

Explain materialized views and how they are used.

2443

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

1 9685

What background process refreshes materialized views?

Accenture, FLSmidth,

2 12561

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

2 8744

Describe what redo logs are.

1 5082

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

suppose you want to audit specific activities on sensitive data. How can you achieve that?

1003

What are the different types of upgrades that can be performed in sql server? : sql server DBA

1211

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?

2096

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2344

What the different types of replication and why are they used? : sql server DBA

1178

how can you enable flashback feature?

957

how can you record information about current session?

1050

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

2169

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2685

What are the steps you will take to improve performance of a poor performing query?

2850

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

1050

What is the importance of a recovery model? : sql server DBA

1031

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

1081

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

2570

how can you schedule a job in database?

1127

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