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 4232

difference between place holder and formula column

Cognizant, IBM, Microsoft,

3 19411

difference between repeating frame and frame

IBM,

3 18306

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

2031

how do u call a report from form

Wipro,

3 11656

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

2193

can i use lexical variable in formula column

1 5775

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

2967

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

3 10516

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

2064

can i write commit in Before report trigger

4 12036

can my report have different layouts

2 4775

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

2104

how to load data into base tables

1 4264

what u write in Ctl file

2 5627

Un-Answered Questions { Databases }

How to backup encryption key ?

191

How to select all columns of all rows from a table with a select statement in ms sql server?

1201

what is Neo4j?

Which join is like inner join?

1092

Â How to use an oracle sequence generator in a mapping?

1135

What happens if the update subquery returns no rows in ms sql server?

1181

Can we use trigger new in before insert?

971

What will cause the size of a stored procedure to grow in sybase?

873

What is the difference between a database and instance? What is the relation between them?

626

What is join and how many types of joins?

876

How to define an anonymous block?

1249

What is the maximum size of table in mysql?

1083

What are the different technologies used to access Database from Visual Basic?

1013

What is explicit cursors?

1129

in the physical file layout, where should the transaction log be stored in relation to the data file?

1044

For More Un-Answered { Databases } Questions Click Here