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 the differences between having and where clause.

553

What are the options which must be set to allow the usage of optimistic models?

516

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

528

Mention the command used to rename the database.

536

Mention the differences between sql server and mysql.

512

What are trace flags and mention a few common trace flags used with sql server?

551

What are subqueries in sql server? Explain its properties.

545

What do you understand by mirroring?

570

What are joins in sql and what are the different types of joins?

551

How can you check the version of sql server?

559

Write a query to find 5th highest amount paid from the customer table.

536

What do you understand by physical_only option in dbcc checkdb?

579

What are the differences between substr and charindex in sql server.

497

What are relationships and mention different types of relationships in the dbms

557

What do you understand by integration services in sql server?

549

Un-Answered Questions { Databases }

How many queries can mysql handle?

497

Can you copy and paste from excel to access?

458

Describe triggers features and limitations?

508

What do you mean by cubes and olap cubes?

What is difference between database and website?

505

What does "i_am_a_dummy flag" do in mysql?

499

What is DDL (Data Definition Language)?

528

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

564

Explain the different types of constraints in dbms?

488

How do database connections work?

503

What is database example?

475

What do you mean by exception log in replication?

474

In pl/sql, what is bulk binding, and when/how would it help performance?

536

How do I view a view in sql?

508

How do you tell what your machine name is and what is its IP address?

1516

For More Un-Answered { Databases } Questions Click Here