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 are the differences between union, intersect, and minus operators?

1101

Explain the properties of a relational table?

1047

Can we store videos inside the sql server table?

998

How can you fetch alternate records from a table?

979

What do you mean by table and field in sql?

1035

What are the differences between left join and inner join in sql server?

1122

What is the sql case statement used for?

1116

How sql server executes a statement with nested subqueries?

1051

What is the sql case statement used for? Explain with an example?

1021

Explain how to send email from sql database?

1073

What are the different authentication modes in sql server?

1138

Can sql servers link to other servers?

1110

Describe how to use the linked server?

1169

What are transactions in sql?

1085

Explain the third normal form(3nf)?

959

Un-Answered Questions { Databases }

How do I clear the screen in mysql?

1022

How many types of primary keys are there?

1051

Define Joins?

1044

Explain datetime2 data type in sal server 2008?

927

What are the authentication modes in sql server? How can it be changed?

1140

Can mongodb scale?

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1142

What is split brain syndrome in rac?

What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?

589

What is mysql and mysqli?

941

How you can add messages to the nt event log from within a stored procedure?

1096

List some of the products of sybase.

893

Explain the method to debug errors in an oracle application.

What are the vital features of sybase?

872

How ms access is better than ms sql server?

867

For More Un-Answered { Databases } Questions Click Here