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

what is differece between union and union all

6 10230

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 3464

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.)

2 5412

If CPU is very slow What can u do to speed up?

1 4520

how to eliminate duplictes in column except group and section?

iFlex, TCS,

2 7114

Is trigger fired implicitely?

2 5706

Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?

eBay,

3 12401

How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?

IBM, TCS, UHD,

12 29289

how do we find every fifth record in a table

Aspire, HCL,

14 18789

if we give update table_name set column_name= default. what will happen?

iFlex,

4 9772

if we give update table_name set column_name= default. what will happen? its given in pl sql block.what will hapen?

iFlex,

5 11659

how will u find statistics of a database objects?

iFlex,

2 8656

How can we expand Parameter Form Canvas on Reports 6i?

ABB,

2426

Hi Every One , What is the table Space in Oracle Database ? waiting for answere and thankyou

8 11530

What is the appropriate number of test cases that you can write on a database?

Microsoft,

2 7054

Un-Answered Questions { Databases }

What is a foreign key constraint why are such constraints important?

792

how is myisam table stored? : Sql dba

1062

What are the pre-defined functions in the sql server?

1119

What is the sequence of firing in report trigger?

What is the maximum size per database for sql server express?

1059

How to load excel data sheet to oracle database

1030

Can we call a function containing dml statements in a select query?

988

Explain why variables called the most powerful component of ssis?

1104

When do we use triggers?

1086

What is the purpose of a database table?

946

What is a join query?

970

What are oracle functions?

1035

What is etl process in data warehousing? What are the different stages in 'data warehousing'?

852

What is bcnf in the dbms?

943

How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?

1934

For More Un-Answered { Databases } Questions Click Here