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

What are tables in sql?

1077

Which constraints we can use while creating database in sql?

1092

Define sql delete statement.

1023

Give the order of sql select?

1154

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

1008

What does sql stand for?

1006

What are the properties of a transaction?

1142

Does view contain data?

1045

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

what is the difference between nested subquery and correlated subquery?

1067

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

1132

What is a composite primary key?

1106

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

1006

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

1046

What do you mean by stored procedures?

1027

Un-Answered Questions { Databases }

What is the syntax for encrypting a column in SQL Server?

1132

How do you delete a row in a table?

786

Should I store images in database?

1048

Differentiate between post-database commit and post-form commit?

1053

How to transfer a table from one schema to another?

1020

Does access use sql?

1051

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2339

What is forms_mdi_window?

What is transaction server consistency?

1063

What is an intersect?

1115

How can you set the threshold at which sql server will generate keysets asynchronously?

1003

what is acid property in database? : Sql dba

1041

What is crud in mongodb?

What operating systems are supported by oracle sql developer?

980

What is the sql server 2000 version number?

1094

For More Un-Answered { Databases } Questions Click Here