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

To display the page no. for each page on a report what would be the source & logical page no. or & of physical page no.?

2 6229

What is a library in Forms 4.0?

1 3862

explain about content canvas views?

1 4308

What is the difference when Flex mode is mode on and when it is off?

1 6025

How can a square be drawn in the layout editor of the report writer?

1 3999

What are the triggers associated with the image item?

1 3662

Give the sequence of execution of the various report triggers?

1 5982

What is the difference between setting up of parameters in reports 2.0 reports ?

1 4028

Name of the functions used to get/set canvas properties?

1 4990

Can you attach an lov to a field at run-time? if yes, give the build-in name.

1 4985

What is a record Group?

2 4697

Does a grouping done for objects in the layout editor affect the grouping done in the datamodel editor?

1 4147

What is relation between the window and canvas views?

ABC,

2 10434

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

2 5344

Can you attach an lov to a field at design time?

1 4391

Un-Answered Questions { Databases }

What does pragma mean?

1052

List out some of the requirements to set up a sql server failover cluster?

1034

How much does sql cost?

998

Does mongodb need a lot space of random access memory (ram)?

What is difference between rank () row_number () and dense_rank () in sql?

1101

What the different components in replication and what is their use? : sql server DBA

1050

Is mysql open source?

934

Is mongodb a relational database? Explain

Can an extended stored procedure be called from inside a user-defined function?

1053

Is mysql good for large database?

925

Differentiate between translate and replace?

1116

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

2511

What is difference between primary key and foreign key?

904

How do I clear the command in mysql?

944

How would you best determine why your MVIEW couldn't FAST REFRESH?

2359

For More Un-Answered { Databases } Questions Click Here