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 force a log switch?

4 13642

Give two methods you could use to determine what DDL changes have been made.

2 11394

What does coalescing a tablespace do?

1 15399

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 7009

Name a tablespace automatically created when you create a database.

5 12381

When creating a user, what permissions must you grant to allow them to connect to the database?

3 8704

How do you add a data file to a tablespace?

3 7705

How do you resize a data file?

2 13942

What view would you use to look at the size of a data file?

3 8729

What view would you use to determine free space in a tablespace?

3 9253

How would you determine who has added a row to a table?

4 11172

How can you rebuild an index?

6 13622

Explain what partitioning is and what its benefit is.

2 7223

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 9359

How can you gather statistics on a table?

3 17623

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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

4293

How do you trace the traffic hitting a sql server? : sql server DBA

1467

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

2410

What is transparent data encryption? : sql server DBA

1118

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2648

which background process invoke at the time of upgradation tell me???

2665

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

958

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

2572

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

1107

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1923

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2749

What are the different types of database compression introduced in sql server 2008? : sql server DBA

1042

what is logical system in sap basis

1583

What happens on checkpoint? : sql server DBA

1037

how to restore files with rman?

2244

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