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 is the difference between column level constraints and table level constraints?

IBM, TCS,

14 87567

Can we create index on views?

CTS, Syntel, TCS,

19 125988

Can we create more than one index on particular column?

1 6383

What is a cluster?

2 5724

What is the difference between implicit index and explicit index?

TCS,

2 24204

What are virtual columns?

TCS,

2 7276

What is a materialised view?

5 8689

What is the difference between normal and corelated subqueries?

2 9875

what is sql and plsql

6 11338

what is the difference between to_char and to_date functions?

Infosys,

10 67256

what is organisational index?

1 5325

what are the advantages of cursors than procedures?

2 12011

what is the difference between trigger and storedprocedures

Tech Mahindra,

16 32530

What is a Database instance ? Explain?

3 8285

What is Parallel Server ?

3 5866

Un-Answered Questions { Databases }

Explain left outer join and right outer join?

1048

What is an oracle?

1027

How are the stats updated in postgresql?

866

What are various ways to enhance the ssrs report?

991

How many data types are supported?

1089

How do you delete data on pgadmin?

831

how many type of indexing in database?

989

write an SQL query to list the employees who joined in the month of January?

1685

Enlist ways to efficiently code transactions.

1124

What are the uses of synonyms?

1146

What are the five steps of data modeling?

997

What are the data management skills?

559

How do I completely remove sql server instance?

1110

Explain what is a deadlock and mention how it can be resolved?

896

What are different types of data models available? Explain with example?

1118

For More Un-Answered { Databases } Questions Click Here