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

Can anybody explain me cold backup and hot backup?

TCS,

3 16182

whate is advantages of sql server 2000

2164

Sybase 12.5 Database Statistics (Maximum)

1 8609

Sybase system databases

2 13648

what is the purpose of creating view is sql server 2000

Wipro,

13 22195

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

1 4853

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 6560

what is JOIN? Give example & types of join?

iMedia, Millennium, RAM Software, Satyam,

14 42526

WHAT KIND OF TOOL BO IS?

APC,

2335

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

2113

HOW TO SPOT AHIERARCHY?

2300

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

1 3584

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

2263

CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

2076

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2957

Un-Answered Questions { Databases }

Can sql servers linked to other servers?

1052

Can we write dml statement in function in oracle?

1088

Show how functions and procedures are called in a pl/sql block.

1133

Explain the working of foreign key?

1070

How can you move the master database

2051

Explain the different types of backups available in sql server? : sql server database administration

932

How to execute cql commands in neo4j?

How to send email from database?

1018

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

943

Explain materialized views and how they are used.

2445

What is the importance of sqlcode and sqlerrm?

1356

What is difference between mysql and mysqli?

926

What is procedures in mysql?

942

What is the difference between ddl,dml and dcl commands?

1116

Mention the types of join?

900

For More Un-Answered { Databases } Questions Click Here