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 6318

What are primary keys and foreign keys?

4 8604

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

3 11635

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

1 6526

How m-m relationships are implemented?

2 8411

How do you know which index a table is using?

4 13093

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

3 8546

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

2 9078

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

9 24522

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

Infosys,

4 12153

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

3 10363

Which virtual table does a trigger use?

TCS,

8 27690

How do you measure the performance of a stored procedure?

Infosys,

3 16331

Questions regarding Raiseerror?

1 6964

Questions on identity?

Infosys,

2 7127

Un-Answered Questions { Databases }

What is definer in mysql?

1010

Is crud a cuss word?

1075

What is local database?

1015

How do I connect to postgresql access?

1087

What is Lossless join property?

1022

Advantages and disadvantages of stored procedure?

1172

What is join query?

938

What are 5 benefits to using access?

928

How would you best determine why your MVIEW couldn't FAST REFRESH?

2414

Can you tell any two advantages of stored procedures?

1095

How can you know that statistics should be updated?

1130

What are mysql queries?

972

What is an Oracle database Partial Backup?

1208

What is federated tables in mysql?

963

What are the uses of mongodb?

For More Un-Answered { Databases } Questions Click Here