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

how can i create a user defined datatype

3 7714

how can i read write files from pl/sql

3 9848

what is global variable in pl/sql

1 12014

can i call procedure in package

TCS,

3 10198

four procedures is are there should i write their in a package

2 6404

package specification-3 procedures package body-2 procedures will is execute

PWC,

2 10805

package specification-3 procedures package body-4 procedures how can i write for other procedure in package body

Reliance,

2 7910

what is variable in package specification

3 6914

i don't want the message as 14 rows updated just it should update what it will do

4 9488

how can i read files from a pl/sq l program

3 10359

how do u compile a form i.e .fmb file in Unix or in dos

HCL,

1 4633

if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed

1 1973

if u want to delete all these detail block etc what will happen in form

1 2101

.fmb will be in which folder

2 5878

how do u place it in required folder

1 2004

Un-Answered Questions { Databases }

Is primary key always clustered index?

1092

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1189

Can one drop a column from a table?

1081

What is the difference between case version and decode version?

1103

How to enter binary string literals in ms sql server?

1235

What is the current version of sql?

1091

Why and when do stored procedure recompile?

1052

When should you use an instead of trigger?

1042

Why use identity in sql server?

1191

Is microsoft getting rid of access?

883

How can I check that whether automatic statistic update is enabled or not?

1108

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1064

How can we solve concurrency problems?

1120

how many tables will create when we create table, what are they? : Sql dba

1140

how to start mysql server? : Sql dba

1260

For More Un-Answered { Databases } Questions Click Here