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

Error_Code is a package proecdure ?

1 4227

EXIT_FORM is a restricted package procedure ?

1 4715

When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?

1 4089

List the system variables related in Block and Field?

1 4777

What is the difference between system.current_field and system.cursor_field ?

3 13389

What is an User Exits ?

1 3909

What are the type of User Exits ?

1 4015

What do you mean by a page ?

1 3832

How many pages you can in a single form ?

1 3609

Two popup pages can appear on the screen at a time ?

1 3923

What is the significance of PAGE 0 in forms 3.0 ?

1 3361

Deleting a page removes information about all the fields in that page ?

1 3477

What do you mean by a pop-up window ?

1 4143

What are the types of Pop-up window ?

1 4272

What is an Alert ?

2 5016

Un-Answered Questions { Databases }

How to view existing indexes on an given table using sys.indexes?

1158

Will the writetext statement activate a trigger?

1156

What is natural join in sql?

1048

What is scheduled job and how to create it?

1041

How to create new databases with "create database" statements?

1069

What are sql dirty pages?

1084

Give the cobol definition of a varchar field 177 when can an insert of a new primary key value threaten referential integrity?

1006

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3249

does pl/sql support “overloading”? Explain

1036

What is the difference between nvl function, ifnull function, and isnull function?

1158

What is a checkpoint and When does it occur?

819

How does Tuple-oriented relational calculus differ from domain-oriented relational calculus

832

What have included columns when we talk about sql server indexing?

1082

Which commands you use to lock the database in mongodb?

How do I change the max connections in mysql?

953

For More Un-Answered { Databases } Questions Click Here