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 do you check database space?

1022

Explain autosys. Why do you need it.

983

What does –i option do in sybase tools?

1089

Explain index covering?

846

How would you list objects in sybase?

983

What is the default size of master database in sybase?

929

Explain index covering? List its merits.

978

Explain sybase sql server?

968

Explain tds (tabular data streams).

915

List similarities and differences between oracle & sybase.

985

Explain locking?

917

How would you configure burn factor in sybase?

951

What is the use of sp_helprotect in sybase?

983

How would you fix a munged log in sybase ?

972

I want to find out all databases starting with ‘test’, I have access to?

1170

Un-Answered Questions { Databases }

What is Java Pool in Oracle?

1189

What is the difference between NOROW and LOCKROW?

2859

How to make a copy values from one column to another in sql?

1049

What is oltp (online transaction processing)?

1026

What is pl sql block structure?

1050

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

1032

How to improve query performance using index hunting?

1191

Why do we need mongoose?

What does REVERT do in SQL Server 2005?

979

Explain indexed views and partitioned view with their syntax.

1158

What is forward - only cursors / read only cursor?

1101

If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?

581

What is normalization and why it is used?

1136

What are subqueries in sql server? Explain its properties.

1032

How to create a table?

1010

For More Un-Answered { Databases } Questions Click Here