Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3239)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3312)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1391)
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 8360

How can you gather statistics on a table?

3 16456

How can you enable a trace for a session?

1 4998

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

3 18881

Name two files used for network connection to a database.

5 13161

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

2 7454

What is AppCore and AppCore2 ?

1 5554

Can a sigle canvas be used by different blocks ?

2 4339

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

3 5115

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

1 2780

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

1 3914

What is a predefined exception available in forms 4.0?

2 3185

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

1 2921

What is a library in Forms 4.0?

1 3331

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

1 3520

Un-Answered Questions { Databases }

What is replica set in mongodb?

What is dml and ddl?

524

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

569

What is indexing in sql server with example?

525

why the Ctl file u put only in bin folder why not in other folder

1594

what is a self join? : Sql server database administration

526

What is a trace frag?

641

What is sqlca in db2?

536

What are a database and a data warehouse?

566

can you tell how can you display the maximum salary in sql? : Mysql dba

467

What would you do with an in-doubt distributed transaction?

1468

What is the default order of an order by clause?

582

What is data types in database?

468

How to get data from mongodb in flask?

Explain exception handling in pl/sql?

532

For More Un-Answered { Databases } Questions Click Here