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,

2195

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

1923

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

1 4255

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.

1940

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

1 6599

How does Oracle guarantee data integrity of data changes?

SoftSol,

1 4263

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

2 4263

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

3 6415

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

2882

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

TCS,

2 6060

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

1833

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

2189

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

2401

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 3280

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

1 3419

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What is fill factor? : sql server DBA

1185

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.

2195

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

2022

what are the performance views in an oracle rac environment?

1004

What are the different types of upgrades that can be performed in sql server? : sql server DBA

1153

what is the use of recording information about current session?

999

Explain materialized views and how they are used.

2386

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

3348

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2279

Why would you call update statistics? : sql server DBA

950

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

2037

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

953

how can you communicate with operating system files from oracle?

984

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

2402

how can you process messages in order asynchronously?

933

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