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

What are the two types of concurrency?

4 8120

syntax for deleting the database in T SQL

5 8837

How are SQL Server databases physically stored under Windows 2000?

1 4273

internal language used in sql server 2000?

2 4490

What types of integrity are enforced by a foreign-key constraint

1 4809

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

IBM,

2 8907

How do you find the error, how can you know the number of rows effected by last SQL statement?

1 4608

Which virtual table does a trigger use?

3 8754

wat is meant by oracle

Infosys,

3 14678

Please HELP me its urgent? If i want to EXPORT data from SQL server to ORACLE 11g then how can I replicate data from SQL to ORACLE?

3 4814

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2502

Name three version of sql server 2000 and also their differences?

1 4060

It's Urgent? How to IMPORT .xls & .txt file into ORACLE?

5 16933

Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)

1 9665

what is Normalization?

TCS,

6 10153

Un-Answered Questions { Databases }

How will you monitor replication latency in transactional replication? : sql server replication

1156

Can one drop a column from a table?

1032

What is a clustered database?

932

What are the different types of backup available in the oracle?

597

What is difference between inner join and self join?

1097

What is the order of defining local variables and sub procedures/functions?

1074

You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?

547

What is clob in mysql

974

List the different normalization forms?

990

What is tuple with example?

942

What do you think about pl/sql?

1047

What is a user exit program in oracle reports?

1046

Differentiate between pl/sql and sql?

1164

What do you understand by data independence?

1110

Can files be stored in a database?

952

For More Un-Answered { Databases } Questions Click Here