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

How many segment are present in Oracle Manufacturing

Oracle,

2378

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 8955

Can we have exception part in trigger ?

1 7477

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 8091

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

HP,

2 8117

does physical index sort data

1 3963

what type of indexes physically sort data?

3 7487

Olap tools

2193

What is the difference Delete and Drop ?

6 9362

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 14825

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

HCL,

2 5085

What is $FLEX$ and $PROFILES$?

2 7713

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

4 11000

what is meant by databases

4 6566

what is sql injection in sql server?

TATA,

2 6697

Un-Answered Questions { Databases }

What is a pdo connection?

1126

How to rename an index?

1132

What is ims software environment?

968

What operating systems are supported by oracle database 10g xe?

1094

how to show all tables with 'mysql'? : Sql dba

1161

what stored procedure would you use to view lock information? : Sql server administration

1033

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1800

How can you check the version of sql server?

1177

What Are Cross Validation & Adi?

1212

what is 'mysqldump'? : Sql dba

1175

How much does mysql enterprise cost?

981

How to include date and time values in sql statements?

1148

Do you know what are the restrictions that views have to follow?

1141

Which joins are sql server default?

1084

How to call postgresql function in asp net?

987

For More Un-Answered { Databases } Questions Click Here