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,

1971

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

1742

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

1 3970

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.

1753

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

1 6283

How does Oracle guarantee data integrity of data changes?

SoftSol,

1 3946

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

2 3900

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

3 5889

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

2615

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

TCS,

2 5630

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

1668

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

1994

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

2199

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 2960

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

1 3177


Post New DB Administration Questions

Un-Answered Questions { DB Administration }

How do you troubleshoot errors in a sql server agent job? : sql server DBA

816


What is a system database and what is a user database? : sql server DBA

841


What is the difference between the 2 operating modes of database mirroring? : sql server DBA

756


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

824


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

826


What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2203


what do you understand by flashback feature of oracle?

790


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

781


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

1166


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

4187


How can you control the amount of free space in your index pages? : sql server DBA

1013


what is the use of ocr?

799


How do you open a cluster administrator? : sql server DBA

798


Where would you look for errors from the database engine?

2607


how can you schedule a job in database?

828