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

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

1041

How exception handling is done in advance pl/sql?

990

Mention what does plv msg allows you to do?

1133

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

1061

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

1235

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

1255

Mention what plvcmt and plvrb does in pl/sql?

1153

What are aggregate and scalar functions?

1045

What is user defined functions?

993

How to select unique records from a table?

1066

What are tables and fields?

1054

Advantages and disadvantages of stored procedure?

1138

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

1416

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

1121

What is online transaction processing (oltp)?

1036

Un-Answered Questions { Databases }

How to load data from file to file and what are the KM's required for this requirement?

639

Tell me what is a linked server?

1049

Why it is recommended to avoid referencing a floating point column in the where clause?

976

What is the process of indexing?

1025

How do you import data from another access database?

885

What are the methods used to protect against sql injection attack?

1082

What is a covered index?

950

Write short notes on manual refreshes.

2755

What does pragma mean?

1071

How can you list all the columns in a database?

948

Explain about unique identifier data type in sql server?

924

What is the file extension for sql database?

1014

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2311

What is msdb database? : SQL Server Architecture

1149

What are the ansi data types supported in oracle?

962

For More Un-Answered { Databases } Questions Click Here