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

Can you call pl/sql package functions from within a fast formula?

1039

Why does %isopen return false for an implicit cursor?

1 1454

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1059

what are different types of keys in sql?

1152

Define overloaded procedure?

1078

How do we accept inputs from user during runtime?

1064

What does the acronym acid stand for in database management?

1032

What is the difference among union, minus and intersect?

1000

What are the differences between implicit and explicit cursors?

1068

Cite the differences between execution of triggers and stored procedures?

1077

What is a recursive stored procedure?

1183

Define commit, rollback and savepoint?

1026

How can we link a sql database to an existing android app?

1029

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

1134

what is error ora-03113: end-of-file on communication channel?

1165

Un-Answered Questions { Databases }

How fixed length strings are truncated and padded?

980

What are referenced objects? Explain the importance of referencing.

Why is stored procedure faster than query?

960

How to install sql server 2005 express edition?

1122

What is shrink log file?

897

What is built-in/administrator?

1005

Differentiate between a primary key and a unique key.

1070

What is difference between group by and order by clause?

964

Explain bcnf (boyce-codd normal form)?

1017

Can you tell how many values can set the function of mysql to consider?

988

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2322

What is checkpoint process in the sql server?

1030

Which command is used to view the content of the table in mysql?

920

How to select an oracle system id (sid)?

1064

How to disable a login name in ms sql server?

1134

For More Un-Answered { Databases } Questions Click Here