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 6193

What are primary keys and foreign keys?

4 8223

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

3 11512

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

1 6459

How m-m relationships are implemented?

2 8331

How do you know which index a table is using?

4 12936

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

3 8452

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

2 9001

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

9 24342

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

Infosys,

4 11982

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

3 10265

Which virtual table does a trigger use?

TCS,

8 27465

How do you measure the performance of a stored procedure?

Infosys,

3 16221

Questions regarding Raiseerror?

1 6898

Questions on identity?

Infosys,

2 7044

Un-Answered Questions { Databases }

How to compare dates in oracle sql?

1116

What do you understand by anchoring in reports?

Explain the use of full option in exp command.

1127

List types of tables in SQL Azure?

126

What is the difference between "as" and "is" in an oracle stored procedure?

1009

What is oracle sql developer?

1077

Is microsoft access still relevant 2018?

757

Can a procedure in a package be overloaded?

1058

Difference between LEN() and DATALENGTH() in sql server ?

1139

Do indexes speed up queries?

934

How to select 10 records from a table?

1171

What are different types of transactions in ar? : oracle accounts receivable

1312

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

1153

What is the difference between unique and primary key constraints?

1085

What are page splits?

1009

For More Un-Answered { Databases } Questions Click Here