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 5650

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

CTS,

2640

how to implement locking in sql server

Satyam,

3 8902

What is the difference between a Application Server and a Database

Oracle,

3 13239

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

CTS, MCN Solutions, Oracle,

15 68530

What are the composite date types in oracle?

HCL,

6 18056

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

3 6580

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

4 10847

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 4319

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 5086

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

2148

which will fire first ? Trigger or Constraint

i2, IBM,

24 51484

how to use sequence and what use of sequence cache

1 4500

what is difference between where clause and having clause?

13 36601

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,

2038

Un-Answered Questions { Databases }

What is the purpose of the grep command?

2154

Can we join more than 2 tables in sql?

1042

How do access relationships work?

855

Mention what is the use of function "module procedure" in pl/sql?

1061

What is string data type in sql?

1160

Name and describe few console utilities for ssrs?

288

What are types of exception?

930

What is regexp?

1153

what are different types of backups available in sql server? : Sql server database administration

950

explain the difference between myisam static and myisam dynamic. : Sql dba

956

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 insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

2435

What is the function of having virtual internet protocol address (vip) in oracle rac?

How to execute the cursor queries with "open" statements?

1192

What are the key characteristics of rac or why to use rac?

What's the difference between a primary key and a clustered index?

999

For More Un-Answered { Databases } Questions Click Here