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 timestamp datatype?

986

To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

974

Can an automatic recovery be initiated by a user?

1033

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

1061

Can a table be created inside a trigger?

984

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1059

Explain different backup plans?

962

When would you prefer to have a minimum number of indexes?

933

What specific conditions database should meet, before you can bulk copy data into it using bcp?

998

Can a trigger be created on a view?

972

What are the restraints imposed on the table design by a merge replication?

1054

What is raid, and how it can influence database performance?

1077

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

1018

How would you choose between a clustered and a non-clustered index?

991

How raid can influence database performance?

1058

Un-Answered Questions { Databases }

Explain having clause and where clause?

1071

What do you understand by functional dependency and transitive dependency in dbms?

881

Which tools are available to manage SQL Azure databases and servers?

115

Does postgres support clustering?

865

How many categories of data types used by sql server?

1037

What is Multivalued dependency?

801

What is the purpose of the import option ignore? What is its default setting?

616

What is data store? How to create data store?

664

What is mysql installer?

1014

how to write customizations in po

1631

What is primary key in database?

937

How to list or view all databases from the mysql server.

938

How much memory does postgresql need?

892

What are the advantages of views in a database?

1201

What happens if you no create privilege in a database?

1129

For More Un-Answered { Databases } Questions Click Here