DB Administration Interview Questions
Questions Answers Views Company eMail

why Datapump is faster than traditional export and import

Mphasis,

4 20630

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

Mphasis,

2 4654

WHEN DOWN TIME WHAT CAN U DO?

TCS,

1 4341

How can we see the database version in os level

Oracle,

6 12130

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 7472

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

Cognizant,

2 5314

How many packages we have in db

Tesco,

1 4996

wat is global index and local indes

Oracle,

1 4844

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

TCS,

3 7270

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

CTS,

1 5012

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

Cap Gemini, iGate,

1 24533

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

1881

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

Oracle,

1 4103

what is meant by gateway

IBM,

1 3666

what is difference between user managed backup and rman backup?

CTS,

1 16265


Post New DB Administration Questions

Un-Answered Questions { DB Administration }

how to restore files with rman?

2002


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

1876


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

1750


Why would you call update statistics? : sql server DBA

799


how can you process messages in order asynchronously?

778


how can you record information about current session?

766


When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

805


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

936


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.

1991


How would you go about verifying the network name that the local_listener is currently using?

3006


what is asm?

832


Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

807


what are the performance views in an oracle rac environment?

835


Why would you use sql agent? : sql server DBA

812


How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1828