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,

1991

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

1757

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

1 3994

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.

1769

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

1 6322

How does Oracle guarantee data integrity of data changes?

SoftSol,

1 3987

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

2 3944

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

3 5952

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

2636

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

TCS,

2 5671

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

1683

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

2022

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

2226

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 2985

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

1 3206


Post New DB Administration Questions

Un-Answered Questions { DB Administration }

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

1881


what is asm?

832


how to restore files with rman?

2004


what are the performance views in an oracle rac environment?

836


If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

797


I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1739


how can you enable flashback feature?

743


Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2089


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.

1991


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

807


Can you redefine a table online?

911


You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1775


what are the benefits of flashback feature?

815


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

2658


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

805