Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3239)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3312)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1391)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

What are tables in sql?

538

Which constraints we can use while creating database in sql?

604

Define sql delete statement.

551

Give the order of sql select?

602

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

536

What does sql stand for?

537

What are the properties of a transaction?

548

Does view contain data?

608

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?

1668

what is the difference between nested subquery and correlated subquery?

542

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

618

What is a composite primary key?

574

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

544

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

517

What do you mean by stored procedures?

541

Un-Answered Questions { Databases }

How do I open an access database?

423

List out the different types of locks available in sql server?

550

Is postgresql scalable?

390

Please explain compound trigger in oracle?

588

Why do we write stored procedures?

470

Can we use insert statement in function?

510

What are the uses of sysdate and user keywords?

618

What are different between mongodb and sql server databases?

What is sqlite used for?

520

Is drop table faster than truncate?

543

What is the mutating table and constraining table?

548

what are different types of collation sensitivity? : Sql dba

547

What will have to do if a shard is down or slow and you do a query?

What is the main purpose of having conversation group?

487

Is microsoft access pc only?

407

For More Un-Answered { Databases } Questions Click Here