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

CMS,

5 8530

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

TCS,

5 11909

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

2142

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

1 4064

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,

2473

how to know the tables in database having foreign key?

2 4592

find the second highest salary of the emp table

6 8704

Difference between MYSQL_ASSOC,MYSQL_NUM and MYSQL_BOTH ?

TCS,

3 22299

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

HP,

2021

what is pragma ?

Polaris,

1 7138

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 10108

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

Ericsson,

2 7372

what is an sql server?

1 4348

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

2 5073

find 2nd highest salary of person using cursor concept?

HCL,

6 12125

Un-Answered Questions { Databases }

What is instance in dbms?

927

Can you have more than one content canvas view attached with a window ?

2374

What are the disadvantages of using microsoft access?

1109

Explain the difference between sap and oracle?

1088

What are the various type of relations between different data?

799

What is scope and visibility in PL/SQL?

1293

How to compute database fragmentation in sybase?

949

What is an oracle stored procedure?

1117

What is a sql join?

1085

What does mysql_query return?

1114

How to use subqueries in the from clause in ms sql server?

1215

How to get nth highest salary from employee table.

1213

List different datatypes of postgresql?

865

Explain cdc and sql injection?

1046

What are the source of constraints?

985

For More Un-Answered { Databases } Questions Click Here