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

What is the max nvarchar size?

1 1064

What is the difference between stored procedure and view?

1 1097

Is a table valued function object?

1 1102

What is function and procedure?

1 1093

What is vector point function?

1 1114

Which is better varchar or nvarchar?

1 1075

Why use stored procedures?

1 1157

Which is better stored procedure or query?

1 1041

Which command is used to call a stored procedure?

1 1071

What is meant by user defined function?

1 1114

Why do we go for stored procedures?

1 1153

What is the source code of a program?

1 1142

Why are aggregate functions called so?

1 1027

Why do we use procedures?

1 1021

Why use stored procedures in mysql?

1 1050

Un-Answered Questions { Databases }

Can we do dml on views?

1029

Can we rollback truncate?

1071

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1286

What is subquery? Explain the properties of a subquery?

1054

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

1184

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

1142

What are the steps in creating a database?

1004

What are the advantages of database?

1009

What are the two main functions of queries in databases?

1522

How can you append an identity column to a temporary table?

1063

Who proposed the relational model?

1027

Is there some bulk load or other way to import a lot of data fast?

929

How to convert character strings into numeric values?

1186

Is microsoft getting rid of access?

881

Have you written applications to retrieve stored images in a table?

1083

For More Un-Answered { Databases } Questions Click Here