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?

2521

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

TCS,

2 5306

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

1 3168

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

Value Labs,

2889

what is the purpose of catlaog in oracle rman?

Value Labs,

2 5268

what is the difference between hot backup n rman backup?

Value Labs,

1 15169

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 4390

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

IBM,

2022

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

Infozech, Wipro,

3 5980

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

Wipro,

4 6439

what is the differnce between process and thread ?

IBM,

1 4746

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

1706

What is the difference between online backup & offline backup?

CSC,

3 10724

what is the difference between catalog & nocatalog?

CSC,

3 21450

internal architecture

CSC,

2143

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

what functionality does oracle provide to secure sensitive information?

946

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

1196

Why would you use sql agent? : sql server DBA

1022

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

2296

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

2380

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

2450

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

1101

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?

2749

What are the different types of database compression introduced in sql server 2008? : sql server DBA

1042

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

2403

Can you redefine a table online?

1063

how does an oracle clusterware manage crs resources?

1030

What is the importance of a recovery model? : sql server DBA

970

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.

2115

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

1833

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