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 to create user in sql and how to set password for that?

3 10177

what eliminate duplicate without using roenum and not

Matrix,

5 10725

deference between & and &&

Mphasis,

2 15975

what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?

HCL,

3 11328

When to use Place holder columns in Oracle Reports and what is a place holder column?

2 27849

What is the difference between SSAS 2000 and SSAS 2005?

APX,

1 7397

PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs.

APX,

6 14822

How One can easily select all even, odd, or Nth rows from a table using SQL queries?

4 20199

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2280

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2221

please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person

10 12045

can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3

Google,

15 16988

Which is the best sorting method if i have to sort the students of Harvard University according to their first name?

CybAge,

1 6448

What is the default identifier of structure in C?

CybAge,

3 6802

Can we have a function Overloading with same number of arguments but with different return types of function

CybAge, Wipro,

8 14744

Un-Answered Questions { Databases }

What are click through reports?

142

how can you pass values to-and-fro from foreign function?

What os user should be used for the first part of an oracle installation (on unix)?

549

please explain.. DB architecture ...

2020

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

970

Can you tell how to find the number of rows in a resultset using php?

902

What is a function in postgresql?

919

How to get month wise data in postgresql?

876

What are the differences between char and varchar?

1110

Mention the location of log files in couchdb?

What is data modeling with example?

998

How do I keep my database up to date?

929

What is the optimization being performed in oracle and SQL Server?

1050

What are properties of the transaction?

998

What is xml datatype?

1074

For More Un-Answered { Databases } Questions Click Here