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 9190

What are the steps involved in Database Startup ?

247Customer,

2 7129

What are the steps involved in Database Shutdown ?

1 5576

What is Restricted Mode of Instance Startup ?

1 5011

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

1 7364

What is Full Backup ?

3 6302

Can Full Backup be performed when the database is open ?

1 5120

What is Partial Backup ?

2 7588

What is On-line Redo Log?

2 5435

What is Mirrored on-line Redo Log ?

2 5107

What is Archived Redo Log ?

3 5670

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

2 7534

What is Log Switch ?

2 7245

What are the steps involved in Instance Recovery ?

ibcs primax,

1 7278

Can a formula column be obtained through a select statement?

TCS,

1 8290

Un-Answered Questions { Databases }

Is mysql connect deprecated?

963

Give me any three differences between Truncate and Delete.

1107

What is difference between database and schema?

991

Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

1145

How do I check mysql version?

1041

What is sqlite used for?

999

What is rank () in sql?

941

What is mysql shell?

985

What is the difference between clustered and non-clustered indexes?

1089

By default, which index is created by mongodb for every collection?

Why use “in” clause in sql server?

1071

List the different types of joins?

1001

Explain the designer?

625

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

951

What types of joins are used in writing subqueries?

982

For More Un-Answered { Databases } Questions Click Here