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 9016

What are the steps involved in Database Startup ?

247Customer,

2 6978

What are the steps involved in Database Shutdown ?

1 5462

What is Restricted Mode of Instance Startup ?

1 4849

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

1 7260

What is Full Backup ?

3 6150

Can Full Backup be performed when the database is open ?

1 5029

What is Partial Backup ?

2 7443

What is On-line Redo Log?

2 5334

What is Mirrored on-line Redo Log ?

2 4967

What is Archived Redo Log ?

3 5497

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

2 7389

What is Log Switch ?

2 7066

What are the steps involved in Instance Recovery ?

ibcs primax,

1 7149

Can a formula column be obtained through a select statement?

TCS,

1 8184

Un-Answered Questions { Databases }

How do I start mysql database?

910

What are queries used for?

897

What is a simple query?

846

State few characteristics of pl/sql?

931

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

1010

Where sql server usernames and passwords are stored in a sql server?

936

Is postgres a database?

769

Is there any restriction on the use of union in embedded sql?

1103

How to return the date part only from a sql server datetime datatype?

1024

Can a database be shrunk to 0 bytes, if not, why?

1041

What is the usage of regular expressions in mysql?

858

What is "scheduled jobs" or "scheduled tasks"?

916

What is database migration in mysql?

953

How to delete a login name in ms sql server?

1006

Why do we need cursors in pl sql?

1005

For More Un-Answered { Databases } Questions Click Here