Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3253)
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

Explain overloading. Can functions be overloaded?

1049

Give the advantages and disadvantages of clusters.

1103

Define oracle database

1102

Explain oracle instance.

1234

What is ceil and floor in oracle?

1124

Can a parameter be passed to a cursor?

1182

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1142

Explain user account with reference to oracle.

1031

Explain constraining triggers.

1167

What is the maximum limit on the number of columns in a table?

1159

Why do you create or replace procedures rather that drop and recreate.

1074

How would you change old and new values in an insert, delete and update triggers?

1082

Explain oracle’s system global area (sga).

1189

Differentiate between function and procedure in oracle.

1158

Give the constructs of a package, function or a procedure.

1098

Un-Answered Questions { Databases }

Where can you add custom error messages to sql server?

1170

What does pl sql stand for?

1158

What are the different types of constraints?

1285

What do you understand by the term 'system change number (scn)'?

641

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

1167

Who has the largest database?

1033

How to assign values to variables?

1168

What is general log in mysql?

1036

how do you know the version of your mysql server? : Sql dba

1051

What is a delimiter in sas?

1136

What is index in Oracle?

1133

How to define array in mongoose schema?

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

1211

How to use subqueries with the in operators in ms sql server?

1131

What is master database? : SQL Server Architecture

1086

For More Un-Answered { Databases } Questions Click Here