Databases AllOther Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Databases AllOther Interview Questions

Questions Answers Views Company eMail

After normalization, what are the conditions which have to keep in mind to de-normalize it?

C DAC, CDAC,

1050

Explain normalization in one line?

C DAC, CDAC,

1095

Give the syntax of exception handling used in DBMS?

C DAC, CDAC,

1199

What are different types of blocks used in stored procedure?

C DAC, CDAC,

1131

What are different types of clusters present?

C DAC, CDAC,

1079

What is the difference between a stored procedure and a query?

C DAC, CDAC,

1091

Differentiate between unique key and foreign key?

CGI,

1011

How do you pass parameter in stored procedure?

CGI,

1208

What are indexes in oracle?

CGI,

1090

What is the relationship that exists inside in E-R diagram?

CGI,

1095

Write a query to get maximum and second maximum in oracle?

CGI,

1048

Write a query to retrieve for many to many relationships?

CGI,

1005

How to produce such kind of file?

Tech Mahindra,

1107

What is a trace file?

Tech Mahindra,

1074

What is the purpose of TNS?

Tech Mahindra,

1031

Post New Databases AllOther Questions

Un-Answered Questions { Databases AllOther }

What do you mean by database?

1080

WHAT IS NEED BY METION DATFMT AND TIMFMT IN H-SEPICITION IN RPGLE?

2971

What is a super key?

1039

What are the types of indexes that are present inside a database?

1127

Which three commands cause a transaction to end?

1066

On startup, the transaction log of a database has filled and recovery has suspended, what can I do?

994

Should I store images in database?

1032

Explain entity type?

992

Write a query to get maximum and second maximum in oracle?

1048

Why merge statement is used inside the database?

1099

Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it

2417

Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.

1895

List various types of log-based recovery in DBMS.

988

Difference between sql and mysql?

2092

what is ad-hoc access? what is the diff b/w managed query and ad-hoc access?

2312

For More Un-Answered { Databases AllOther } Questions Click Here