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 we use decode and case statements?

1030

How can we find out the duplicate values in an oracle table?

1064

What is the difference between truncate & delete command?

1196

How will you identify oracle database software release?

1023

What are the attributes that are found in a cursor?

1096

What do you understand by a database object? Can you list a few of them?

1034

What is a nvl function?

1052

Why do we use coalesce function in oracle?

1138

What is the quickest way to fetch the data from a table?

1075

How translate command is different from replace?

1103

How will you differentiate between varchar & varchar2?

1052

What are the set operators union, union all, minus & intersect meant to do?

1000

What is a nvl function? How can it be used?

1049

What is the use of aggregate functions in oracle?

1039

What do you mean by a database transaction & what all tcl statements are available in oracle?

1007

Un-Answered Questions { Databases }

Is mongodb support null values?

How to select 10 records from a table?

1171

Write a SQL query in order to merge two different columns into single column?

1048

What is the meaning of disabling a trigger?

1192

Does sql backup shrink transaction log?

989

Explain about SQLOS?

1021

How do you handle datasets larger than 50 gb?

162

What is the relation of a user account and a schema in oracle?

1097

What are different relationships existing in database?

1014

Write a query to find the names of users that begin with "um" in sql?

1013

Can we create table in function?

974

How can change procedure in sql server?

1081

Who bought mongodb?

What is PL/SQL Records?

1203

How do I change my passwords (database, LDAP, and so on) without causing an outage?

1082

For More Un-Answered { Databases } Questions Click Here