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

utility used to obtain inform regarding the optimizes choice of access strategy for SQL stmts A) LOAD B) REORG C) COPY D) EXPLAIN

Accenture,

2 5807

What are the advantages of the packages

Oracle,

6 12169

what are the advantages of primary key over unique+notnull

Consultancy, LGS, Oracle,

7 22316

how to retrieve the top 3 salaries of the table using rownum

Oracle,

31 41867

what are the forced views

Hexaware, TCS,

6 25871

what is the difference between union and union all

IBM, Luxoft, Oracle,

14 46591

what is hash join

NCR,

1 13766

Could u tell me, u work as a support & maintenace when sub ledger and gl is mismatch, then how do u match with the both side/

HCL,

1 3171

what is meant by DML?

HCL,

5 12596

Explain the difference between a hot backup and a cold backup and the benefits associated with each

1 5082

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

1 4676

How do you switch from an init.ora file to a spfile?

HCL, Wipro,

1 5366

Explain the difference between a data block, an extent and a segment.

Accenture, IBM,

1 9526

Give two examples of how you might determine the structure of the table DEPT.

2 6485

Where would you look for errors from the database engine?

Fintellix,

2 12065

Un-Answered Questions { Databases }

What is a deterministic function?

1073

What is the usage of distinct keyword?

1069

How to use "for" statements in oracle?

1076

How do I order by ascending in sql?

1027

Explain what are clusters?

1113

Is sql a programming?

980

What is concurrency control?

1026

what are the advantages of running a database in archive log mode?

2205

What is mysql architecture?

1014

What is an access macro?

863

What is the source code of a program?

1075

What is index and also explain types of indexing in dbms?

972

What is a stored procedure in sql with example?

1137

How can I combine multiple rows into a comma-delimited list in oracle?

1062

Define atomicity and aggregation.

1037

For More Un-Answered { Databases } Questions Click Here