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 the syntax of SELECT command?

6 8321

what is the syntax of INSERT command?

7 10523

what is the syntax of UPDATE command?

8 12345

what is the syntax of DELETE command?

8 11860

what is the syntax of CREATE command?

8 10415

what is the syntax of DROP command?

10 13534

what is the syntax of ALTER command?

8 14096

Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?

2 6928

Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?

4 8778

check whether all the emp numbers are indeed unique.

6 17682

define a variable representing the expression used to calculate on emps total annual remuneration.use the variable in a statement which finds all emps who can earn 30000 a year or more.

5 12267

Delete the emps whose salaries are lowest sals of their own dept.

5 10545

Delete duplicate records in the emp table.

Oracle,

6 14810

What is magic table?

6 24603

how to check the 3rd max salary from an employee table?

IBM,

23 37863

Un-Answered Questions { Databases }

Explain locks? : Transact sql

1005

How do I create a collection in mongodb? Write it's syntax

What is authorization and integrity manager?

973

What is equi join in sql?

1073

How to create a simple query in ms access 2013?

802

What is data profiling in sql?

1077

What is sql clause?

1048

How to set the current database in ms sql server?

1081

Is mongodb support null values?

What is a view and how is it different from a table?

1045

Please explain drop constraint oracle?

1105

What will cause the size of a stored procedure to grow in sybase?

818

What mean sql?

1009

Explain the Surrogate Key in DBMS.

955

How do I start postgresql?

882

For More Un-Answered { Databases } Questions Click Here