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,

1474

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 a canvas in oracle forms?

1066

What are the benefits of ordbms?

1088

What is a database connection string?

1120

What is shared buffer in postgres?

783

How to create a large table with random data for index testing in ms sql server?

1031

Explain the insert into statements in sql?

1005

What is a primary key?

952

Is nosql faster than sql?

1023

What is the most restrictive isolation level? : Transact sql

1083

How to manually drop a table in sybase?

1016

Is the primary key column of a table an index in ms sql server?

962

You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?

794

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2521

What are key constraints?

972

What does postgresql mean?

839

For More Un-Answered { Databases } Questions Click Here