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

What is a job?

3 6334

What are primary keys and foreign keys?

4 8687

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

3 11652

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

1 6530

How m-m relationships are implemented?

2 8422

How do you know which index a table is using?

4 13125

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

3 8556

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

2 9093

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

9 24559

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

Infosys,

4 12171

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

3 10377

Which virtual table does a trigger use?

TCS,

8 27733

How do you measure the performance of a stored procedure?

Infosys,

3 16358

Questions regarding Raiseerror?

1 6973

Questions on identity?

Infosys,

2 7134

Un-Answered Questions { Databases }

is it possible to pass an object or table to a procedure as an argument?

1188

How do I create a mysql database?

977

How to connect a sql*plus session to an oracle server?

1180

What is CTE in SQL

1003

How do I connect to sybase?

920

What is the report model project?

151

PostgreSql Disadvantages

1989

Does mongodb support primary-key, foreign-key relationship?

Please explain what is “asynchronous” communication in sql server service broker?

988

What are different categories of sql commands?

1202

What is use of except clause?

1151

Explain the uses of a database trigger?

1096

What does clouddb kit mean?

Difference between Row Id and Row Num?

737

Describe the types of keys?

1204

For More Un-Answered { Databases } Questions Click Here