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

Oracle (3253)
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

What are the two panes that Appear in the design time pl/sql ?

1 3741

What are three panes that appear in the run time pl/sql interpreter?

1 3872

How can a cross product be created?

1 4462

What is an user exit used for?

1 3908

What are the three types of user exits available ?

1 4909

How can I message to passed to the user from reports?

1 3852

What is the basic structure of PL/SQL ?

6 12216

What are the components of a PL/SQL block ?

3 12813

What are the datatypes a available in PL/SQL ?

2 7276

What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?

4 12934

What is difference between % ROWTYPE and TYPE RECORD ?

2 22699

What is PL/SQL table ?

6 11558

What is a cursor ? Why Cursor is required ?

3 13719

Explain the two type of Cursors ?

Hi Caliber IT,

8 19790

What are the PL/SQL Statements used in cursor processing ?

4 10467

Un-Answered Questions { Databases }

What are the components of ms access?

883

Is it possible to have clustered index on separate drive from original table location?

1018

How would you design a database for an online site, which would average a million hits a day?

1056

Does vacuum full reindex?

873

Why merge statement is used inside the database?

1155

Explain the Surrogate Key in DBMS.

1004

What are the differences between sql server and mysql.

1148

How would you choose between a clustered and a non-clustered index?

1023

What data structure does mysql use?

1072

Is mongodb free for commercial use?

How to execute stored procedure in select statement sql server?

1116

Is postgresql like oracle?

895

What is the maximum size of an access database?

914

What privilege is needed for a user to delete rows from tables in another schema?

1140

Is sql easier than java?

1069

For More Un-Answered { Databases } Questions Click Here