DB Administration Interview Questions
Questions Answers Views Company eMail

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

2076

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

TCS,

2 4264

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

1 2508

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

Value Labs,

2375

what is the purpose of catlaog in oracle rman?

Value Labs,

2 4174

what is the difference between hot backup n rman backup?

Value Labs,

1 14221

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 3721

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

IBM,

1617

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

Infozech, Wipro,

3 4518

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

Wipro,

4 5060

what is the differnce between process and thread ?

IBM,

1 3992

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

1312

What is the difference between online backup & offline backup?

CSC,

3 9474

what is the difference between catalog & nocatalog?

CSC,

3 19616

internal architecture

CSC,

1724


Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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

3288


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2360


how can you record information about current session?

474


what is grd?

608


What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

580






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?

1632


Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2174


Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

1813


What is dcl? : sql server DBA

617


How do you open a cluster administrator? : sql server DBA

561


what is the use of recording information about current session?

546


What is the default port no on which sql server listens? : sql server DBA

538


what are the benefits of flashback feature?

571


Where would you look for errors from the database engine?

2325


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

552