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 5097

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

2181

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

2295

Dept wise avrage salary

HCL, IBM, TCS,

2 6198

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??

2300

Explain the Normalized Relations?

2756

what is the difference between inline query and corelated subquery

1 4563

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

2651

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 5925

select Nth highest salary by using rownum

Ford, TCS, Tech Mahindra,

4 21924

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

3 6291

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

Infosys,

2231

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

Sutherland,

1 8908

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

Amazon,

1 5128

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?

2680

Post New Database Management Questions

Un-Answered Questions { Database Management }

What are different partitioning techniques in database?

951

Explain concurrency transparency.

1094

How big is a big database?

939

What are the importance of partitioning in dbms?

1034

Explain the role of metadata for the three-layer architecture.

991

Who proposed the relational model?

1023

Which two can be implemented as a centrally located logical architecture?

974

What is executive plan?

975

When would you use a database?

973

What is a form used for in a database?

963

What is sql and where is it used?

994

What is primary key in database?

968

Can videos be stored in a database?

1013

What do you mean by fill factor concept with respect to indexes?

1016

Define database lock and its types.

1056

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