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

Show the two pl/sql cursor exceptions.

1203

Explain raise_application_error.

1108

Show how functions and procedures are called in a pl/sql block.

1136

What operators deal with null?

1111

What are character functions?

1094

What are the two types of exceptions.

1180

What are instead of triggers?

1050

What is the meaning of disabling a trigger?

1187

What is the difference between database trigger and stored procedure?

1081

difference between anonymous blocks and sub-programs.

1143

Explain the uses of control file.

1053

How can the performance of a trigger be improved?

1050

How can you view the errors encountered in a trigger?

968

Explain autonomous transaction.

1163

Can a view be mutating? If yes, then how?

1035

Un-Answered Questions { Databases }

What are the advantages to use stored procedures?

1118

What are the features of rdbms?

863

What is write concern in mongodb?

How to create median function?

166

What are database states in ms sql server?

1187

What are sql servers used for?

1054

Which is the latest version of sql server and when it is released?

1118

What is difference between group by and having?

951

What kind of database is mongodb?

Is sql dba a good career? : SQL DBA

1001

What is database client?

1010

What are the different windows events activated at runtime ?

2907

Explain oracle instance.

1187

How to update operations immediately sync to disk in mongodb?

How do you install statspack?

694

For More Un-Answered { Databases } Questions Click Here