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

What is sql*loader and what is it used for?

563

What are the triggers associated with image items?

609

What is bind reference and how can it be created?

564

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

569

What are the datatypes available in pl/sql ?

597

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

539

How many clustered indexes can be created on a table?

577

What is raid? How does it help storage of databases?

590

Explain about recursive stored procedures?

443

Explain about the implementation of business logic in stored procedures?

412

Explain about the process which takes place to execute a stored routine?

427

What is the difference between a user defined function and a stored procedure?

473

Explain about the return statement?

478

Can we use commit inside the trigger? If not then how can we save the transaction made by the trigger?

499

What are external procedures ? Why and when they are used?

472

Un-Answered Questions { Databases }

How do I create a collection in mongodb? Write it's syntax

Does mongodb run on amazon ebs?

What is foreign key in postgresql?

445

How to create a new table by selecting rows from another table in mysql?

489

What is an oracle recycle bin?

533

How to create a postgresql database?

469

How to change user password in oracle?

592

material view and view disadvantages?

619

What is ttitle and btitle?

565

How to shutdown mysql server?

569

What is pct free/pct used/pct increase parameter in segment?

295

What degree do database administrators need?

272

How to retrieve error messages using odbc_errormsg()?

528

What is similarity and difference between truncate and delete in sql?

575

When should you increase copy latches? What parameters control copy latches?

290

For More Un-Answered { Databases } Questions Click Here