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 14873

whate is advantages of sql server 2000

1667

Sybase 12.5 Database Statistics (Maximum)

1 7705

Sybase system databases

2 12399

what is the purpose of creating view is sql server 2000

Wipro,

13 18579

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

1 4194

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 5345

what is JOIN? Give example & types of join?

iMedia, Millennium, RAM Software, Satyam,

14 38372

WHAT KIND OF TOOL BO IS?

APC,

1844

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

1652

HOW TO SPOT AHIERARCHY?

1851

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

1 2840

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

1626

CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

1618

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2392

Un-Answered Questions { Databases }

What is 2nf normalization?

542

Explain vdl (view definition language)?

646

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

3994

Can the query output be sorted by multiple columns in ms sql server?

555

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

3760

Can we store images in database?

471

What is benefit of creating memory optimized table?

543

How do I copy and paste data from excel to access?

418

What is ase database?

557

what is a deadlock? : Sql server database administration

503

What are the benefits of ms access?

414

What is PROJECTION Operation?

612

Mention the different languages present in dbms

519

What are the system database in sql server 2008?

579

What is user-defined scalar function?

561

For More Un-Answered { Databases } Questions Click Here