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 8597

what is the syntax of INSERT command?

7 10843

what is the syntax of UPDATE command?

8 12753

what is the syntax of DELETE command?

8 12246

what is the syntax of CREATE command?

8 10802

what is the syntax of DROP command?

10 13983

what is the syntax of ALTER command?

8 14463

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 7094

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 9047

check whether all the emp numbers are indeed unique.

6 17959

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 12512

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

5 10801

Delete duplicate records in the emp table.

Oracle,

6 15123

What is magic table?

6 24867

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

IBM,

23 39095

Un-Answered Questions { Databases }

Any work done in oracle workflow builder. Did you customize or build a new workflow?

Design database draw er diagram for a certain scenario ?

4648

Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:

2308

Is primary key clustered index?

1016

What is a view in sql?

1035

How to Change a users password from unix shell.

1213

what is schema? : Sql dba

1137

How do I create a trace in sql server?

1112

How do I find the sql server version?

1099

How to provide default values to function parameters?

1250

How to write a left outer join with the where clause in oracle?

1149

What are the source of constraints?

1006

Why should you use or avoid select * statements?

1106

Equi join and non equi join is possible with sql server?

1128

Does view occupy space?

1006

For More Un-Answered { Databases } Questions Click Here