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

How to create DSN..Explain?

Accenture, BeBo Technologies, Infosys,

2 21781

What is the difference between SQL, DDL, and DML?

BeBo Technologies, Wipro,

7 70075

What are inner join and outer join?

3 11717

What are joins..how many types of joins are there?

Amdocs, CSC, TCS,

29 76496

what are Triggers?

TCS,

7 13775

what are stored procedures?

TCS, Wells Fargo,

7 12294

what are indexes..how many types of index's are there and what are they?

Green Info Solutions, TCS,

7 16790

what are views?

TCS,

8 19357

what is web server?

Satyam,

3 11801

What are functions

3 9341

What are the different table present in MYsql?

3 11869

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 12177

what is the difference between oracle 81,91,11i

i2, Oracle,

2 17585

How client makes connection with server in client/server architecture?

CA,

1 4600

Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?

2 5265

Un-Answered Questions { Databases }

How to create an index on a view?

571

Does view store data in sql?

525

Why indexing is needed?

509

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

1609

How to insert a new row into a table with "insert into" statements in ms sql server?

528

Differentiate between replication server and sql remote?

467

Is it important for a database administrator to understand the operating system and file access?

502

What is like operator for and what are wild cards?

478

How many primary keys can a table have?

526

What is the difference between sharding and replication?

473

How do you backup a database?

562

What are the tools available in market as an alternative to sql server reporting services?

How do you remove a foreign key constraint?

429

What is the purpose of a sql?

519

How do indexes help, types?

543

For More Un-Answered { Databases } Questions Click Here