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 6958

explain about the critical recovery scenario you had experienced

2228

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

Icon,

4 9916

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?

2154

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

IBM, Symphony,

28 32723

What is differance unique key and primary key.

EDS,

7 11648

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

HCL,

2334

can we use lexical perameter in oracle plsql if yes how

2316

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

HCL,

2192

what is the difference between DBMS and RDBMS??

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

76 202488

How you find out version of installed workflow?

1 4902

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 8914

how many triggers we can create on a table

G2 Technology, TCS,

11 52314

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

2078

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

2 8813

Un-Answered Questions { Databases }

How a database is related to tablespaces?

1039

Can triggers stop a dml statement from executing on a table?

1107

What are mongodb indexes?

what are the authentication modes in sql server? : Sql dba

1069

Does any body please help me what question's have asked for SSRS in the interview?

2151

When is functional dependency said to be the fully functional dependency?

1120

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

911

Where is mysql data stored linux?

1025

What is default postgres port?

903

What is use of postgresql?

897

What should be the fill factor for indexes created on tables? : sql server database administration

1143

How are the unique and primary key constraints different?

1078

What happens if a tablespace clause is left off of a primary key constraint clause?

581

In which phase of mload can I use .filler?

926

Difference between oracle's plus (+) notation and ansi join notation?

1111

For More Un-Answered { Databases } Questions Click Here