DB Administration Interview Questions
Questions Answers Views Company eMail

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

2342

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

TCS,

2 4777

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

1 2864

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

Value Labs,

2643

what is the purpose of catlaog in oracle rman?

Value Labs,

2 4720

what is the difference between hot backup n rman backup?

Value Labs,

1 14744

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 4087

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

IBM,

1857

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

Infozech, Wipro,

3 5362

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

Wipro,

4 5874

what is the differnce between process and thread ?

IBM,

1 4395

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

1535

What is the difference between online backup & offline backup?

CSC,

3 10125

what is the difference between catalog & nocatalog?

CSC,

3 20751

internal architecture

CSC,

1967


Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What are the operating modes in which database mirroring runs? : sql server DBA

871


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

785


What are the different sql server versions you have worked on? : sql server DBA

781


What happens on checkpoint? : sql server DBA

794


What is dbcc? : sql server DBA

997


how can you communicate with operating system files from oracle?

797


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?

2593


how can you create a user-defined lock?

828


what are the differences of where and if in SAS?

1906


Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1752


what is logical system in sap basis

1378


Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2310


What are the different types of upgrades that can be performed in sql server? : sql server DBA

922


when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1448


Query processing is slow(eg select query)how will u solve that

7225