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

What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?

1 4017

What is RULE-based approach to optimization ?

1 5397

What is COST-based approach to optimization ?

5 9041

What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

2 7418

What is a Procedure ?

3 8212

What is difference between Procedures and Functions ?

Hi Caliber IT,

6 10635

What are the differences between Database Trigger and Integrity constraints ?

4 18431

What is Distributed database ?

2 9757

What is Two-Phase Commit ?

3 6026

Describe two phases of Two-phase commit ?

2 4447

What is the mechanism provided by ORACLE for table replication ?

1 3948

What is a SQL * NET?

2 4702

What are the basic elements of Base configuration of an oracle Database ?

1 5854

What are the factors causing the reparsing of SQL statements in SGA?

1 4235

What is the use of Snapshot?

2 5438

Un-Answered Questions { Databases }

What will have to do if a shard is down or slow and you do a query?

Explain database partitioning. What is its importance?

1255

What is use of foreign key?

934

What is an oracle?

1069

Explain about link server in sql server?

1118

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2858

How to execute a stored program unit?

1128

What is left outer join in sql server joins?

1108

What is supporting issues GL AP and AR?

2619

What are the technical specifications of mysql?

1211

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

1100

What command helps you to know the process running on this port, but only su can run this command?

983

What are the important features of ms access?

946

Which tcp/ip port does the sql server run on? How can it be changed?

1116

Can we use ddl commands in pl sql?

1235

For More Un-Answered { Databases } Questions Click Here