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

How many segment are present in Oracle Manufacturing

Oracle,

2320

What is the main different between Null and NOT Null. Difference between Primary and Unique Key. How to Check the database from which application is it possibe.

6 8740

Can we have exception part in trigger ?

1 7402

What is Foreign Key? What is the main difference between primary key and Foreign Key ? How Foreign Key can be defined? Is Foreign key is used to join two or more table?

4 7879

What is Inner Joints and Outer Joints ? What is right outer joints,left outer joints,right inner joints , left inner joints ,

HP,

2 7991

does physical index sort data

1 3876

what type of indexes physically sort data?

3 7353

Olap tools

2121

What is the difference Delete and Drop ?

6 9073

what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b. select/from/table_name/groupby/having/orderby

HCL, JPMorgan Chase,

5 14624

what is differencial backup?how to work?Anybody explai it?

HCL,

2 4951

What is $FLEX$ and $PROFILES$?

2 7591

Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?

4 10835

what is meant by databases

4 6365

what is sql injection in sql server?

TATA,

2 6523

Un-Answered Questions { Databases }

How to represent ENUMs and SETs internally?

1131

What are the main features of cursor?

1071

What is mysql shell?

985

What can I use microsoft access for?

825

What is microsoft access made up of?

873

how to escape special characters in sql statements? : Sql dba

1035

What is database Configuration assistant ?

1145

How to list all user defined functions in the current database?

1045

What is regexp?

1141

What is the use of lockboxes? : oracle accounts receivable

1208

How to create an oracle database?

1041

Can we join 3 tables in sql?

1043

Define stored procedure?

1025

How to resolve the orphan use problem? : sql server security

1014

What are parameter files? Where do we use them?

For More Un-Answered { Databases } Questions Click Here