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

Explain overloading. Can functions be overloaded?

1012

Give the advantages and disadvantages of clusters.

1054

Define oracle database

1050

Explain oracle instance.

1187

What is ceil and floor in oracle?

1078

Can a parameter be passed to a cursor?

1138

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

1077

Explain user account with reference to oracle.

996

Explain constraining triggers.

1107

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

1090

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

1016

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

1030

Explain oracle’s system global area (sga).

1150

Differentiate between function and procedure in oracle.

1091

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

1066

Un-Answered Questions { Databases }

How do I partition in sql?

973

What are ddl (data definition language) statements for tables in ms sql server?

1114

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

1080

What is the difference between timestamp and datetime in mysql?

1059

What is a foreign key constraint why are such constraints important?

796

How to use go command in "sqlcmd"?

1219

What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

1056

Explain indexes disadvantages?

1102

How to define the name and server for a new dsn?

1133

What is a record in pl/sql?

1160

How would you improve throughput in sybase?

984

What is system global area (sga) in oracle?

1003

what are database files, control files and log files. How many of these files should a database have at least? Why?

878

What is shared lock?

909

What is the default size of master database in sybase?

925

For More Un-Answered { Databases } Questions Click Here