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 are Nested Tables? How will u delete 5 rows from Nested Tables

IBM,

3 10285

What are Global Temporary tables

IBM, TCS,

3 11196

What are Anti joins

IBM,

1 10453

what is the difference between data migration and production migration.

2403

how can you perform lookup range in lookup stage expalin in detail?

IBM,

1979

what is rcp,if rcp disabled what happen?

Systel,

2276

diff b/w inter process and in process

Aptara, TCS,

2170

how do you do sql tuning?

Systel,

2149

CLI stands for?

IBM,

3 7494

what are wrappers and build ups and what it's use?

TCS,

2214

can u combine pipeline parallelism and partition parallalism? how and whan?

TCS,

2381

what is ad-hoc access? what is the diff b/w managed query and ad-hoc access?

TCS,

2354

how node connect with cpu?

IBM,

2172

sparse lookup and where its options we find in OCI and db2?

TCS,

2269

What is the diff. bwt. primary key and unique key?

4 6507

Un-Answered Questions { Databases }

what is sub-query? : Transact sql

1161

Explain enable novalidate constraint.

1136

How many triggers are possible in mysql?

1014

Do you know what is xpath?

1158

Tell me about joins in database system and explain each in detail.

1112

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1175

Can procedure in package be overloaded?

1146

The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?

624

Is it possible to have multiple layouts in a report?

1094

What is the command used to fetch the first 5 characters of a string?

1262

How to implement if-then-else in a select clause in sybase?

869

How many full-text indexes can a table have?

1026

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1137

What is third normal form?

973

What is catalog views?

1123

For More Un-Answered { Databases } Questions Click Here