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 9192

What are the steps involved in Database Startup ?

247Customer,

2 7133

What are the steps involved in Database Shutdown ?

1 5577

What is Restricted Mode of Instance Startup ?

1 5012

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 5122

What is Partial Backup ?

2 7588

What is On-line Redo Log?

2 5437

What is Mirrored on-line Redo Log ?

2 5109

What is Archived Redo Log ?

3 5673

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 7248

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 }

How many sql are there?

996

How to connect php with different port numbers?

1085

How to create an initialization parameter file?

1049

What is set nocount on?

938

What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?

627

Discuss some of the techniques that can be used to tune operational performance.

952

what stored procedure can you use to display the current processes? : Sql server administration

1010

what is a deadlock? : Sql server database administration

1064

What the different types of Replication and why are they used?

1071

What is sql prepared statement?

983

What are all the ddl commands?

1183

What is normalization in a database?

1154

how you will Create a database on the mysql server with unix shell.

1047

What is max rowid in oracle?

1025

What are the applications required to support mysql?

960

For More Un-Answered { Databases } Questions Click Here