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 8553

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

TCS,

5 11943

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

1 2146

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

1 4070

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,

1 2476

how to know the tables in database having foreign key?

2 4619

find the second highest salary of the emp table

6 8736

Difference between MYSQL_ASSOC,MYSQL_NUM and MYSQL_BOTH ?

TCS,

3 22313

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

HP,

1 2024

what is pragma ?

Polaris,

1 7145

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 10164

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

Ericsson,

2 7397

what is an sql server?

1 4362

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

2 5079

find 2nd highest salary of person using cursor concept?

HCL,

6 12151

Un-Answered Questions { Databases }

What are the different SQL Server Versions you have worked on?

1071

How to connect php with different port numbers?

1159

Suppose database is running slow, what will you do?

2580

Have you created fact table and dimension tables?

694

What are the types of database explain each of them briefly?

1038

What is the current mysql version?

1082

Does group by remove duplicates?

1099

what is schema? : Sql dba

1124

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1177

What is the best sql course?

1031

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1118

What is the difference between case version and decode version?

1091

What is your daily office routine?

2329

How do I remove duplicates in two columns?

1162

Why we use the openxml clause?

1059

For More Un-Answered { Databases } Questions Click Here