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

Which function is used to return remainder in a division operator in sql?

1156

What is the usage of distinct keyword?

1086

Are null values same as that of zero or a blank space?

1049

What is the difference between cross join and natural join?

1043

What do you mean by “trigger” in sql?

1100

What is the usage of nvl function?

1071

List and explain the different types of join clauses supported in ansi-standard sql?

1371

List the various privileges that a user can grant to another user?

1059

What is acid property in a database?

1045

What are the different operators available in sql?

1019

What are all the different normalizations?

1046

When is the explicit cursor used ?

1045

How does one load ebcdic data? : aql loader

1200

What is the difference between the sql*loader and import utilities? : aql loader

1060

What is the sql*loader? : aql loader

1070

Un-Answered Questions { Databases }

Why are cursors used?

1133

What is the main purpose of having conversation group?

912

What are the column comparisons operators?

1252

What is the security model used in sql server 2005?

1031

What is an oracle cursor variable?

1103

What is a super key? How is it different from a candidate key?

826

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??

1758

Define outer join?

1013

Explain about sql server login?

1100

What is the cartesian product of the table?

973

Explain superior keys and candidate keys.

853

When should you increase copy latches? What parameters control copy latches?

586

what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

2228

Why is foreign key used?

852

What is the fillfactor concept in indexes?

1001

For More Un-Answered { Databases } Questions Click Here