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,

1102

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

TryTechnicals Pvt Ltd,

1112

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

Microsoft,

1123

What is the Main Difference between ACCESS and SQL SERVER?

MindCracker,

1196

How to throw custom exception in Stored Procedure?

MCN Solutions,

1103

What is Virtual Private Database in Oracle?

MCN Solutions,

1160

Can we create database in oracle using command line ?

MCN Solutions,

1136

Why use resource manager in Oracle?

MCN Solutions,

1177

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

MCN Solutions,

1208

What is Undo Management Advisor in Oracle?

MCN Solutions,

1156

What is Redo Log Buffer in Oracle?

MCN Solutions,

1296

What is clustered table in Oracle?

MCN Solutions,

1271

What is data block in Oracle?

MCN Solutions,

1157

How can Oracle users be audited?

MCN Solutions,

1178

What is recovery manager(rman) backup in Oracle?

MCN Solutions,

1235

Un-Answered Questions { Databases }

How to get the number of rows selected or affected by a sql statement?

977

What is the use of lockboxes? : oracle accounts receivable

1274

What are the daily activities of oracle dba?

664

Explain about extended stored procedure?

1000

How remove data files before opening a database?

1142

What is the difference in storage type of numeric and decimal data types in sybase ?

921

Write a trigger example in oracle?

1124

How do I spool in oracle?

1071

What is an entity-relationship diagram (erd)?

1330

How do I add a primary key in pgadmin?

887

List different type of expressions with the example.

977

What is DDL (Data Definition Language)?

943

How do you use join?

997

How do I add another column in postgresql?

893

What is 5nf in normalization form?

1048

For More Un-Answered { Databases } Questions Click Here