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 5915

What are the advantages of the packages

Oracle,

6 12328

what are the advantages of primary key over unique+notnull

Consultancy, LGS, Oracle,

7 22513

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

Oracle,

31 42782

what are the forced views

Hexaware, TCS,

6 26078

what is the difference between union and union all

IBM, Luxoft, Oracle,

14 47074

what is hash join

NCR,

1 13845

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 3240

what is meant by DML?

HCL,

5 12835

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

1 5153

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 4787

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

HCL, Wipro,

1 5454

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 6597

Where would you look for errors from the database engine?

Fintellix,

2 12174

Un-Answered Questions { Databases }

What are “lost updates”?

1045

What sql database should I use?

1201

How do you optimize a stored procedure in sql?

1019

Is microsoft access pc only?

805

What is sybase used for?

1020

What is a server parameter file in oracle?

1098

What are the benefits and tasks of object explorer? : sql server management studio

1258

Does sql server 2000 full-text search support clustering?

915

What is dbcc? : sql server DBA

1353

What is the rdbms concept in sql?

1049

What is an execution plan? How would you view the execution plan?

1131

How do I view a sql trace file?

1063

what is the difference between a having clause and a where clause? : Sql dba

1159

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1166

What is a temporal data type?

1114

For More Un-Answered { Databases } Questions Click Here