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

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 5916

What are the advantages of the packages

Oracle,

6 12341

what are the advantages of primary key over unique+notnull

Consultancy, LGS, Oracle,

7 22526

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

Oracle,

31 42835

what are the forced views

Hexaware, TCS,

6 26081

what is the difference between union and union all

IBM, Luxoft, Oracle,

14 47092

what is hash join

NCR,

1 13846

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 3243

what is meant by DML?

HCL,

5 12843

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

1 5155

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 4788

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

HCL, Wipro,

1 5458

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

Accenture, IBM,

1 9598

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

2 6603

Where would you look for errors from the database engine?

Fintellix,

2 12177

Un-Answered Questions { Databases }

What are the components required to manage oracle real application clusters database?

What is trigger in pl sql?

1053

What is the default table size in sybase?

951

Can varchar be primary key?

979

What happens in oracle commit?

1082

explain GROUPBY & HAVING clause with examples.

2334

How do I find duplicates in two columns?

1269

Why Master database is required?

1192

What is the maximum number of columns in sql table?

1232

What is sqlservr.exe - process - sql server (sqlex?press)?

1158

Can mysql store files?

973

What are the three different part of rdl file explain them?

276

How do I start mysql client?

1009

How can I insert images into a Mysql database?

1112

Explain can SSRS reports Cache results?

161

For More Un-Answered { Databases } Questions Click Here