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

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

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

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

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

Database Management (1411)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

Difference between Function and Stored Procedure?

C1 India, NA,

9 22516

What is data integrity? Explain constraints?

Thinksoft,

1 26214

Explain some DBCC commands?

6 20413

What are tasks?

Wipro,

3 13521

What is the purpose of using COLLATE in a query?

1 18938

What is a NOLOCK?

NA,

3 20806

How do SQL server 2000 and XML linked?

2 8621

What is the difference between HAVING clause and the WHERE clause?

7 16624

Explain what are db_options used for?

InterGraph,

1 9674

how to know description of a table in sqlserver 2000

8 11627

plz send every query in sql server2000

Infosys,

1 5951

what is difference between 1.append to media 2.overright the existing media when we take back up in sql server2000

Indian Web Technology,

2093

can we delete autodiff back up that we have set through sql server agent.

Indian Web Technology,

2255

if we have set auto differencial back up then waht is difference between 1.appen to media 2.over right the existing media

Indian Web Technology,

1 4513

characters of DBMS A) non redundant B) data independence C) increased security D) all the above

Accenture, XP,

1 9270

Un-Answered Questions { Databases }

What is query optimizer in sql server?

1077

Why do we use procedures?

1008

How can I connect mysql database?

944

Explain the use of inctype option in exp command.

1084

Why are mongodb data files large in size?

describe transaction-safe table types in mysql : sql dba

1065

How do I spool in oracle?

1065

What does the on update no action do?

1079

Is google scholar a database?

1048

Can you skip header records while loading? : aql loader

1102

Why stored procedures are faster than query?

1079

how could you increase the speed of ontape/onbar backups ?

106

What is a column in a table?

1191

who owns the operating system files created by the utl_file package?

1129

What are different between mongodb and sql server databases?

For More Un-Answered { Databases } Questions Click Here