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 the bitmap index?

3 6974

explain about the critical recovery scenario you had experienced

2245

I am working in Oracle Clinical 4.5.1 Please explain a bit.How to create Views in OC

Icon,

4 9945

You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

2165

can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com

IBM, Symphony,

28 32891

What is differance unique key and primary key.

EDS,

7 11709

as a technical developer in oracle applications which type errors feced in your experience sofar

HCL,

2341

can we use lexical perameter in oracle plsql if yes how

2333

as a technical developer in oracle applications which type errors feced in your experience sofar

HCL,

2204

what is the difference between DBMS and RDBMS??

Aon Hewitt, BlackRock, Infosys, ISB, Jawood, TCS,

76 202983

How you find out version of installed workflow?

1 4913

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then when no_data_found then when too_many_rows then end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

Satyam,

3 8946

how many triggers we can create on a table

G2 Technology, TCS,

11 52373

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

2084

1> how are u debugging in plsql ? 2> how to connect oracle database from unix. is there ne way other than using sqlplus ?

2 8838

Un-Answered Questions { Databases }

What is the maximum size of table in mysql?

1042

What do you mean by sql server 2005 express management tools?

1327

What is view dbms?

938

How can you determine what protocol is being used for interconnect traffic?

what are the t string functions available in tsql? : Transact sql

1037

What is hypermedia database?

819

Give an example of why you would want to denormalize a database

994

Can I use a named pipe to bcp/dump data out or in in sybase?

1021

What is difference between database and dbms?

1014

Explain transaction server auto commit?

1052

How do I find the port number for sql server?

986

Explain the microsoft sql server delete command?

1035

What is the difference between a subquery and a join?

1123

What is the difference between left and right outer join?

1081

Give the order of sql select?

1159

For More Un-Answered { Databases } Questions Click Here