Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3239)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3312)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1391)
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 4527

What are the advantages of the packages

Oracle,

6 10186

what are the advantages of primary key over unique+notnull

Consultancy, LGS, Oracle,

7 20086

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

Oracle,

31 33951

what are the forced views

Hexaware, TCS,

6 23549

what is the difference between union and union all

IBM, Luxoft, Oracle,

14 42143

what is hash join

NCR,

1 12845

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 2400

what is meant by DML?

HCL,

5 10707

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

1 4270

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 3804

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

HCL, Wipro,

1 4264

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

Accenture, IBM,

1 8466

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

2 5135

Where would you look for errors from the database engine?

Fintellix,

2 10533

Un-Answered Questions { Databases }

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1125

What is change tracking in sql server?

551

Explain the difference between 'between' & 'and' operators in sql

531

How to connect asp pages to oracle servers?

577

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

1615

How do I drop a collection in mongodb? Write it's syntax

Please explain drop constraint oracle?

629

What is indexed view? How to create it?

599

How many columns are in access?

429

How do I change the order of columns in postgresql?

446

What is the load balancing advisory?

Can a composite key be null?

532

What sql does db2 use?

544

What is the role of tables in database?

480

What are the purposes of using enum and set data types?

510

For More Un-Answered { Databases } Questions Click Here