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,

1072

How to transfer a table from one schema to another?

MCN Solutions,

1001

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

HPCL, Hughes Systique Corporation,

1106

What is the difference RDBMS and Graph Database?

EXL,

1047

do views contain data ?

MCN Solutions,

968

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

Tech Mahindra,

1238

What is trigger and different types of Triggers?

QuestPond,

1143

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

QuestPond,

1079

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

Petranics Solutions,

1049

Which Model uses the SET concept

Infosys,

984

What are Row versions of DataRow?

1028

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

1026

What is cursors?

NA,

1186

Can you get second highest salary from the table?

QuestPond,

965

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

1249

Un-Answered Questions { Databases }

What is the purpose of update statistics and scope_identity() function?

1100

How to display the current date in sql?

1076

What is row_number function?

1006

How to insert multiple rows with one insert statement in ms sql server?

1122

Can a table have 2 foreign keys?

905

What is mysql vs sql?

982

Compare a hierarchical and network database model?

985

Why use triggers?

1014

Why mysql is used with php?

974

How to get nth highest salary from employee table.

1163

What is cypher neo4j?

What do you mean by exception log in replication?

1006

What is data modification?

973

What is anonymous block in sql?

1120

List the advantages of using stored procedures?

1052

For More Un-Answered { Databases } Questions Click Here