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

Oracle (3259)
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 22198

What is data integrity? Explain constraints?

Thinksoft,

1 26110

Explain some DBCC commands?

6 20210

What are tasks?

Wipro,

3 13390

What is the purpose of using COLLATE in a query?

1 18848

What is a NOLOCK?

NA,

3 20672

How do SQL server 2000 and XML linked?

2 8526

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

7 16415

Explain what are db_options used for?

InterGraph,

1 9594

how to know description of a table in sqlserver 2000

8 11350

plz send every query in sql server2000

Infosys,

1 5868

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

Indian Web Technology,

2045

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

Indian Web Technology,

2202

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 4444

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

Accenture, XP,

1 9191

Un-Answered Questions { Databases }

How can you log an error to the server event log from a stored procedure?

1108

Define self join in sql server joins?

955

What is efficiency data?

953

What is postgis and postgresql?

887

How many categories of data types in oracle?

1029

can we have a nested transaction? : Sql server database administration

1103

What are the dml statements?

1143

explain advantages of myisam over innodb? : Sql dba

1069

How does one coalesce free space?

551

Which flexfields you have customized?

Are stored procedures precompiled?

989

What are the main differences between 11.x and 12.x versions of sybase?

843

What is pl sql record in oracle?

1037

Enlist the advantages of sql.

1001

Do you know how to implement service broker?

928

For More Un-Answered { Databases } Questions Click Here