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

What is the order of sql select?

1054

What is the difference between union and union all command?

1102

What are the possible values that can be stored in a boolean data field?

1015

How to avoid duplicate records in a query?

1021

How to rename a column in the output of sql query?

1086

What are the types of dbms?

987

Describe sql comments?

1054

What is a record in a database?

1075

How to display the current date in sql?

1093

How to get list of all tables from a database?

1171

Can a table contain multiple foreign key’s?

1019

How to rename a table?

1049

What is sql not null constraint?

1053

What is the difference between nvl function, ifnull function, and isnull function?

1125

How to add a column ‘salary’ to a table employee_details?

1024

Un-Answered Questions { Databases }

1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used?

2016

What is informix sql?

987

Explain about system stored procedure?

1049

I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage

1562

How to create a stored procedure in oracle?

1121

What if we write return in procedure?

1448

What are the differences between implicit and explicit cursors?

1080

What are the four objects in microsoft access?

923

What are the functions of mysql?

951

What is called dbms?

1071

How can we call UDF(User Define Function) using C# code in ASP.net ?

6903

What is Set-at-a-time or Set-oriented?

918

To which devices can a backup be created and where should these devices be located? : sql server management studio

1066

How to rename an existing column with sql server management studio?

1013

Is oracle an operator?

944

For More Un-Answered { Databases } Questions Click Here