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

Explain how can you save or place your msg in a table?

1 1092

How exception handling is done in advance pl/sql?

1 1043

Mention what does plv msg allows you to do?

1 1177

Mention what is the use of function "module procedure" in pl/sql?

1 1111

Why plvtab is considered as the easiest way to access the pl/sql table?

1 1318

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1 1306

Mention what plvcmt and plvrb does in pl/sql?

1 1224

What are aggregate and scalar functions?

1 1101

What is user defined functions?

1 1043

How to select unique records from a table?

1 1127

What are tables and fields?

1 1106

Advantages and disadvantages of stored procedure?

1 1180

What is the command used to fetch first 5 characters of the string?

1 1481

What is the difference between cluster and non-cluster index?

1 1176

What is online transaction processing (oltp)?

1 1080

Un-Answered Questions { Databases }

How to provide default values to function parameters?

1242

How to remove duplicate rows from table except one?

1077

What is a scheduled job or what is a scheduled task?

1029

how many tables will create when we create table, what are they? : Sql dba

1136

List out the different types of locks available in sql server?

1041

What is clustered index

1081

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1184

Any work done in oracle workflow builder. Did you customize or build a new workflow?

Does group by remove duplicates?

1106

How to convert numeric expression data types using the cast() function?

1142

Is inner join faster than left join?

1271

do you know how to configure db2 side of the application? : Sql server database administration

1113

What versions of clipper does netlib support?

1076

How to use values from other tables in update statements using oracle?

1144

Can we rollback truncate?

1070

For More Un-Answered { Databases } Questions Click Here