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 3744

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

1 3873

How can a cross product be created?

1 4464

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 3856

What is the basic structure of PL/SQL ?

6 12217

What are the components of a PL/SQL block ?

3 12815

What are the datatypes a available in PL/SQL ?

2 7279

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

4 12935

What is difference between % ROWTYPE and TYPE RECORD ?

2 22699

What is PL/SQL table ?

6 11560

What is a cursor ? Why Cursor is required ?

3 13720

Explain the two type of Cursors ?

Hi Caliber IT,

8 19792

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

4 10470

Un-Answered Questions { Databases }

List some neo4j commands?

What does the acronym acid stand for in database management?

1093

Which data loaded are in target db?

616

What is delimiter in dbms?

956

Explain the purpose of %type and %rowtype data types?

977

What does the base_object_type column shows in the user.triggers data dictionary view?

1100

How many types of relationship are there?

1087

What is an advantage of a database?

1111

What is Library Cache in Oracle?

1195

What are examples of triggers?

1130

What is Java Pool in Oracle?

1253

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

1123

What are the properties of the transaction?

1057

What is mongodb cluster?

What is the difference between for trigger and after trigger?

1167

For More Un-Answered { Databases } Questions Click Here