DB Administration Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB Administration Interview Questions

Questions Answers Views Company eMail

what is ora 24313?what is the procedure to exclude that error?

2614

the process of adding a cpu in sql server is called..?

TCS,

2 5573

1)how to Take Backup in sql server 2005 from Flash Drive

1 3332

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

Value Labs,

3021

what is the purpose of catlaog in oracle rman?

Value Labs,

2 5494

what is the difference between hot backup n rman backup?

Value Labs,

1 15403

A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?

TCS,

1 4550

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

IBM,

2128

i had backup last manday.now i need back monday to now ..how do get backup?

Infozech, Wipro,

3 6252

now one user in online.now i want drop him..how do u drop him?

Wipro,

4 6758

what is the differnce between process and thread ?

IBM,

1 4959

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

1808

What is the difference between online backup & offline backup?

CSC,

3 11072

what is the difference between catalog & nocatalog?

CSC,

3 21750

internal architecture

CSC,

2255

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2526

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

3020

what are the differences of where and if in SAS?

2258

How would you best determine why your MVIEW couldn't FAST REFRESH?

2414

What purpose does the model database server? : sql server DBA

1273

Which autogrowth database setting is good? : sql server DBA

1244

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

3812

How to start SQL Server in minimal configuration mode?

8093

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

2000

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

1964

What happens on checkpoint? : sql server DBA

1146

how can you communicate with operating system files from oracle?

1096

what is grd?

1157

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

2218

Where would you look for errors from the database engine?

2897

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