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

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

Oracle,

1162

Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.

Amazon,

1206

Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.

Amazon,

1539

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

IBM,

1195

Un-Answered Questions { Databases }

Explain the hierarchical database?

1056

What is a join in the sql?

1046

What are the main differences between the two?

937

what is the difference between between and in operators in mysql?

1078

Explain what is lock escalation and what is its purpose?

987

How are queries run in ms access? List different ways.

816

Explain triggers in sql?

1005

what is data manipulation language? : Sql dba

1071

How to list all objects in a given schema?

1110

Can we enter data in a table in design view?

1014

What do you mean by DBMS?

1020

How to include numeric values in sql statements?

1061

Can we rename database in mysql?

1002

What is the difference between clustered index and primary key?

975

What is sybase ?

975

For More Un-Answered { Databases } Questions Click Here