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 8333

How can you gather statistics on a table?

3 16434

How can you enable a trace for a session?

1 4990

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

3 18857

Name two files used for network connection to a database.

5 13126

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

2 7442

What is AppCore and AppCore2 ?

1 5534

Can a sigle canvas be used by different blocks ?

2 4323

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

3 5097

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

1 2769

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

1 3902

What is a predefined exception available in forms 4.0?

2 3173

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

1 2907

What is a library in Forms 4.0?

1 3323

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

1 3508

Un-Answered Questions { Databases }

How to execute multiple stored procedures at one time in sql server?

498

What is foreign key in dbms?

469

What is the least restrictive isolation level? : Transact sql

559

What is a derived table?

505

How do I create an access database from multiple excel files?

372

Can we perform backup restore operation on tempdb? : sql server database administration

582

What are mysql queries?

477

What is 3NF?

528

Must I use multiple devices to take advantage of partitions in sybase?

465

What is an implicit anchor and how is it a different form explicit anchor in a report builder?

625

What is multilevel indexing?

527

Define and explain about progress?

534

How many primary keys can be there in a table?

531

What is secondary or slave in mongodb?

How to define a data source name (dsn) in odbc manager?

521

For More Un-Answered { Databases } Questions Click Here