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

How to add code to the existing article (using improve article)?

1129

Explain about link server in sql server?

1073

If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?

1 2070

What is the difference between delete and truncate statements?

1096

Explain foreign key in sql server?

1043

What is a field in a table?

1050

What are a scheduled jobs or what is a scheduled tasks?

917

List the different types of joins?

1032

What is the difference between char and varchar2 datatype in sql?

1085

What are entities and relationships?

991

What is the difference between dropping a database and taking a database offline?

1188

How can we remove orphan records from a table?

1006

What do you mean by recursive stored procedure?

963

What structure can you implement for the database to speed up table reads?

1213

What are the acid properties?

1025

Un-Answered Questions { Databases }

What is the rdl file?

141

Explain snapshot replication.

981

how to connect a php script with the mysql database?

1069

What are the types of variable use in pl sql?

1095

How to test for null values?

1062

Is mongodb distributed database?

What is the difference between view and stored procedure?

976

How check triggers in sql server?

1016

Which operator is used in query for pattern matching?

1107

‘Order by’ is not allowed in a view how can you sort information from a view?

1098

What is trigger in flip flop?

1027

for what purpose we use MDM(master data management)tell me plz.

4191

Is there any difference between the primary key and unique key?

1022

How to assign new column names in a view?

935

What is difference between cursor and trigger?

1087

For More Un-Answered { Databases } Questions Click Here