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,

2263

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

1970

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

1 4338

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.

1986

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

1 6694

How does Oracle guarantee data integrity of data changes?

SoftSol,

1 4337

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

2 4386

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

3 6554

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

2931

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

TCS,

2 6184

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

1879

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

2226

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

2432

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 3364

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

1 3505

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

1063

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

1094

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2711

how can you initialize log miner?

1132

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

1072

what is grd?

1084

What are the operating modes in which database mirroring runs? : sql server DBA

1171

What the different topologies in which replication can be configured? : sql server DBA

1254

how does an oracle clusterware manage crs resources?

1078

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

1208

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?

3401

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2612

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

981

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?

2083

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1898

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