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 13664

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

2 11406

What does coalescing a tablespace do?

1 15410

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

2 7031

Name a tablespace automatically created when you create a database.

5 12413

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

3 8719

How do you add a data file to a tablespace?

3 7727

How do you resize a data file?

2 13957

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

3 8744

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

3 9274

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

4 11192

How can you rebuild an index?

6 13645

Explain what partitioning is and what its benefit is.

2 7237

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

3 9374

How can you gather statistics on a table?

3 17637

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1992

What types of replication are supported in sql server? : sql server DBA

1228

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

1072

how to restore files with rman?

2252

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

how can you generate profile of pl/sql applications to identify performance bottlenecks?

1033

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

1038

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1997

what is a user-defined lock?

1000

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

2024

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.

1675

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

3356

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.

2119

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

953

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

2796

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