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

What do you mean by cluster and non cluster index?

1096

Explain entity ?

1047

What are the advantages of views in a database?

1201

Explain natural key?

1155

Explain entity set?

1033

List the properties of a transaction.

1084

Explain buffer manager?

965

Explain the various types of normalization.

1097

Explain coalesce. What is the equivalent of oracle/db2 coalesce function in sybase?

868

Explain defncopy and it's usage?

987

How do you check database space? What measures are there to increase the db space?

966

What causes re-resolution of a stored procedure in sybase?

911

You need to add a notnull column in a table by using alter command (without using default command). How would you do that?

967

Explain procedure cache?

980

What is sybase? What are its important features?

1035

Un-Answered Questions { Databases }

Define model database?

998

Is it important to partition hard disk?

1037

How to call shell script from pl sql procedure?

1294

Can you explain the select into statement?

1041

How to call a stored function with parameters?

1053

Explain the purpose of %type and %rowtype data types?

945

What are the tools of ms access?

810

What is crud sql?

999

Can we rollback after truncate?

1042

What is wide table?

964

what is blob? : Sql dba

1162

What is the source code of a program?

1084

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

3897

What is foreign key in mysql?

1060

Why olap is used?

989

For More Un-Answered { Databases } Questions Click Here