Database Management Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Database Management Interview Questions

Questions Answers Views Company eMail

What is the use of RECORD option in EXP command ?

1 4045

What is the use of PARFILE option in EXP command ?

1 3882

What is the use of PARFILE option in EXP command ?

1 3975

What is the use of ANALYSE ( Ver 7) option in EXP command ?

1 3947

What is the use of CONSISTENT (Ver 7) option in EXP command ?

1 4248

What is use of LOG (Ver 7) option in EXP command ?

1 3618

What is the use of FILE option in IMP command ?

1 3627

What is the use of SHOW option in IMP command ?

1 4320

What is the use of IGNORE option in IMP command ?

1 4551

What is the use of GRANT option in IMP command ?

1 3832

What is the use of INDEXES option in IMP command ?

2 5257

What is the use of ROWS option in IMP command ?

1 3888

Let?s say you have 100,000 records and you want to delete 95,000 at a time and keep only 5 thousand. But in local memory you don?t have enough space for 95,000 records. What do you do in this case? How do you delete without any problem with time and performance?

eBay,

3 10170

I need data on eBay customers in Chicago who can did bid on certain item? I dont have access to eBay database directly. How I get the information?

eBay, Google,

1 8219

With DTS packaging I can store tables in Excel and convert them back to SQL. But once I copied tables to Excel I want to modify some info. How you do that without editing the Excel file?

eBay,

2636

Post New Database Management Questions

Un-Answered Questions { Database Management }

What is 3 level architecture dbms?

1059

How to disconnect the user connection?

943

What is join? Mention its types.

1085

Compare non-clustered and clustered index

933

What is built_in Subprogram ?

3082

How do you open .db files?

950

What is the example of rdbms?

988

What is sql in dbms?

1064

What are the differences between hash join, merge join and nested loops?

1070

What is tabular form?

1084

Why normalisation is required?

1016

How is foreign key commands related to primary key?

871

What is difference between database and schema?

1056

What is concept of dbms?

966

What is the difference between primary key and secondary key?

1019

For More Un-Answered { Database Management } Questions Click Here