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 is nested transaction?

538

What are the differences between clustered and non-clustered index?

543

What is page-level compression?

558

When cursors are useful?

581

Explain about extended stored procedure?

494

Explain what is “asynchronous” communication in sql server service broker?

496

Define inner join in sql server joins?

535

What is row-level compre?

549

Explain about nested stored procedure?

608

Define left outer join in sql server joins?

566

Can we create clustered index on composite key?

519

Explain important index characteristics?

562

Explain about local stored procedure?

510

What is “asynchronous” communication in sql server service broker?

548

What is bit data type? What's the information that can be stored inside a bit column?

526

Un-Answered Questions { Databases }

I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage

1198

What is transparent data encryption? : sql server DBA

566

What platforms are supported in couchdb?

What is sql stand for?

578

What is end users in dbms?

492

What is an advantage of a database?

495

what are enums used for in mysql? : Sql dba

613

How can I create database in oracle?

573

Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?

2035

How do you add a serial number to an access report?

471

What is filestream?

562

What is this tds protocol in sybase?

485

Explain how we can do multi-join query in ms access?

522

What will be query used to get the list of triggers in a database?

552

How to create a login account in ms sql server to access the database engine using "create login" statements?

573

For More Un-Answered { Databases } Questions Click Here