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,

1062

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

Amazon,

1100

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

Amazon,

1425

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

IBM,

1096

Un-Answered Questions { Databases }

what is the difference between blob and text? : Sql dba

978

Is record in oracle pl sql?

917

Explain triggers?

964

how to avoid cursors? : Sql server database administration

928

In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

1256

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2731

How to use "for" statements in oracle?

1037

What is t-sql script to take database offline – take database online.

1036

State a few properties of relational databases?

1080

Can foreign key be deleted?

886

How do I sort a table in sql?

995

Where is mysql data stored linux?

954

What is explicit cursors?

1006

Explain the advantages of rdbms?

888

Explain about the analyze command in oracle?

1014

For More Un-Answered { Databases } Questions Click Here