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 use of between page trigers in REPORTS... (please give answer in a explanatory way...if possible give screen shots also...)

1 4738

what is Complex index. how to create it?

2 7727

Can we use SQL%ISOPEN in implicit cursors? Does this attribute works properly in Implicit Curosors?

3 12868

When the mutating error will comes? and how it will be resolved?

2 7963

What are the partitions types available in Oracle10g. How it will do? Simple example?

Tech Mahindra,

1 10550

What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?

Oracle,

9 18824

what is query and types of query

Reliance,

6 9480

HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.

16 25243

What is the difference Between Sql-server 2000 & 2005

Value Labs, Wipro,

3 10702

difference between sql server2000 and sql server2005

KPMG,

1 5348

Why Do you want to work in this company?

HCL,

4 7186

i need some interview questions on sql server developer plz any onee send some links.

2 6019

what is mean by crystal repoart? ahere we will mainly use that?

1 4322

i have windows-xp processor with P4 system. whenever I tried to download foxpro for windows 2.6 on windows XP, my operating system failed to install foxpro for windows 2.6.please. how could i download , install & run foxpro for windows 2.6 easily on windows XP ?

1 2097

how to create the triggers in the forms?

3 8514

Un-Answered Questions { Databases }

how to use regular expression in pattern match conditions? : Sql dba

1105

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1021

Can sql servers link to other servers like oracle?

910

in oracle BPM composer in part BA model on design model in enterprise model i cannot connection with value chain model work not links in part properties do you can me help me?

1605

Does view occupy space?

1005

Have you created fact table and dimension tables?

706

How can you append an identity column to a temporary table?

1065

Does group by remove duplicates?

1112

Can we shrink data file in sql server?

1123

what is collation? : Sql dba

1224

What is standby servers? Explain types of standby servers.

1075

define sql insert statement ? : Sql dba

1094

Is it possible to have clustered index on separate drive from original table location?

1034

What is your daily office routine?

2340

what is schema? : Sql dba

1137

For More Un-Answered { Databases } Questions Click Here