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

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

Oracle, TCS,

3437

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

Oracle,

2373

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

Oracle,

2955

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

Oracle,

1 4817

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

Oracle,

2342

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

Oracle, TCS,

2423

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,

2066

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

Oracle,

4 8335

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

Oracle,

1 6347

Can a formula column referred to columns in higher group ?

Oracle,

2553

Can a formula column be obtained through a select statement ?

Oracle,

2380

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

Oracle,

2638

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

Honeywell, Oracle,

1 4211

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

Oracle,

1 5067

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

Oracle,

1 3722

Un-Answered Questions { Databases }

What is a deterministic function?

1119

query optmization techniques and quwry analyser+projects+ppts

2469

How to use rank function in mysql?

1064

Mention what are different methods to trace the pl/sql code?

1296

What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

1207

Differentiate between % rowtype and type record.

1396

What is difference between database and file?

1085

What is the concept of Virtual field?

2098

Is mysql same as mariadb?

950

Is mongodb support replication?

What are the arithmetic operations?

1153

What does truncate do?

998

Explain intellisense for query editing

1076

How to create sub reports?

251

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

1202

For More Un-Answered { Databases } Questions Click Here