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 9498

How can you gather statistics on a table?

3 17785

How can you enable a trace for a session?

1 5760

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

3 20447

Name two files used for network connection to a database.

5 14919

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

2 8403

What is AppCore and AppCore2 ?

1 6301

Can a sigle canvas be used by different blocks ?

2 5601

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

3 6161

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 4552

What is a predefined exception available in forms 4.0?

2 4244

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

1 3690

What is a library in Forms 4.0?

1 4211

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

1 4207

Un-Answered Questions { Databases }

Define entity, entity type, and entity set.

1068

When would you use sql joins?

959

How do triggers work?

936

What is a join in the sql?

992

What is field in mysql?

931

Explain the use of constraints option in exp command.

1048

What is dbms used for?

1007

Can we delete column in sql?

1099

How do access relationships work?

821

i made a table whih contain a column "Photo" with image data type and i want to insert the byte of a picture present in my hardisk using insert statement in that colum... so what will be my insert statement?

2596

How to create local server in postgresql?

884

How to create function with parameter in sql server?

1105

Explain what is a subquery ?

1188

What are the benefits of using access?

914

List out different types of normalizations in sql server and explain each of them?

929

For More Un-Answered { Databases } Questions Click Here