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 8736

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 7875

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

HP,

2 7990

does physical index sort data

1 3875

what type of indexes physically sort data?

3 7350

Olap tools

2119

What is the difference Delete and Drop ?

6 9071

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 14623

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

HCL,

2 4950

What is $FLEX$ and $PROFILES$?

2 7590

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

4 10832

what is meant by databases

4 6364

what is sql injection in sql server?

TATA,

2 6521

Un-Answered Questions { Databases }

How can you fetch common records from two tables?

1063

What is trigger explain it?

1015

What do you understand by the term 'normalization'? Explain the various modes of normalization?

556

Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?

975

What is NOT NULL Constraint in sql server 2012?

1000

In pl/sql, what is bulk binding, and when/how would it help performance?

994

What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?

4617

How to display Row Number with Records in Oracle SQL Plus?

1047

What is database dimension? : sql server analysis services, ssas

1077

What is a join in sql? What are the types of joins?

1105

How do you create type- insensitive operator?

1043

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

1015

How do I start microsoft access on my computer?

868

How to copy the tables, schema and views from one sql server to another?

1047

Why we use cross join?

952

For More Un-Answered { Databases } Questions Click Here