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 8316

syntax for deleting the database in T SQL

5 9119

How are SQL Server databases physically stored under Windows 2000?

1 4370

internal language used in sql server 2000?

2 4606

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

1 4883

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 9061

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 8930

wat is meant by oracle

Infosys,

3 14838

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 4991

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 2580

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

1 4167

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

5 17221

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 9775

what is Normalization?

TCS,

6 10522

Un-Answered Questions { Databases }

How to write a left outer join with the where clause in oracle?

1151

Design database draw er diagram for a certain scenario ?

4650

How to export data from database and import into another?

996

List out the different types of locks available in sql server?

1046

How to provide default values to function parameters?

1252

What is a scheduled job or what is a scheduled task?

1035

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2090

What kind of problems occurs if we do not implement proper locking strategy?

1495

How do I start sql server 2017?

1014

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1295

what is bcp? When does it used? : Sql dba

1055

What are the different SQL Server Versions you have worked on?

1077

in oracle BPM composer in part BA model on design model in enterprise model i cannot connection with value chain model work not links in part properties do you can me help me?

1605

Can we use distinct and group by together?

1133

What are the different types of subquery?

1233

For More Un-Answered { Databases } Questions Click Here