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

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 9639

How can you gather statistics on a table?

3 17928

How can you enable a trace for a session?

1 5853

What is the difference between the SQL Loader and IMPORT utilities?

3 20593

Name two files used for network connection to a database.

5 15109

Can you truncate a table in a procedure in Oracle Forms?

2 8507

What is AppCore and AppCore2 ?

1 6389

Can a sigle canvas be used by different blocks ?

2 5717

What is the order of the triggers fired once the form is opened?

3 6297

What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?

1 3610

Is it possible to attach same library to more than one form?

1 4627

What is a predefined exception available in forms 4.0?

2 4350

What are the built_in used to trapping errors in forms 4?

1 3760

What is a library in Forms 4.0?

1 4303

What built-in is used for showing the alert during run-time?

1 4275

Un-Answered Questions { Databases }

Compare ‘postgresql’ with ‘nosql’?

921

How will you optimize a stored procedure optimization?

1118

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

1195

What is a reference table in database?

1084

Can you create a synonym without having a table?

1095

How to create an multi-statement table-valued function?

1052

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2442

what is denormalization. : Sql dba

1167

Mention what does plv msg allows you to do?

1164

Disadvantages of the indexes?

1190

What are commonly used mssql functions in php?

1148

How to connect with firebird database in delphi using tsqlconnection?

What do you mean by a replica set in mongodb?

how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.

965

What is difference between mysql and postgresql?

1241

For More Un-Answered { Databases } Questions Click Here