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

What are the two types of concurrency?

4 8314

syntax for deleting the database in T SQL

5 9109

How are SQL Server databases physically stored under Windows 2000?

1 4366

internal language used in sql server 2000?

2 4606

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

1 4881

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 9058

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

1 4708

Which virtual table does a trigger use?

3 8926

wat is meant by oracle

Infosys,

3 14831

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 4986

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

1 2578

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

1 4165

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

5 17212

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 9774

what is Normalization?

TCS,

6 10506

Un-Answered Questions { Databases }

Where can you add custom error messages to sql server?

1204

How efficient you are in oracle and SQL server?

1253

What is the difference between case version and decode version?

1104

Disadvantages of the indexes?

1220

What are wait types?

1244

How do I start sql server 2017?

1011

How to start an oracle instance?

1100

Design database draw er diagram for a certain scenario ?

4650

Can sql servers link to other servers like oracle?

913

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1041

What is the primary use of the model database?

1144

Suppose database is running slow, what will you do?

2590

What is an indexed view?

1018

What is sql or structured query language?

1220

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1192

For More Un-Answered { Databases } Questions Click Here