Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3253)
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 9305

What are the steps involved in Database Startup ?

247Customer,

2 7264

What are the steps involved in Database Shutdown ?

1 5683

What is Restricted Mode of Instance Startup ?

1 5122

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

1 7446

What is Full Backup ?

3 6443

Can Full Backup be performed when the database is open ?

1 5213

What is Partial Backup ?

2 7695

What is On-line Redo Log?

2 5533

What is Mirrored on-line Redo Log ?

2 5219

What is Archived Redo Log ?

3 5792

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

2 7639

What is Log Switch ?

2 7369

What are the steps involved in Instance Recovery ?

ibcs primax,

1 7373

Can a formula column be obtained through a select statement?

TCS,

1 8382

Un-Answered Questions { Databases }

What is meant by a deadlock situation?

1154

What is pg_hba conf file?

857

How to enter unicode character string literals in ms sql server?

1123

Disadvantages of the indexes?

1184

What is the difference between sga and pga?

662

What is reference section?

1057

What are the extra roles available in msdb? : sql server security

1179

What is data source in connection string?

958

Explain the process of recievables in oracle financials. : oracle accounts receivable

1202

How do you break a loop in pl sql?

1102

What happens if you keep split brain syndrome in rac unresolved? How it can be resolved?

What are the different stages in 'data warehousing'?

1045

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

1045

What will be the maximum size of an extent of a segment if the tablepac's default storage values are specified as (initial 8K next 16k minextent 4 pctincrease 100).Explain.

1939

What is the “__v” field in mongoose?

For More Un-Answered { Databases } Questions Click Here