Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3239)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3312)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1391)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

How many segment are present in Oracle Manufacturing

Oracle,

1805

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 6821

Can we have exception part in trigger ?

1 6611

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 6330

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

HP,

2 6832

does physical index sort data

1 3271

what type of indexes physically sort data?

3 6293

Olap tools

1653

What is the difference Delete and Drop ?

6 7163

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 12859

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

HCL,

2 4010

What is $FLEX$ and $PROFILES$?

2 6735

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

4 9372

what is meant by databases

4 4823

what is sql injection in sql server?

TATA,

2 5308

Un-Answered Questions { Databases }

Please explain oracle data types with examples?

582

Can I use sql in mongodb?

Is there an example how to configure externalfileaccess setting in firebird.conf?

468

Can you tell the difference between ereg_replace() and eregi_replace()?

524

What are five main functions of a database administrator?

452

Which is best database?

489

What is the difference among union, minus and intersect?

538

Can we do dml on views?

544

What is difference between inner join and cross join?

516

What is a deterministic function?

591

How bulk collect improves performance?

566

how would you store your query in an SSRS report or a Database server?

116

explain extended properties

560

Explain raise_application_error.

640

I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object

2267

For More Un-Answered { Databases } Questions Click Here