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

What is a job?

3 6190

What are primary keys and foreign keys?

4 8212

How would you Update the rows which are divisible by 10, given a set of numbers in column?

3 11507

If a stored procedure is taking a table data type, how it looks?

1 6456

How m-m relationships are implemented?

2 8328

How do you know which index a table is using?

4 12930

How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?

3 8449

How do you find the error, how can you know the number of rows effected by last SQL statement?

2 8999

How can you get @@error and @@rowcount at the same time?

9 24337

What are sub-queries? Give example? In which case sub-queries are not feasible?

Infosys,

4 11977

What are the type of joins? When do we use Outer and Self joins?

3 10258

Which virtual table does a trigger use?

TCS,

8 27461

How do you measure the performance of a stored procedure?

Infosys,

3 16220

Questions regarding Raiseerror?

1 6898

Questions on identity?

Infosys,

2 7040

Un-Answered Questions { Databases }

What is the difference between translate and replace?

1074

Explain a synonym?

1039

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1342

What is Session Tasks?

608

Which are the olap features?

968

How do you limit the number of result returned?

What is the difference between a database and instance?

704

Why do not you use gnu autoconf or scons for building?

950

What are different backups available in sql server?

1085

What are types of exception?

924

What is the main purpose of normalization?

1042

What is a lookup table in access?

942

What is transactional replication?

976

What is the difference between varchar and varchar types?

1080

What is pl sql block structure?

1046

For More Un-Answered { Databases } Questions Click Here