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

Explain mutating table error.

1214

Can cursors be part of a trigger body?

1644

What is the importance of sqlcode and sqlerrm?

1359

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1084

Explain spool.

1186

Differentiate between sga and pga.

1170

How can triggers be used for the table auditing?

1076

Is it possible to create startup or shutdown trigger for on-schema?

1041

Explain commit, rollback and savepoint.

1006

What are schema-level triggers?

1107

Differentiate between % rowtype and type record.

1315

What does fetching a cursor do?

1096

What are the system database in sql server 2008?

1041

Explain sql delete command?

1063

State a few properties of relational databases?

1136

Un-Answered Questions { Databases }

How to convert character strings into numeric values?

1107

what is the difference between LENGTH AND SIZE?

2494

Do while loop in mysql procedure?

1080

What is use of attributehierarchyenabled? : sql server analysis services, ssas

1250

How to change the name of a database user?

965

How to create median function?

166

What are types of joins?

970

In mongodb how do you use $set to update a nested value?

Explain candidate key, alternate key, and composite key?

1009

How to use like conditions in oracle?

1070

How to convert numeric values to character strings?

1071

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1975

What do you understand by the denormalisation?

970

What are database states in ms sql server?

1188

What do you understand by pl/sql records?

1025

For More Un-Answered { Databases } Questions Click Here