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

2242

Explain the Normalized Relations?

2700

what is the difference between inline query and corelated subquery

1 4484

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

2595

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 5848

select Nth highest salary by using rownum

Ford, TCS, Tech Mahindra,

4 21768

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 8817

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

Amazon,

1 5043

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?

2620

Post New Database Management Questions

Un-Answered Questions { Database Management }

What are the features of a database management system?

934

Describe why operational and informational systems are separate.

950

What is record in a database?

864

What are the limitations of database?

896

What versions of clipper does netlib support?

1003

Why is normalisation used?

919

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

923

How to schedule ssas database backup

995

Why does reading require write privileges on database file?

890

What is the main purpose of a database?

926

What is bcnf in the dbms?

939

How to retrive a single data from a database

1193

Differentiate between ‘delete’, ‘truncate’ and ‘drop’ commands.

1155

What do you understand by join?

1096

Enlist the types of cursor?

966

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