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

Mention the uses of stored procedures.

974

What is the difference between left and right outer join?

1071

Explain the commands in sql server?

1043

Write an sql query for deleting duplicate rows?

1002

What is difference between clustered index and non clustered index?

1080

Write query to return all rows sql?

1062

What is difference between foreign key and unique key?

1017

State the difference between union and union all?

934

What do you understand by recursive stored procedures?

995

What are the different types of nosql databases? Give some examples.

What do you mean by a replica set in mongodb?

Write the syntax for creating a collection and dropping a collection in mongodb.

List some alternatives to mongodb?

List the important features of mongodb.

What is the use of a namespace in mongodb?

Un-Answered Questions { Databases }

What is server replication?

996

Which part of the RDBMS takes care of the data dictionary? How

1014

what is rcp,if rcp disabled what happen?

2219

Why are sql functions used?

1124

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

2270

What is mysqli_connect_error ()?

1034

You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?

599

Is sql server implemented as a service or an application? : Sql server database administration

971

How do we use % when performing a search query?

919

How do you create an update query?

966

Can we commit inside a function in oracle?

968

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1216

What is the most common database language that a db administrator needs to know?

578

Define magic tables in sql server?

1071

define join and explain different type of joins? : Sql dba

955

For More Un-Answered { Databases } Questions Click Here