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 10269

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 3486

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 5427

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

1 4533

how to eliminate duplictes in column except group and section?

iFlex, TCS,

2 7134

Is trigger fired implicitely?

2 5717

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 12418

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

IBM, TCS, UHD,

12 29353

how do we find every fifth record in a table

Aspire, HCL,

14 18887

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

iFlex,

4 9804

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

iFlex,

5 11689

how will u find statistics of a database objects?

iFlex,

2 8677

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

ABB,

2442

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

8 11574

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

Microsoft,

2 7074

Un-Answered Questions { Databases }

Is there a version of microsoft access for mac?

878

Why we use triggers in mysql?

1003

How do I drop a table in postgresql?

827

How to add a new column to an existing table in mysql?

1004

How to create an multi-statement table-valued function?

1018

why would you call update statistics? : Sql server database administration

1106

What are the fixed server level roles? : sql server security

1151

What are the properties of sub-query?

1090

Explain correlated query work?

1064

How to add another datafile to a tablespace?

1051

What is ssrs?

131

Is there a limitation on the size of a database that can be opened in microsoft access?if yes, what?

858

What is a behavioral trigger?

987

What are literals in sql server?

1189

Explain the hierarchical database?

1012

For More Un-Answered { Databases } Questions Click Here