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

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

MCN Solutions,

1100

What is BCP? When does it used in sql server 2012?

TryTechnicals Pvt Ltd,

1110

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

Microsoft,

1118

What is the Main Difference between ACCESS and SQL SERVER?

MindCracker,

1192

How to throw custom exception in Stored Procedure?

MCN Solutions,

1099

What is Virtual Private Database in Oracle?

MCN Solutions,

1152

Can we create database in oracle using command line ?

MCN Solutions,

1136

Why use resource manager in Oracle?

MCN Solutions,

1175

What is the difference between view and materialized view in Oracle?

MCN Solutions,

1208

What is Undo Management Advisor in Oracle?

MCN Solutions,

1154

What is Redo Log Buffer in Oracle?

MCN Solutions,

1286

What is clustered table in Oracle?

MCN Solutions,

1267

What is data block in Oracle?

MCN Solutions,

1155

How can Oracle users be audited?

MCN Solutions,

1172

What is recovery manager(rman) backup in Oracle?

MCN Solutions,

1233

Un-Answered Questions { Databases }

Why mongodb logging so many “connection accepted” events?

System requirements for sql server 2005 express edition?

1072

What do you understand by the oracle?

596

What is oracle d2k?

How does a covering index work?

1013

How a table can be created using microsoft access object library (maol)?

1683

What is left outer join in sql server joins?

1112

Is mysql a rdbms?

955

Describe in brief system database.

1082

Explain the use of consistent option in exp command.

1146

What is sharding in mysql?

1019

Explain the use of assign statement in progress database?

965

Transactions are used to treat sets of SQL statements atomically. State Whether True or False?

1509

I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage

1592

How can you list all the table constraints in a database?

990

For More Un-Answered { Databases } Questions Click Here