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

Databases AllOther Interview Questions

Questions Answers Views Company eMail

What is a Database?

1 1768

What is a Transformation?

Informatica,

1025

What advantages does DBMS have over traditional file systems?

ABB, Infogain,

1035

Explain inner and outer joins with examples.

Agilent,

1176

Explain various types of locks in a transaction? Which is better and why?

Agilent,

1035

A design problem was given in which I was supposed to make a design for the data base for a given problem.

Motorola,

1081

Explain database partitioning. What is its importance?

1198

Explain phantom deadlock?

1234

What is the importance of database partitioning?

1061

Explain the table term used in database.

1037

What do you mean by database?

1080

Explain artificial key?

1172

Differentiate between extension & intension?

1426

Differentiate between delete and truncate table?

1055

What is table scan and index scan?

1122

Post New Databases AllOther Questions

Un-Answered Questions { Databases AllOther }

can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?

2112

What is database server and how it works?

1044

What are the concurrency problems a database faces?

1039

what is rcp,if rcp disabled what happen?

2218

Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?

2510

What is the difference between primary and candidate key?

1127

Why merge statement is used inside the database?

1099

How to shrink a database?

979

Explain buffer manager?

952

What are the tools used for backup and ticketing?

998

Display the employees whose salary is less than average salary.

1066

What is ole db used for?

1014

Is redis in memory database?

1000

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

What is the candidate key used for?

1093

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