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 advantages fo Stored Procedures?

1 3234

What are the uses of Database Trigger ?

1720

What is Database Trigger ?

1 3018

Can the default values be assigned to actual parameters?

1 2708

Can a primary key contain more than one columns?

2 3756

What is an UTL_FILE.What are different procedures and functions associated with it?

1 3400

Differentiate between TRUNCATE and DELETE?

2 3049

What is difference between a formal and an actual parameter?

1 2680

What should be the return type for a cursor variable.Can we use a scalar data type as return type?

1 2662

What are different Oracle database objects?

1 2670

What is difference between SUBSTR and INSTR?

1 3033

Display the number value in Words?

1 3093

What is difference between SQL and SQL*PLUS?

1 2952

What are various joins used while writing SUBQUERIES?

2 4017

What a SELECT FOR UPDATE cursor represent.?

1 2911

Un-Answered Questions { Databases }

What is difference between server and database?

1091

What is the function of cache fusion in oracle rac?

What is bulk collect in oracle?

996

what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba

1081

What do you mean by subquery?

1087

What is scrollable cursor?

1041

What is the filtered index?

1058

What is write ahead logging in postgresql?

856

how to convert character strings to dates? : Sql dba

1060

What is use of except clause?

1092

What are the basic functions for master, msdb, model, tempdb and resource databases?

987

Is truncate ddl or dml?

991

What happens if null values are involved in boolean operations?

987

What can I use instead of microsoft access?

905

List the ways to get the count of records in a table?

900

For More Un-Answered { Databases } Questions Click Here