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 5803

What are the advantages of the packages

Oracle,

6 12162

what are the advantages of primary key over unique+notnull

Consultancy, LGS, Oracle,

7 22308

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

Oracle,

31 41843

what are the forced views

Hexaware, TCS,

6 25865

what is the difference between union and union all

IBM, Luxoft, Oracle,

14 46571

what is hash join

NCR,

1 13765

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 12591

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 4674

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

HCL, Wipro,

1 5362

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

Accenture, IBM,

1 9525

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

2 6484

Where would you look for errors from the database engine?

Fintellix,

2 12063

Un-Answered Questions { Databases }

What is 3NF?

872

Does table partitioning require user-defined segments in sybase?

797

Why function is used in sql?

951

When is the use of update_statistics command?

1009

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1151

How to create table show example

981

What are all different types of collation sensitivity?

1035

How to run the anonymous block again?

1132

Can we join tables without foreign key?

964

How to create a simple stored procedure in ms sql server?

1032

Can ddl statements be used in pl/sql?

1145

How to connect to a sql server using odbc_connect()?

1157

How can I create database in mysql?

930

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1987

Tell me what are cursors and when they are useful?

956

For More Un-Answered { Databases } Questions Click Here