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 4164

difference between place holder and formula column

Cognizant, IBM, Microsoft,

3 19293

difference between repeating frame and frame

IBM,

3 18146

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

1981

how do u call a report from form

Wipro,

3 11531

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

2128

can i use lexical variable in formula column

1 5711

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

2908

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

3 10375

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

2025

can i write commit in Before report trigger

4 11888

can my report have different layouts

2 4695

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

2049

how to load data into base tables

1 4187

what u write in Ctl file

2 5537

Un-Answered Questions { Databases }

Is google scholar a database?

1001

How do you select unique values in sql?

1003

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

1113

What are the purpose of Normalisation?

1053

How to define output parameters in stored procedures?

1029

What is an expensive query?

934

How do we get field detail of a table?

1082

What are cursors and when they are useful?

1092

Which are the two editions in which SQL Azure database available?

119

What are tables in sql?

1071

What are sql procedures?

1031

What is schema in sql example?

1186

What are the differences between DDL, DML and DCL in SQL?

1236

What are the qualities of 2nf?

1040

How can a function retun more than one value in oracle with proper example?

1080

For More Un-Answered { Databases } Questions Click Here