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

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

1114

what is a relationship and what are they? : Sql dba

1128

what is data integrity? : Sql dba

1051

what is the command used to fetch first 5 characters of the string? : Sql dba

1647

how to drop an existing view in mysql? : Sql dba

1081

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

1080

what are date and time intervals? : Sql dba

1068

what is the difference between a local and a global temporary table? : Sql dba

1094

how to drop an existing table in mysql? : Sql dba

1067

what is a cursor? : Sql dba

1039

what is the difference between char_length and length? : Sql dba

1068

what are enums used for in mysql? : Sql dba

1202

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1107

what is the difference between a web-garden and a web-farm? : Sql dba

1104

what is a composite primary key ? : Sql dba

1073

Un-Answered Questions { Databases }

What is meant by postgresql?

815

How many byte Unique integers does OIDs in PostgreSQL have?

1323

What is the difference between clustered index and primary key?

938

What are the steps you must follow to hide sql server instances?

1001

How do I run a sql query?

1051

List the data types available in mssql?

1056

What is the difference among union, minus and intersect?

1016

What is an advantage of a database?

1070

How do you add a column?

867

Explain aggregate functions are available there in sql?

1022

How to find related tables in sql server?

969

What is the ‘fillfactor’?

984

How to get @@error and @@rowcount at the same time?

1053

Can we connect to postgresql using sql developer?

1031

How to deploy the Report?

140

For More Un-Answered { Databases } Questions Click Here