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

Where do we use decode and case statements?

1063

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

1127

What is the difference between truncate & delete command?

1238

How will you identify oracle database software release?

1060

What are the attributes that are found in a cursor?

1126

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

1068

What is a nvl function?

1097

Why do we use coalesce function in oracle?

1169

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

1104

How translate command is different from replace?

1144

How will you differentiate between varchar & varchar2?

1090

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

1038

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

1102

What is the use of aggregate functions in oracle?

1077

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

1042

Un-Answered Questions { Databases }

What are the rules to use the rowguidcol property to define a globally unique identifier column?

1079

i made a table whih contain a column "Photo" with image data type and i want to insert the byte of a picture present in my hardisk using insert statement in that colum... so what will be my insert statement?

2658

what is data control language? : Sql dba

1071

Under which circumstance should you create an index on a table?

1239

suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

2066

What are the database objects? : SQL Server Architecture

1098

What is CDC and explain complete CDC process flow?

641

What is sql key?

1049

What are logical database components? : SQL Server Architecture

1101

Can you import Microsoft Excel data to SSRS?

135

Explain the microsoft sql server delete command? : sql server architect

852

What are the steps to follow to configure SQL*Net?

1080

What specific conditions database should meet, before you can bulk copy data into it using bcp?

1047

Can we add a cpu to sql server?

1069

What is the job of the information stored in data-dictionary?

855

For More Un-Answered { Databases } Questions Click Here