DB Administration Interview Questions
Questions Answers Views Company eMail

How would you force a log switch?

4 11924

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

2 10547

What does coalescing a tablespace do?

1 14559

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

2 5995

Name a tablespace automatically created when you create a database.

5 10425

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

3 7557

How do you add a data file to a tablespace?

3 6529

How do you resize a data file?

2 12956

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

3 7371

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

3 8227

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

4 9582

How can you rebuild an index?

6 11560

Explain what partitioning is and what its benefit is.

2 6318

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

3 8299

How can you gather statistics on a table?

3 16398


Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What are the different types of indexes available in sql server? : sql server DBA

557


What happens on checkpoint? : sql server DBA

545


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

2070


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

528


What is fill factor? : sql server DBA

616






Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1485


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

546


Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

1702


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

2199


What is the default port no on which sql server listens? : sql server DBA

539


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.

1218


What are the different sql server versions you have worked on? : sql server DBA

519


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

575


Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

1726


what is logical system in sap basis

1103