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

Oracle (3239)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3312)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1391)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

Can anybody explain me cold backup and hot backup?

TCS,

3 14858

whate is advantages of sql server 2000

1663

Sybase 12.5 Database Statistics (Maximum)

1 7697

Sybase system databases

2 12388

what is the purpose of creating view is sql server 2000

Wipro,

13 18532

why cluster and non clusterindex are used in sqlserver 2000? explain with example

1 4184

hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 2000

3 5326

what is JOIN? Give example & types of join?

iMedia, Millennium, RAM Software, Satyam,

14 38320

WHAT KIND OF TOOL BO IS?

APC,

1840

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

1645

HOW TO SPOT AHIERARCHY?

1847

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

1 2828

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

1619

CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

1610

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2388

Un-Answered Questions { Databases }

Where not exists in sql?

503

What is the difference between functions and stored procedures?

614

How to enforce security in sql server? : sql server security

619

How to raise user-defined exception with custom sqlerrm ?

678

How to get the definition of a stored procedure back?

524

Why is mysql popular?

483

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

1695

What is the purpose of normalisation?

513

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1629

What is the main purpose of having conversation group?

494

What are indexes in ms sql server?

549

What command must you use to include the not null constraint after a table has already been created?

542

Does uninstalling mysql delete database?

491

Will truncate release space?

514

Is declare cursor executable?

529

For More Un-Answered { Databases } Questions Click Here