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 SQL?????????????????????????????

CMS,

5 8332

What is the Query to print out the individual total number of duplicate row in sql.

TCS,

5 11712

what is the index and synonym. i have the definitions ...can any one give me brief explanation.. with regards,

2095

How to display the hierarchy of employee and managers without using connect by prior.

1 3981

Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?

IBM,

2430

how to know the tables in database having foreign key?

2 4498

find the second highest salary of the emp table

6 8523

Difference between MYSQL_ASSOC,MYSQL_NUM and MYSQL_BOTH ?

TCS,

3 22142

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

HP,

1961

what is pragma ?

Polaris,

1 7063

A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?

Cognizant, IBM,

7 9857

What is the Query Optimizer. How you optimize your qeury.

Ericsson,

2 7261

what is an sql server?

1 4260

cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..

2 4976

find 2nd highest salary of person using cursor concept?

HCL,

6 11904

Un-Answered Questions { Databases }

Can you call pl/sql package functions from within a fast formula?

1042

Explain about the various features present in MS Access?

834

Explain a join?

1072

How to insert html code into mysql database using php?

1079

How do I run mysql without installing?

971

How to create primary/foreign key relationships in mongodb?

What is rac and what are the various benefits of using rac architecture?

What is stack builder?

835

How can we optimize a sql query?

1053

How does sharding work with replication in mongodb?

What is clause?

1156

Why functions are used in sql?

996

What are ddl statements in mysql?

1059

How to pass a cursor variable to a procedure?

1111

What is analyze command used for?

1078

For More Un-Answered { Databases } Questions Click Here