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

How does rowid help in running a query faster?

1 1497

Can triggers stop a dml statement from executing on a table?

1 1179

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

1 1091

In what condition is it good to disable a trigger?

1 1084

When is a declare statement required?

1 1212

What are the uses of sysdate and user keywords?

1 1180

Does sql*plus also have a pl/sql engine?

1 1149

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1 1157

Explain the structure of pl/sql in brief.

1 1163

What is a database event trigger?

1 1238

Write the alter statement to enable all the triggers on the t.students table.

1 1204

Define implicit and explicit cursors.

1 1232

Explain ttitle and btitle.

1 1181

Can instead of triggers be used to fire once for each statement on a view?

1 1025

Can 2 queries be executed simultaneously in a distributed database system?

1 1215

Un-Answered Questions { Databases }

How to remove duplicate rows from table except one?

1079

what are aggregate and scalar functions? : Sql dba

1122

How raid can influence database performance?

1110

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1207

What is self contained sub query?

1138

What is oracle latest version?

1169

how to escape special characters in sql statements? : Sql dba

1110

how to start mysql server? : Sql dba

1258

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

1140

what is spatial nonclustered index

1054

How do I find the sql server version?

1099

what are the advantages of sql ? : Sql dba

1136

What are the kinds of subquery?

1099

How can you append an identity column to a temporary table?

1065

what is the age limit for groups1 examination

2335

For More Un-Answered { Databases } Questions Click Here