Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3239)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3312)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1391)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

What are the built-in functions used for sending Parameters to forms ?

Oracle, TCS,

2839

Can you have more than one content canvas view attached with a window ?

Oracle,

1815

Is the After report trigger fired if the report execution fails ?

Oracle,

2402

Does a Before form trigger fire when the parameter form is suppressed ?

Oracle,

1 3909

Is it possible to split the print reviewer into more than one region ?

Oracle,

1835

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

Oracle, TCS,

1874

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

Oracle,

1554

Can a field be used in a report without it appearing in any data group ?

Oracle,

4 6499

The join defined by the default data link is an outer join yes or no ?

Oracle,

1 5482

Can a formula column referred to columns in higher group ?

Oracle,

2083

Can a formula column be obtained through a select statement ?

Oracle,

1843

Is it possible to insert comments into sql statements return in the data model editor ?

Oracle,

2063

Is it possible to disable the parameter from while running the report ?

Honeywell, Oracle,

1 3310

When a form is invoked with call_form, Does oracle forms issues a save point ?

Oracle,

1 4125

Can a property clause itself be based on a property clause ?

Oracle,

1 3022

Un-Answered Questions { Databases }

Difference between drill down and drill through report.

542

How can I join two tables in database?

514

What sql does db2 use?

540

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2001

What do you understand by a stored procedure?

597

all steps of bitmap report?

1906

Can I work with several databases simultaneously? : sql server management studio

556

How is myisam table stored?

551

What entity means?

471

Differentiate between delete and truncate table?

631

explain the options of myisamchk to improve the performance of a table. : Sql dba

545

How do I change the max connections in mysql?

460

I have 2 tables with 1 million rows each. I have updated 1 row in first and 1 million update on second table. Now I commit both the updates. Which one will commit fast and Why?

2131

How would you go about developing a ssrs report?

110

What is relational database in mysql?

496

For More Un-Answered { Databases } Questions Click Here