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

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

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

DB Development (113)
SQL PLSQL (3328)
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

For web applications from which version of Oracle is suitable?

1 5342

What are the main diff. between oracle 7.3 and oracle 8i?

1 4935

What is mutating table?

Saama Tech,

11 64490

How to call DDL statements from pl/sql?

5 32335

How to perform a loop through all tables in pl/sql?

Evosys, MBT,

4 15825

How to maintain the history of code changes of pl/sql?

3 14163

what are Dynamic SQL statements?

9 24747

Does it possible to pass object (or) table as an argument to a remote procedure?

TCS,

1 14732

What is pl/sql and what is it used for?

4 14488

what is constraining table?

2 13451

How pl/sql source code can be protected?

3 10587

What is the result, when NULL is compared with NULL?

TCS,

22 48408

What can be a size of a pl/sql block? Is there any limit?

2 12364

what are %TYPE and %ROWTYPE? what is the difference?

ICICI, Saama Tech, Sail,

7 47322

How to set the time zone for MySQL to particular country time?

2963

Un-Answered Questions { Databases }

What are the steps to process a single select statement?

728

Why would you use mongodb?

What are notification services?

716

What is responsibility and how u attach How to create user and how u attach with responsibility.

1847

What has stored procedures in sql?

832

What are the different types of locks in the database?

690

How do you create a foreign key in pgadmin 4?

625

What is the storage engine for mysql?

714

What happens to the data files if a tablespace is dropped?

826

What is the difference between pl and sql?

780

What are the disadvantages of primary key and foreign key in SQL?

876

What is the purpose of postgresql?

572

What do you think of this implementation? Can this be implemented better?

733

What is mongodb built?

What is the difference between a clustered index and a non-clustered index?

760

For More Un-Answered { Databases } Questions Click Here