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

based on parameter value layout of report should change

1 4178

difference between place holder and formula column

Cognizant, IBM, Microsoft,

3 19311

difference between repeating frame and frame

IBM,

3 18172

i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output

1993

how do u call a report from form

Wipro,

3 11561

i am writing a query select EmpNo from Emp how can i call in after parameter form

2143

can i use lexical variable in formula column

1 5723

in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory

2917

in before report trigger SRW.user_exit(FND_Userinit) what will do

3 10399

suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

2035

can i write commit in Before report trigger

4 11910

can my report have different layouts

2 4710

why the Ctl file u put only in bin folder why not in other folder

2067

how to load data into base tables

1 4195

what u write in Ctl file

2 5549

Un-Answered Questions { Databases }

define join and explain different type of joins? : Sql dba

959

What is the current limitation of the size of SQL Azure DB?

127

How to get a list of indexes of an existing table?

971

Who uses access database?

844

Differentiate between pl/sql and sql?

1167

What is difference between sybase and oracle?

955

What is microsoft access table?

819

What are the differences between left join and inner join in sql server?

1118

Is it good to store images in database?

1015

How to add code to the existing article (using improve article)?

1127

Explain what is dbcc?

1026

How a table can be created using microsoft access object library (maol)?

1620

What is the difference between a local and a global temporary table?

1139

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

4409

What is a canvas in oracle forms?

1082

For More Un-Answered { Databases } Questions Click Here