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 10208

what eliminate duplicate without using roenum and not

Matrix,

5 10777

deference between & and &&

Mphasis,

2 16002

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

HCL,

3 11361

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

2 27869

What is the difference between SSAS 2000 and SSAS 2005?

APX,

1 7418

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

APX,

6 14872

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

4 20237

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2293

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2231

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 12117

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 17104

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

CybAge,

1 6470

What is the default identifier of structure in C?

CybAge,

3 6840

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

CybAge, Wipro,

8 14807

Un-Answered Questions { Databases }

How to create a table in a specific tablespace?

989

How index is used in mongodb?

What is a database? Explain

1124

What is sql server replication? : sql server replication

1002

What is the full meaning of mysql?

977

List few restrictions that are imposed while creating views?

890

What are the disadvantages of a query?

1036

What is the difference between shrink database and shrink file?

904

can u pls share responsibilities for production how to environment in odi?and how to generate report ?

2411

Tell me about standby database? What are some of the configurations of it? What should we watch out for?

557

Is blocked because of many connection errors mysql?

856

What is the benefit of foreign key?

1037

What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?

573

Differentiate between etl testing and manual testing.

Explain hostprotectionattribute in sql server 2005?

1045

For More Un-Answered { Databases } Questions Click Here