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

How will you a activate/deactivate integrity constraints?

2 9193

What are the steps involved in Database Startup ?

247Customer,

2 7137

What are the steps involved in Database Shutdown ?

1 5579

What is Restricted Mode of Instance Startup ?

1 5013

What are the different modes of mounting a Database with the Parallel Server ?

1 7366

What is Full Backup ?

3 6303

Can Full Backup be performed when the database is open ?

1 5122

What is Partial Backup ?

2 7591

What is On-line Redo Log?

2 5439

What is Mirrored on-line Redo Log ?

2 5109

What is Archived Redo Log ?

3 5675

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?

2 7536

What is Log Switch ?

2 7251

What are the steps involved in Instance Recovery ?

ibcs primax,

1 7280

Can a formula column be obtained through a select statement?

TCS,

1 8292

Un-Answered Questions { Databases }

What is varchar data type in sql?

1084

How do I download mysql?

889

What are the built in functions of sql?

1030

How do you define a foreign key?

1004

What does it mean to invest in the index?

973

What language does postgresql use?

783

How to recover a dropped table in oracle?

1048

How do I run a query in mysql?

943

How data locks are respected in oracle?

1071

What is n tier architecture with example?

763

How do you update f as m and m as f from the below table testtable?

1858

What is error ora-01000: maximum open cursors exceeded

1147

Which is better mysql or ms access?

852

Explain the difference between primary key and candidate key in mysql?

965

How do I check if log truncation is blocked in sybase?

822

For More Un-Answered { Databases } Questions Click Here