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 8099

syntax for deleting the database in T SQL

5 8812

How are SQL Server databases physically stored under Windows 2000?

1 4261

internal language used in sql server 2000?

2 4483

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

1 4796

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 8891

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

1 4602

Which virtual table does a trigger use?

3 8730

wat is meant by oracle

Infosys,

3 14659

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 4793

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

2498

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

1 4050

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

5 16901

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 9659

what is Normalization?

TCS,

6 10125

Un-Answered Questions { Databases }

What is field size access?

749

How to set the time zone for MySQL to particular country time?

3200

What is a collation?

1098

What is database management system explain?

937

What is a non equi join?

985

What is table level trigger?

1027

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

911

Difference between superior keys and candidate keys?

952

Does google have a database like access?

977

How do I edit a table in mysql workbench?

856

What are the commands used in dcl? : sql server DBA

1077

What are .mdf files?

948

What is the default password for mysql?

905

What is key.next.item trigger?

What is pragma in sql?

1086

For More Un-Answered { Databases } Questions Click Here