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

Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1411)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

What is used to replicate sessions between instances in coldfusion clusters?

HCL,

1033

How to transfer a table from one schema to another?

MCN Solutions,

965

Write the queries for commands like Create Table, Delete table, Drop Table etc.

HPCL, Hughes Systique Corporation,

1055

What is the difference RDBMS and Graph Database?

EXL,

1020

do views contain data ?

MCN Solutions,

927

What is difference between global temporary tables and local temporary tables?

Tech Mahindra,

1193

What is trigger and different types of Triggers?

QuestPond,

1095

What are difference between Cluster index and Non-Cluster index?

QuestPond,

1037

How to delete duplicate records based on single column from a table?

Petranics Solutions,

1013

Which Model uses the SET concept

Infosys,

953

What are Row versions of DataRow?

995

What is data block and how to define data block size?

991

What is cursors?

NA,

1123

Can you get second highest salary from the table?

QuestPond,

931

What is the difference between a check constraint and a rule?

1180

Un-Answered Questions { Databases }

What is a crosstab query?

918

How do I modify a table in postgresql?

848

How do I stop a mysql service?

969

What are the features of Embedded SQL

1104

Consider you have the following three tables which have to be linked together.

867

Why is pl sql needed?

894

What area unit the various kinds of info compression introduced in sql server 2008?

1055

You are required to create a macro that can run action query. What steps will you take?

828

Where sql server user names and passwords are stored in sql server? : sql server database administration

1014

How to download oracle sql developer?

1070

Is it true that mongodb uses bson to represent document structure?

What is the sql 'in' clause?

915

what are null values? : Sql dba

915

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1556

What is the difference between flex mode and confined mode?

1010

For More Un-Answered { Databases } Questions Click Here