Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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,

1305

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

1058

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

1 2933

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.

1118

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

1 5152

How does Oracle guarantee data integrity of data changes?

SoftSol,

1 2940

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

2 2677

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

3 4132

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

1879

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

TCS,

2 4124

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

990

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

1247

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

1498

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 1941

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

1 2050


Post New DB Administration Questions






Un-Answered Questions { DB Administration }

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

160


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1970


What the different types of replication and why are they used? : sql server DBA

152


what is a crs resource?

168


What are the commands used in dcl? : sql server DBA

159






In oracle 10g export, import if we declare rows=y/n what would be the output?

1988


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

1756


how can you implement fine-grained auditing?

159


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

1955


what are the types of connection load-balancing?

158


What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

1740


Why would you use sql agent? : sql server DBA

150


What is replication? : sql server DBA

175


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

148


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.

1305