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 is store procedure?and how do u take the values from database and run in scripts?

Polaris,

2 5632

how can db_files > maxdatafiles since db_files is for instance and the later is for database

CTS,

2630

how to implement locking in sql server

Satyam,

3 8883

What is the difference between a Application Server and a Database

Oracle,

3 13224

What is the difference between 2-Tier architecture and 3-Tier architecture

CTS, MCN Solutions, Oracle,

15 68456

What are the composite date types in oracle?

HCL,

6 18032

Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table

3 6563

if i perform any operation on views such as insert, delete etc will my base table get affected?????

4 10824

in reports 1og.if we enter a query in list of values then parameter form displays a dropdown.in that if any ething is selected then that will display in the report.supp if i am not selected any value then it should display all the values.how it is possible?can any one help me........

1 4308

HI in report builder am creating paramters.for that i have taken emp table from scott user . in deptnum am displaying distinct deptno.if i select dept 10 ,empnum drop down should display empno's of deptno 10. .if i select dept 20 ,empnum drop down should display empno's of deptno 20.for this wat i have to do.

2 5075

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2141

which will fire first ? Trigger or Constraint

i2, IBM,

24 51398

how to use sequence and what use of sequence cache

1 4489

what is difference between where clause and having clause?

13 36528

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

Covansys,

2033

Un-Answered Questions { Databases }

What are the difference between now and current_date in mysql?

1445

What is usually the first word in a sql query?

1141

what is a chunk in informix ?

123

What program will open a mdb file?

972

What is 1nf in database?

1001

How to turn on or off recycle bin for the instance?

1089

What is the usage of profiler in mongodb?

What is rank function?

1041

What are different types of receipt reversals ? Explain them : oracle accounts receivable

1267

If a ‘movechunk’ fails, is it necessary to cleanup the partially moved docs?

Explain the difference between mysql and mysql interfaces in php?

1101

Is sql port 1433 encrypted?

1033

What type of database is postgres?

795

Define Joins?

1037

Where does mongodb store data linux?

For More Un-Answered { Databases } Questions Click Here