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 5808

What are the advantages of the packages

Oracle,

6 12169

what are the advantages of primary key over unique+notnull

Consultancy, LGS, Oracle,

7 22318

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

Oracle,

31 41876

what are the forced views

Hexaware, TCS,

6 25875

what is the difference between union and union all

IBM, Luxoft, Oracle,

14 46595

what is hash join

NCR,

1 13767

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 3172

what is meant by DML?

HCL,

5 12598

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

1 5083

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 4677

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

HCL, Wipro,

1 5367

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 12066

Un-Answered Questions { Databases }

How can we expand Parameter Form Canvas on Reports 6i?

2426

What objects are present in the table msysobjects of microsoft access database?

839

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

989

What is the maximum length a text field can be in access?

760

what is difference between group above and group left report

3827

Why is nosql good?

1032

what systems can odi extract and load data into?

602

If you are working Microsoft excel, which type of file you used .excel or .csv?

645

How to display nth highest salary from a table in a mysql query?

996

What are the types of database schema? : sql server analysis services, ssas

1138

Why do gaps in sequences occur?

959

Why use “nolock” in sql server?

1064

How do you start single user mode in clustered installations?

948

What is the command syntax that tells you whether you are on the master server or not? And how many master does mongodb allow?

How to find the version of sql server? : sql server database administration

1119

For More Un-Answered { Databases } Questions Click Here