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 9670

How can you gather statistics on a table?

3 17944

How can you enable a trace for a session?

1 5861

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

3 20617

Name two files used for network connection to a database.

5 15133

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

2 8526

What is AppCore and AppCore2 ?

1 6399

Can a sigle canvas be used by different blocks ?

2 5739

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

3 6324

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

1 3617

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

1 4638

What is a predefined exception available in forms 4.0?

2 4367

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

1 3770

What is a library in Forms 4.0?

1 4318

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

1 4289

Un-Answered Questions { Databases }

How to convert numeric expression data types using the cast() function?

1134

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2174

List out the different types of locks available in sql server?

1037

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1034

Equi join and non equi join is possible with sql server?

1111

Can we use distinct and group by together?

1116

What are the two main functions of queries in databases?

1509

What is temporary table in sql server? Why we use temp table?

1000

Does group by remove duplicates?

1099

what is sql server agent? : Sql dba

1162

What is the current version of postgresql?

1144

How to put more than 1000 values into an oracle in clause?

1095

what is the age limit for groups1 examination

2322

What are the kinds of subquery?

1087

Can one drop a column from a table?

1075

For More Un-Answered { Databases } Questions Click Here