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 database

IBM,

2 4989

dear sir please provide what question will be asked in bank it officer interview

2121

dear sir please provide what question will be asked in CWE in bank it officer

2240

Dept wise avrage salary

HCL, IBM, TCS,

2 6078

dear all,Greetings of the day.. i have a small query plz rply if u knw.. i have done MBA Hr and B.sc microbiology. i am very much interested in it industry,so i am planing to go with oracle HRMS module,can it be work out??

2241

Explain the Normalized Relations?

2698

what is the difference between inline query and corelated subquery

1 4483

Can anybody give me link for BOXI R3.1 Key please

2594

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name, price 101, LED Lights,200 102, 20 watt CFL Lights, 145 103, 30 watt CFL lights,155 Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence flat file product list has two column pro_name, price 20 watt tube light ,45 30 watt tube light ,60

TCS,

1 5845

select Nth highest salary by using rownum

Ford, TCS, Tech Mahindra,

4 21765

determine the minimum salary of the employee and his details who join on the same date

3 6118

I'm need to prepare Month Over Month Sales Growth report. Is there any function available in OBIEE to perform this task.

Infosys,

2171

What is the difference between Memory_target and Memory_max_target? Why its required to resize these parameter?

Sutherland,

1 8812

The use of LAST_VALUE() AND FIRST_VALUE() with an example

Amazon,

1 5042

I have 2 tables with 1 million rows each. I have updated 1 row in first and 1 million update on second table. Now I commit both the updates. Which one will commit fast and Why?

2617

Post New Database Management Questions

Un-Answered Questions { Database Management }

Explain the importance of partitioning.

985

Explain concurrency transparency.

1050

What do you understand by cursor?

942

Compare a hierarchical and network database model?

985

Mention the differences between trigger and stored procedures

1147

What is database management system(dbms)?

987

What are the integrity rules in dbms?

1100

What are cursors give different types of cursors?

959

What are the types of tables in database?

991

What is the concept of sub-query in terms of sql?

961

Have you heard about sixth normal form?

992

Give us a non-computer example of preemptive and non-preemptive scheduling?

921

Could you give me an example how, where I code checkpoint and restart. I need and example

1011

What is end users in dbms?

959

What is the importance of a database?

973

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