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

Explain mutating table error.

1 1291

Can cursors be part of a trigger body?

1 1716

What is the importance of sqlcode and sqlerrm?

1 1419

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

1 1144

Explain spool.

1 1242

Differentiate between sga and pga.

1 1229

How can triggers be used for the table auditing?

1 1132

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

1 1104

Explain commit, rollback and savepoint.

1 1072

What are schema-level triggers?

1 1185

Differentiate between % rowtype and type record.

1 1431

What does fetching a cursor do?

1 1151

What are the system database in sql server 2008?

1 1135

Explain sql delete command?

1 1119

State a few properties of relational databases?

1 1200

Un-Answered Questions { Databases }

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8225

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

1107

Does group by remove duplicates?

1109

What is a concurrency problem in dbms?

1049

Do we need to rebuild index after truncate?

1128

Can we do dml on views?

1031

what is spatial nonclustered index

1054

Is it possible to have clustered index on separate drive from original table location?

1034

how many tables will create when we create table, what are they? : Sql dba

1140

What is your daily office routine?

2340

what are the advantages of sql ? : Sql dba

1136

Where can you add custom error messages to sql server?

1198

What are different types of constraints?

995

What is in place upgrade in sql server?

1121

How to provide default values to function parameters?

1247

For More Un-Answered { Databases } Questions Click Here