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

How to build data dictionary view an new database?

1009

How to get a create statement for an existing table?

969

How to pass parameters to procedures?

1034

How to use "in" parameter properly?

1071

How to run create database statement again?

1154

How to run queries on external tables?

1046

What privilege is needed for a user to delete rows from tables in another schema?

1066

How to rename a column in an existing table?

1035

How to view existing locks on the database?

1053

How much memory your 10g xe server is using?

1103

How to recover a dropped index?

1 1569

How to assign values to data fields in record variables?

1035

How to create a new table by selecting rows from another table?

1098

How to create tables for odbc connection testing?

1117

What is a named program unit?

1075

Un-Answered Questions { Databases }

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1087

A design problem was given in which I was supposed to make a design for the data base for a given problem.

1080

How can you hide the sql server instances?

1021

What happens on checkpoint?

1024

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

921

What is scd (slowly changing dimension)? : sql server analysis services, ssas

1008

Where is data stored in a database?

1001

How to pass a parameter to a cursor in oracle?

1178

What does specialization in DBMS mean?

1158

How many sql core licenses do I need?

944

What is pragma in pl sql?

1110

Define sql delete statement.

1012

What does set rowcount do?

909

How to make a column nullable?

1112

What do you understand by sub-queries in sql?

945

For More Un-Answered { Databases } Questions Click Here