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 8316

what is the syntax of INSERT command?

7 10523

what is the syntax of UPDATE command?

8 12337

what is the syntax of DELETE command?

8 11854

what is the syntax of CREATE command?

8 10407

what is the syntax of DROP command?

10 13524

what is the syntax of ALTER command?

8 14093

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 6927

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 8773

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 12263

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

5 10544

Delete duplicate records in the emp table.

Oracle,

6 14809

What is magic table?

6 24602

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

IBM,

23 37850

Un-Answered Questions { Databases }

What are transactions in sql?

1060

What is the difference between 'dump tran database to physical name' 'dump tran database with truncate_only' and dump tran database with no_log'and in real time when we go to truncate the log?

892

What do you understand by hotfixes and patches in sql server?

991

How to disable stored procedure sql server?

1606

How to enter binary numbers in sql statements?

972

How you can create a simple query in access 2013?

827

how to rename an existing column in a table? : Sql dba

1018

What is difference between table aliases and column aliases? Do they affect performance?

963

What is sql server english query?

1125

How do I use microsoft access with excel?

893

What is a database access?

903

What is sql constant?

1031

What is RDBMS KERNEL?

1080

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1066

in the package one interface got failed how to know which interface got failed if we no access to operator?

608

For More Un-Answered { Databases } Questions Click Here