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

Oracle (3253)
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 sql server? : Sql server database administration

1046

what is denormalization? : Sql server database administration

975

can you instantiate a com object by using t-sql? : Sql server database administration

1047

explain different types of joins? : Sql server database administration

1037

what is a deadlock? : Sql server database administration

1150

what is blocking? : Sql server database administration

1092

explain different types of constraints? : Sql server database administration

1004

what is a join and explain different types of joins? : Sql server database administration

1013

what protocol both networks use? : Sql server database administration

1021

what changed between the previous version of sql server and the current version? : Sql server database administration

1057

Is sql server implemented as a service or an application? : Sql server database administration

999

explain different types of cursors? : Sql server database administration

1150

Do you know the cursor optimization tips?

1039

Explain temporary table vs table variable by using cursor alternative?

1055

Can you explain the disadvantages/limitation of the cursor?

1059

Un-Answered Questions { Databases }

What are the 2 types of classifications of constraints in the sql server?

1184

Explain the use of rows option in imp command.

1143

What are the advantages of using microsoft access?

1116

What are the roles and responsibilities of oracle dba?

704

How many categories of functions based their return modes?

1154

What are the types of containers in ssis?

1242

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1966

What are the differences between a primary key and foreign key?

1167

What are the difference between mongodb and mysql?

1420

When we should use and scope of @@identity?

1052

Can we write dml inside a function in sql server?

1005

Can sql server be linked with other servers like oracle?

1024

what is cte? : Mysql dba

1000

Explain the different normalization forms?

1161

Explain the flow of creating a cube? : sql server analysis services, ssas

1104

For More Un-Answered { Databases } Questions Click Here