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

Where do you use decode and case statements?

1007

What is the difference between a hot backup and a cold backup in oracle?

1031

Describe the types of sub query?

1011

What are the attributes of the cursor?

1014

What is raw datatype in oracle?

1153

Briefly explain what is literal? Give an example where it can be used?

1062

Explain about the analyze command in oracle?

1062

Difference between cartesian join and cross join?

1060

Point the difference between translate and replace?

1103

What are the major difference between truncate and delete?

1072

What is a sub query? Describe its types?

1031

What is the difference between count (*), count (expression), count (distinct expression)?

1015

Point out the difference between user tables and data dictionary?

993

What do you mean by merge in oracle and how can you merge two tables?

962

Difference between the “verify” and “feedback” command?

1377

Un-Answered Questions { Databases }

Can you explain full-text query in sql server?

1024

What command is used to rename the database?

1026

How to change the name of a database user?

970

Describe different Processing Modes offered by SSRS?

256

What are the characteristics of dbms?

903

What are the types of rdbms?

914

Is mysql good for large database?

943

ABOUT IDENTITY?

2066

How do I edit a procedure in sql server?

970

what are cursors? : Sql server database administration

1075

What is executereader?

968

How to do transaction/locking in mongodb?

a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution

2275

How can you create and drop view in mysql?

941

What is indexing oracle sql?

1115

For More Un-Answered { Databases } Questions Click Here