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

How does rowid help in running a query faster?

1424

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

1111

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

1032

In what condition is it good to disable a trigger?

1023

When is a declare statement required?

1148

What are the uses of sysdate and user keywords?

1105

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

1087

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

1102

Explain the structure of pl/sql in brief.

1099

What is a database event trigger?

1165

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

1131

Define implicit and explicit cursors.

1150

Explain ttitle and btitle.

1125

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

964

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

1154

Un-Answered Questions { Databases }

If you need to refresh a website page every time a record is updated in database, how would you do it?

936

What is the latest version of php and mysql?

1220

How do I start sql from command line?

1028

How can we optimize stored procedure?

958

What do you mean by atomicity and aggregation?

909

What is extension and intension?

915

Explain about the analyze command in oracle?

1057

There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?

2129

How can we optimize a sql query?

1055

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1092

How do I start and stop mysql on windows?

1014

Using the customer, and order table in northwind database, please write a query to produce xml?

1082

You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

121

Please explain drop constraint oracle?

1116

What is error ora-12154: tns:could not resolve the connect identifier specified?

1088

For More Un-Answered { Databases } Questions Click Here