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

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 9496

How can you gather statistics on a table?

3 17781

How can you enable a trace for a session?

1 5758

What is the difference between the SQL Loader and IMPORT utilities?

3 20443

Name two files used for network connection to a database.

5 14916

Can you truncate a table in a procedure in Oracle Forms?

2 8400

What is AppCore and AppCore2 ?

1 6298

Can a sigle canvas be used by different blocks ?

2 5598

What is the order of the triggers fired once the form is opened?

3 6158

What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?

1 3535

Is it possible to attach same library to more than one form?

1 4550

What is a predefined exception available in forms 4.0?

2 4238

What are the built_in used to trapping errors in forms 4?

1 3688

What is a library in Forms 4.0?

1 4211

What built-in is used for showing the alert during run-time?

1 4206

Un-Answered Questions { Databases }

What is pdo in database?

900

What is user in sql?

1019

What are the different windows events activated at runtime ?

2900

How to replace given values with null using nullif()?

987

Does oracle use sql?

926

How to represent ENUMs and SETs internally?

1130

What is the difference between is null & is not null?

995

List some of the rules that apply to creating and using a ‘view’

888

Does hive support indexing?

959

what is the difference between $message and $$message? : Sql dba

997

What is a user view?

746

What is the most important object in an access database?

744

Explain the structure of adaptive server enterprise?

893

Explain the creation and execution of a user-defined function in the sql server?

1051

What is the difference between nvl and nvl2?

972

For More Un-Answered { Databases } Questions Click Here