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 22125

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

BeBo Technologies, Wipro,

7 70726

What are inner join and outer join?

3 11965

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

Amdocs, CSC, TCS,

29 77816

what are Triggers?

TCS,

7 14190

what are stored procedures?

TCS, Wells Fargo,

7 12751

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

Green Info Solutions, TCS,

7 17204

what are views?

TCS,

8 19887

what is web server?

Satyam,

3 12108

What are functions

3 9581

What are the different table present in MYsql?

3 12134

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 12524

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

i2, Oracle,

2 17821

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

CA,

1 4759

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

2 5462

Un-Answered Questions { Databases }

What is difference between database and website?

547

What do you mean by dba?

318

What do you understand by hotfixes and patches in sql server?

576

What is main function of database administrator?

317

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1575

What is rdbms table?

605

Define "correlated subqueries".

561

What happens if you add a new index to large table?

566

I am using the switchboard manager in ms access. I am getting an error message "there was an error executing this command." What could be wrong?

556

How to lock records in a table?

580

Explain what is it unwise to create wide clustered index keys?

586

Tell me when is the update_statistics command used?

568

List some neo4j commands?

How can we solve sql error: ora-00904: invalid identifier?

749

What is a covered index?

573

For More Un-Answered { Databases } Questions Click Here