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 blob and clob?

967

Does insert statement lock the table?

956

What is blob storage?

999

What ascii 31?

981

Are stored procedures precompiled?

1002

What is dirty read and phantom read?

887

What does it mean to be case sensitive?

1017

Can foreign key have duplicate values?

902

Does adding an index lock a table?

973

What do ddl, dml, and dcl stand for?

923

How do I start sql server 2017?

952

What is in place upgrade in sql server?

1063

Can we shrink data file in sql server?

1065

What is the difference between upgrade and migration in sql server?

1104

What is sql server query analyzer?

1046

Un-Answered Questions { Databases }

Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?

1127

What is mysql cursor?

904

How many sql statements are used?

1034

what is try_catch block in procedure

1767

How do I start sql server agent automatically?

984

what do u mean by canvases and alerts?

2023

Explain isolation levels. : Transact sql

1079

Difference between pre-select and pre-query

1124

Can't connect mysql server on localhost?

1081

How do I set a primary key in access 2007?

794

When cursors are useful?

1127

What is local database?

990

Is sql open source?

982

What do you mean by index hunting?

1115

Is left join faster than inner join?

1141

For More Un-Answered { Databases } Questions Click Here