DB Administration Interview Questions
Questions Answers Views Company eMail

what is the role of dip user in our database?

2025

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

DELL, TCS,

4 7249

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

1815

how to restore files with rman?

1725

how will you see when the database was started using sql prompt?

IBM,

2 5303

what is the diffrence between core dba and apps dba?

Cap Gemini,

2055

how can you connect from 10g user to 11g user??

HP,

1666

one datafile is lost in standy side how can you recover that??

2 2842

i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

iGate,

1 4777

I lost one datafile i dont have backup how can you recover that???

HP,

2 4896

what is the use of home directory???

HP,

1 3918

what is rebuild index??

IBM, Sapient,

2 4681

What is the dataguard background process??

iGate,

1 5328

which background process invoke at the time of upgradation tell me???

iGate,

2199

any body know about orawaves do they really provide placements in their unique placement program

TCS,

1 3359


Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2155


what is the role of dip user in our database?

2025


how to restore files with rman?

1725


when does an alert gets signaled?

561


What the different components in replication and what is their use? : sql server DBA

522






Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1475


What is fill factor? : sql server DBA

616


What is a system database and what is a user database? : sql server DBA

583


What are the commands you'd issue to show the explain plan for "select * from dual"?

1703


how can you get actual data change values from previous transactions in oracle?

581


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

3774


what is logical system in sap basis

1103


how can you implement fine-grained auditing?

584


What the different types of replication and why are they used? : sql server DBA

527


how can you record information about current session?

475