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

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

1 3669

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

1 3814

How can a cross product be created?

1 4367

What is an user exit used for?

1 3849

What are the three types of user exits available ?

1 4847

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

1 3801

What is the basic structure of PL/SQL ?

6 12047

What are the components of a PL/SQL block ?

3 12695

What are the datatypes a available in PL/SQL ?

2 7194

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

4 12825

What is difference between % ROWTYPE and TYPE RECORD ?

2 22613

What is PL/SQL table ?

6 11368

What is a cursor ? Why Cursor is required ?

3 13599

Explain the two type of Cursors ?

Hi Caliber IT,

8 19543

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

4 10328

Un-Answered Questions { Databases }

What is the purpose of -> in the mysql terminal?

1135

What is the order by used for?

1032

When can we use the where clause and the having clause?

1034

when is the use of update_statistics command? : Sql dba

1058

Explain the use of analyse option in exp command.

1138

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

987

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

959

What is an expensive query?

937

Can we hide the definition of a stored procedure from a use?

1236

Explain spool.

1186

List the advantages of using stored procedures?

1067

How would you configure burn factor in sybase?

944

What do you mean by sga and how is it different from pga?

How do I start sql server 2017?

948

What is the quickest way to fetch the data from a table?

1066

For More Un-Answered { Databases } Questions Click Here