Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3253)
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 10363

what eliminate duplicate without using roenum and not

Matrix,

5 11048

deference between & and &&

Mphasis,

2 16135

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

HCL,

3 11524

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

2 28009

What is the difference between SSAS 2000 and SSAS 2005?

APX,

1 7528

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

APX,

6 15133

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

4 20407

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2349

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

1 2312

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 12549

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 17671

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

CybAge,

1 6544

What is the default identifier of structure in C?

CybAge,

3 7030

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

CybAge, Wipro,

8 15107

Un-Answered Questions { Databases }

What is acid mean in sql server?

1240

How can I check that whether automatic statistic update is enabled or not?

1109

how to escape special characters in sql statements? : Sql dba

1111

How can you append an identity column to a temporary table?

1067

how many tables will create when we create table, what are they? : Sql dba

1140

What is standby servers? Explain types of standby servers.

1076

Have you used lexical parameters in reports?

Why we use the openxml clause?

1072

What are the types of database explain each of them briefly?

1054

What are the steps in creating a database?

1008

how to use regular expression in pattern match conditions? : Sql dba

1106

Where can you add custom error messages to sql server?

1204

Is primary key always clustered index?

1093

What is the difference between upgrade and migration in sql server?

1179

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8226

For More Un-Answered { Databases } Questions Click Here