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 case function?

1042

How many row comparison operators are used while working with a subquery?

1030

What are the 3 modes of parameter?

1154

Is it possible for a table to have more than one foreign key?

1030

Explain the difference between rename and alias?

1010

What do you mean by rowid?

980

Explain dml and ddl?

996

What is the primary key?

952

How to select all records from the table?

1136

How to write a query to show the details of a student from students table whose

1000

List different type of expressions with the example.

935

Define join and name different types of joins?

1008

What do we need to check in database testing?

1018

How we can update the view?

1049

How do we use distinct statement? What is its use?

1032

Un-Answered Questions { Databases }

what is grd?

1097

Why do we use subquery?

1015

How do you use a while loop in pl sql?

1014

What is the purpose of data source?

1040

What is a Database?

1771

Between different data’s, what are the types of relationship can be formed?

1022

Which dbms is best?

913

How to generate create procedure script on an existing stored procedure?

1011

How to fetch the row which has the max value for a column?

1002

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

2399

Explain the use of containers in ssis?

967

What is a schema in oracle?

1014

Explain the Normalized Relations?

2703

What is use of except clause? How does it differ from not in clause?

1020

Is mongodb relational database?

For More Un-Answered { Databases } Questions Click Here