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 are the different types of cursor?

HCL,

1096

How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?

Genpact,

2 3139

What is BLOCK statements in SQL?

HCL,

1263

Explain the difference between delete,drop and truncate in SQL Server?

HCL,

1099

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

HCL,

1058

What the difference between UNION and UNIONALL?

HCL,

1040

What is BCNF? How is it better than 2NF & 3NF?

Essar,

1017

Why I have to use stored procedures?

Cognizant,

1037

What is PROJECTION Operation?

Infosys,

1020

Where are SQL server users names and passwords are stored in sql server?

HCL,

1271

What is the importance of three tier architecture?

QuestPond,

1093

What is the difference between functions and scalar functions?

EXL,

1210

How to call a function from a stored procedure in SQL Server ?

HCL,

1029

What is 'Join' and explain its various types.

Genpact,

1136

What do you do in data exploration

EXL,

993

Un-Answered Questions { Databases }

How to throw custom exception in Stored Procedure?

1044

how to calculate the difference between two dates? : Sql dba

1062

Is mysql distributed?

926

Why is mongodb called mongodb?

What can be done with microsoft access?

772

In what situation u create the BPA.

2210

What are the different operators available in sql?

1000

Is access faster than excel?

774

Which environment variables are absolutely critical in order to run the OUI?

2118

What are the different types of database users?

572

How to connect to postgres database using pgadmin?

897

What are the advantages to use stored procedures?

1109

What are the differences between sql server and mysql.

1096

what is the option or command used in informix for finding which dbspace a database resides?

100

Explain the terms database and dbms?

916

For More Un-Answered { Databases } Questions Click Here