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,

1 2388

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 9002

Can we have exception part in trigger ?

1 7485

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 8118

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

HP,

2 8143

does physical index sort data

1 3967

what type of indexes physically sort data?

3 7497

Olap tools

2196

What is the difference Delete and Drop ?

6 9406

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 14844

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

HCL,

2 5106

What is $FLEX$ and $PROFILES$?

2 7726

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

4 11027

what is meant by databases

4 6597

what is sql injection in sql server?

TATA,

2 6719

Un-Answered Questions { Databases }

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2174

Does view occupy space?

1005

How to select all columns of all rows from a table in oracle?

1115

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1021

Design database draw er diagram for a certain scenario ?

4641

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2345

What is the current version of sql?

1091

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1939

Can you index views?

951

Why should you use or avoid select * statements?

1103

How to convert character strings into numeric values?

1184

What is your daily office routine?

2334

When should you use an instead of trigger?

1042

what is the last version,the release date of that version and fix pack of ibm db2 udb?

2043

What is a view in sql?

1035

For More Un-Answered { Databases } Questions Click Here