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

Which are the five query types available in oracle?

965

Explain parameter file in oracle.

1042

Is a rollback possible to any savepoint?

1112

Give the various rollback segment states.

1061

Explain cascading triggers.

1085

What is a mutating table and a constraining table?

1123

Why triggers are used?

997

Explain cursor types?

1035

What are pl/sql cursors?

1063

Explain the difference between triggers and constraints?

991

Enlist the data types that can be used in pl/sql?

1081

What is the difference between function, procedure and package in pl/sql?

1276

What is the difference between execution of triggers and stored procedures?

1128

Differentiate between pl/sql and sql?

1162

What is a pl/sql block?

1242

Un-Answered Questions { Databases }

What is logshipping and its purpose?

1003

What are the common mysql functions?

954

What is dbcc? : sql server DBA

1307

Tell me what is de-normalization and what are some of the examples of it?

1059

How many types of dba are there?

576

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

1017

Mention what is the basic syntax to use index in mongodb?

What are the differences between a dbms and rdbms?

1002

What are the basic components of notification services?

1090

Can you inner join the same table?

1000

can you convert or reverse engineer a fmx back to a fmb file?

1174

What are the attributes of cursor?

1065

What is function and procedure?

1041

Does mongodb cost money?

What is execute immediate?

1097

For More Un-Answered { Databases } Questions Click Here