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

Where the procedures are stored in database?

845

Explain about the implementation of stored procedures?

878

Does storing of data in stored procedures increase the access time? Explain?

1119

Explain about the difficulties faced by the database developer in implementing pre compiled statements?

725

How can we call stored procedures inside store procedures?

827

State about the security aspects of stored procedures?

976

Explain the benefits of running stored procedure on a database engine?

938

How one call ddl statement using stored procedures in oracle?

800

State the different extensions for stored procedures?

808

How many types of stored procedure?

848

What is the difference between "is" and "as" while creating procedure?

814

What is the difference between stored procedures and stored functions in oracle?

939

How you can import data from other sources into access database?

988

Explain how we can do multi-join query in ms access?

859

Between different data’s, what are the types of relationship can be formed?

1023

Un-Answered Questions { Databases }

Mention the different languages present in dbms

954

How to handle error or exception in sql?

986

Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

1012

List different type of expressions with the example.

935

What is insert command in sql?

1132

What is a directory object?

1100

What is 1nf 2nf 3nf in dbms?

903

Where is database stored?

880

What is a foreign key example?

781

How to define an anonymous block?

1160

How do you go back in sql?

990

How do I completely uninstall postgresql?

872

What are the requirements to use odbc connections in php scripts?

1121

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2572

What is table partitioning in sybase?

897

For More Un-Answered { Databases } Questions Click Here