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,

2356

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

2018

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

1 4443

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.

2044

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

1 6799

How does Oracle guarantee data integrity of data changes?

SoftSol,

1 4452

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

2 4525

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

3 6709

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

3020

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

TCS,

2 6312

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

1939

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

2272

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

2499

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 3473

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

1 3570

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What is fill factor? : sql server DBA

1309

How would you extract DDL of a table without using a GUI tool?

2538

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

2128

what are the benefits of flashback feature?

1094

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

1385

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

1242

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

1266

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

1634

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1371

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

1319

what is a crs resource?

1240

What is the difference between dropping a database and taking a database offline? : sql server DBA

1111

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3812

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

2018

How to start SQL Server in minimal configuration mode?

8093

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