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?

2518

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

TCS,

2 5298

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

1 3164

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

Value Labs,

2884

what is the purpose of catlaog in oracle rman?

Value Labs,

2 5261

what is the difference between hot backup n rman backup?

Value Labs,

1 15164

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 4389

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

IBM,

2016

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

Infozech, Wipro,

3 5967

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

Wipro,

4 6428

what is the differnce between process and thread ?

IBM,

1 4739

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

1703

What is the difference between online backup & offline backup?

CSC,

3 10713

what is the difference between catalog & nocatalog?

CSC,

3 21436

internal architecture

CSC,

2141

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

4288

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

2134

how to restore files with rman?

2236

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

3696

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.

2192

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

2580

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

2226

How to start SQL Server in minimal configuration mode?

7805

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

1022

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1050

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

1013

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

1868

how can you process messages in order asynchronously?

930

what are the benefits of flashback feature?

954

what is asm?

994

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