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 are tables in sql?

1124

Which constraints we can use while creating database in sql?

1125

Define sql delete statement.

1067

Give the order of sql select?

1187

Can we rename a column in the output of sql query?

1048

What does sql stand for?

1059

What are the properties of a transaction?

1191

Does view contain data?

1086

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?

2341

what is the difference between nested subquery and correlated subquery?

1097

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1180

What is a composite primary key?

1148

Explain the purpose of %type and %rowtype data types with the example?

1049

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

1088

What do you mean by stored procedures?

1073

Un-Answered Questions { Databases }

What do you understand by aggregation and atomicity?

960

What are policy management terms?

1045

What are procedures in database?

1152

Does sql*plus also have a pl/sql engine?

1133

What is psql?

868

What is drivermanager getconnection?

1106

What are the types of stored procedures in an sql server?

1041

Define join types.

1013

What is difference between aggregate and analytic function?

979

What is a checkpoint and When does it occur?

821

Mention the different types of dbms.

1107

What is identity?

1085

Is mysql a good database?

1000

Where is mysql installed on linux?

975

How do I delete a postgres database?

921

For More Un-Answered { Databases } Questions Click Here