DB Administration Interview Questions
Questions Answers Views Company eMail

why Datapump is faster than traditional export and import

Mphasis,

4 19817

orra 1555 what is this error,why it is occur?

Mphasis,

2 4087

WHEN DOWN TIME WHAT CAN U DO?

TCS,

1 3955

How can we see the database version in os level

Oracle,

6 10945

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

Cognizant,

4 6689

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

Cognizant,

2 4794

How many packages we have in db

Tesco,

1 4655

wat is global index and local indes

Oracle,

1 4426

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

TCS,

3 6485

why do we give pctfree and pctused in create table statement?

CTS,

1 4565

What questions might be they ask in managerial round in capgemini.

Cap Gemini, iGate,

1 24001

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

1638

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

Oracle,

1 3736

what is meant by gateway

IBM,

1 3235

what is difference between user managed backup and rman backup?

CTS,

1 15734


Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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

549


what do you understand by flashback feature of oracle?

548


What is a correlated sub-query? : sql server DBA

577


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?

2023


Explain about your sql server dba experience? : sql server DBA

537






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

572


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.

1742


Why would you use sql agent? : sql server DBA

567


internal architecture

1745


how can you create a user-defined lock?

579


how can you schedule a job in database?

589


What are the different types of indexes available in sql server? : sql server DBA

567


what are the performance views in an oracle rac environment?

549


What is dbcc? : sql server DBA

771


how can you process messages in order asynchronously?

549