Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3253)
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 7089

explain about the critical recovery scenario you had experienced

2331

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

Icon,

4 10065

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?

2190

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

IBM, Symphony,

28 33706

What is differance unique key and primary key.

EDS,

7 11901

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

HCL,

2382

can we use lexical perameter in oracle plsql if yes how

2378

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

HCL,

2239

what is the difference between DBMS and RDBMS??

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

76 204828

How you find out version of installed workflow?

1 4967

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 9069

how many triggers we can create on a table

G2 Technology, TCS,

11 52657

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

2129

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

2 8933

Un-Answered Questions { Databases }

what is the difference between myisam static and myisam dynamic? : Sql dba

1122

What is the dynamic sql in oracle?

1141

What are the limitations of microsoft access?

961

What encryption security is available in sql azure?

101

What is sql server locking?

1038

What are rows and columns?

1074

System requirements for sql server 2005 express edition?

1082

Is mysql and sql are same?

1159

What is the role of database management system?

991

Difference between case & decode?

729

Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?

666

How to avoid duplicate entries in the forms?

What does (*) mean in sql?

1005

How to do paging with oracle?

1058

What is a query?

933

For More Un-Answered { Databases } Questions Click Here