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

6 8520

what is the syntax of INSERT command?

7 10767

what is the syntax of UPDATE command?

8 12629

what is the syntax of DELETE command?

8 12138

what is the syntax of CREATE command?

8 10677

what is the syntax of DROP command?

10 13855

what is the syntax of ALTER command?

8 14379

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 7044

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 8956

check whether all the emp numbers are indeed unique.

6 17878

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 12436

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

5 10735

Delete duplicate records in the emp table.

Oracle,

6 15050

What is magic table?

6 24802

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

IBM,

23 38708

Un-Answered Questions { Databases }

How show all rows in sql?

1062

Is mysql server free?

983

what are tables and fields? : Sql dba

1110

Is sql procedural language?

1015

What is a trace frag?

1141

What is match command? Where is it used in neo4j?

What are different types of indexes?

1058

How can sql injection be stopped? : sql server security

1113

How I can use srw.run_report in reports6i?

Is a primary key unique?

1041

what are enums used for in mysql? : Sql dba

1235

Explain the different types of constraints in dbms?

1077

5. Explain about relational algebra.

2238

Why is replication required on the sql server?

1113

What is data model example?

1133

For More Un-Answered { Databases } Questions Click Here