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 will you get by the cursor attribute sql%notfound?

1100

What is the use of pl/sql table?

1079

What is pl/sql table? Why it is used?

1050

What is the difference between the implicit and explicit cursors?

1073

Write a unique difference between a function and a stored procedure.

1023

What is the usage of when clause in trigger?

1069

Which command is used to delete a package?

1191

What is a trigger in pl/sql?

1 1691

What are the different schemas objects that can be created using pl/sql?

1048

What is the maximum number of triggers, you can apply on a single table?

1018

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1110

What is the main reason behind using an index?

1035

Explain the commit statement.

1176

Explain the rollback statement?

1043

What is exception? What are the types of exceptions?

1091

Un-Answered Questions { Databases }

How to use subqueries with the exists operators in ms sql server?

1143

What is the full meaning of dbms?

1081

we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.

2550

I want to start and stop mysql on windows? How do I do that?

1079

What is forward declaration in pl sql?

1098

What is the purpose of cursors in pl/sql?

1160

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1697

What are all types of user defined functions?

1097

How do I edit a database in mysql workbench?

929

What is scheduled job and how to create it?

1016

What are the types of containers in ssis?

1197

What is open client in sybase?

902

Explain the difference between the neo4j graph database and mysql database?

What is the difference between postgresql and sql?

848

Does pdo prevent sql injection?

951

For More Un-Answered { Databases } Questions Click Here