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 trigger and trigger types?

1001

Which are the new data types introduced in sql server 2008?

898

How we can compare two database data?

962

Explain aggregate functions?

1107

What is self contained multi valued query?

1036

What is explicit mode in sql server?

1077

What is logon trigger?

1116

How to Update from select query in sql server?

1077

What is system stored procedures?

1054

What is sql injection? How to protect against sql injection attack?

1010

What is repeatable read?

1039

What is a rollup clause?

986

How can I know what locks are running on which resource?

967

When I delete any data from a table, does the sql server reduce the size of that table?

1037

What is user-defined functions? What are the types of user-defined functions that can be created?

1052

Un-Answered Questions { Databases }

How can we delete duplicate rows in a table?

998

What are queries in dbms?

954

What are the different phases of transaction?

846

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

2292

Can sql server be linked with other servers like oracle?

980

How can you make a database as your current database?

1068

What is the difference between a view and a stored procedure?

1052

What conditions he must fullfil before being accepted as a publisher?

1022

What is mysql community server?

943

What is 1nf?

978

How to resolve the orphan use problem? : sql server security

1034

What are the 10 characteristics of data quality?

969

How to start sybase database in windows?

1165

How can we avoid duplicating records in a query?

997

Can you tell how many values can set the function of mysql to consider?

1004

For More Un-Answered { Databases } Questions Click Here