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,

1110

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

Amazon,

1133

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

Amazon,

1476

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

IBM,

1137

Un-Answered Questions { Databases }

What is postgresql client?

945

Your table has a large character field there are queries that use this field in their search clause what should you do?

885

explain the difference between delete , truncate and drop commands? : Sql dba

1093

List different types of locks in sybase?

982

What is a database in microsoft access?

864

Explain what is raid and what are different types of raid levels?

1027

Is ms access part of ms office?

966

How do I view a mysql database?

902

What are its two major subsystems of r?

1151

Is mysql case-sensitive?

888

Do you know what is replace and stuff function in sql server?

1014

what is the syntax used for partition in tsql? : Transact sql

1014

What does "i_am_a_dummy flag" do in mysql?

959

What is merge join?

1196

Explain what is log shipping?

1136

For More Un-Answered { Databases } Questions Click Here