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

based on parameter value layout of report should change

1 4266

difference between place holder and formula column

Cognizant, IBM, Microsoft,

3 19464

difference between repeating frame and frame

IBM,

3 18374

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

1 2056

how do u call a report from form

Wipro,

3 11711

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

1 2229

can i use lexical variable in formula column

1 5813

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

1 2996

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

3 10595

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

1 2082

can i write commit in Before report trigger

4 12096

can my report have different layouts

2 4822

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

1 2122

how to load data into base tables

1 4295

what u write in Ctl file

2 5661

Un-Answered Questions { Databases }

Where can you add custom error messages to sql server?

1203

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1041

Can we rollback truncate?

1072

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2209

Is primary key always clustered index?

1092

How to write a left outer join with the where clause in oracle?

1149

If a cursor is open, how can we find in a pl/sql block?

1235

What is the current version of sql?

1091

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

how to start mysql server? : Sql dba

1260

What is subquery? Explain the properties of a subquery?

1056

How efficient you are in oracle and SQL server?

1251

Can we use distinct and group by together?

1131

What is sql server query analyzer?

1123

Explain system functions or built-in functions? What are different types of system functions?

1060

For More Un-Answered { Databases } Questions Click Here