DB Administration Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB Administration Interview Questions

Questions Answers Views Company eMail

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

Infosys,

2279

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

1975

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 4347

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1992

Explain how you would restore a database using RMAN to Point in Time?

1 6707

How does Oracle guarantee data integrity of data changes?

SoftSol,

1 4359

Which environment variables are absolutely critical in order to run the OUI?

2 4405

What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

3 6576

Why does Oracle not permit the use of PCTUSED with indexes?

2940

What would you use to improve performance on an insert statement that places millions of rows into that table?

TCS,

2 6205

What would you do with an "in-doubt" distributed transaction?

1886

What are the commands you'd issue to show the explain plan for "select * from dual"?

2229

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

2439

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 3382

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1 3513

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

how can you connect from 10g user to 11g user??

2114

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

3761

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

2152

how can you find out if a table can be redefined?

1012

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

2279

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

1161

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

2635

what is the diffrence between core dba and apps dba?

2569

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1109

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.

2167

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

4426

What authentication modes does sql server support? : sql server DBA

1215

Explain materialized views and how they are used.

2441

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2336

Why would you call update statistics? : sql server DBA

989

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