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 8361

what is the syntax of INSERT command?

7 10591

what is the syntax of UPDATE command?

8 12421

what is the syntax of DELETE command?

8 11937

what is the syntax of CREATE command?

8 10481

what is the syntax of DROP command?

10 13612

what is the syntax of ALTER command?

8 14178

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 6959

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 8828

check whether all the emp numbers are indeed unique.

6 17737

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 12318

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

5 10599

Delete duplicate records in the emp table.

Oracle,

6 14874

What is magic table?

6 24645

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

IBM,

23 38089

Un-Answered Questions { Databases }

Where are stored procedures in sql server?

1084

How do you create a database in access 2010?

858

What is substitution variable?

1067

What is the difference between clustered and non-clustered indexes in ms sql server?

1019

What are the disadvantage in file processing system?

993

Which operator is used in query for pattern matching?

1103

Do models have limitations?

904

Write a query to fetch duplicate records from a table using mysql?

947

For what Neo4j is widely used for?

What do you mean by asa in sybase?

1006

What is the guest user account in sql server? What login is it mapped to it? : sql server security

1083

How do I automate a backup in mysql?

1002

What are inner and outer joins examples of both?

981

Explain what is sql*plus?

1162

ABOUT IDENTITY?

2071

For More Un-Answered { Databases } Questions Click Here