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 13849

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

2 11504

What does coalescing a tablespace do?

1 15497

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

2 7154

Name a tablespace automatically created when you create a database.

5 12655

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

3 8830

How do you add a data file to a tablespace?

3 7893

How do you resize a data file?

2 14086

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

3 8874

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

3 9415

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

4 11352

How can you rebuild an index?

6 13881

Explain what partitioning is and what its benefit is.

2 7366

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

3 9500

How can you gather statistics on a table?

3 17785

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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.

1729

how can you communicate with operating system files from oracle?

1051

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

2066

Query processing is slow(eg select query)how will u solve that

7912

what is the use of ocr?

1033

what do you understand by flashback feature of oracle?

995

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.

2168

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

2720

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3761

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

1976

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

2109

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

1025

how can you schedule a job in database?

1124

how can you enable flashback feature?

954

what is grd?

1096

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