DB Administration Interview Questions
Questions Answers Views Company eMail

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

2094

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

TCS,

2 4289

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

1 2529

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

Value Labs,

2389

what is the purpose of catlaog in oracle rman?

Value Labs,

2 4196

what is the difference between hot backup n rman backup?

Value Labs,

1 14243

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 3755

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

IBM,

1628

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

Infozech, Wipro,

3 4575

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

Wipro,

4 5110

what is the differnce between process and thread ?

IBM,

1 4018

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

1325

What is the difference between online backup & offline backup?

CSC,

3 9519

what is the difference between catalog & nocatalog?

CSC,

3 19677

internal architecture

CSC,

1745


Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What is replication? : sql server DBA

618


how does an oracle clusterware manage crs resources?

561


What types of replication are supported in sql server? : sql server DBA

591


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

3298


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

1719






suppose you want to audit specific activities on sensitive data. How can you achieve that?

534


Where do you find the default index fill factor and how to change it? : sql server DBA

544


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?

2166


how can you connect from 10g user to 11g user??

1674


what do you understand by fine-grained auditing?

619


Why would you call update statistics? : sql server DBA

569


what is asm?

593


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?

1989


how can you initialize log miner?

568


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

2411