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 22510

What is data integrity? Explain constraints?

Thinksoft,

1 26214

Explain some DBCC commands?

6 20411

What are tasks?

Wipro,

3 13521

What is the purpose of using COLLATE in a query?

1 18936

What is a NOLOCK?

NA,

3 20803

How do SQL server 2000 and XML linked?

2 8620

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

7 16621

Explain what are db_options used for?

InterGraph,

1 9673

how to know description of a table in sqlserver 2000

8 11623

plz send every query in sql server2000

Infosys,

1 5947

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,

2253

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 4511

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

Accenture, XP,

1 9268

Un-Answered Questions { Databases }

Why do we use sql constraints?

1215

What is database in php mysql?

1043

Can you call pl/sql package functions from within a fast formula?

1086

What is the command that can be used to allocate memory in postgreSQL?

1453

How do you rename a table in sql server?

1103

What is the use of index in sql?

1068

Have you written applications to retrieve stored images in a table?

1061

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1147

Why are sql functions used?

1185

How did mongodb get its name?

What does a database contain?

930

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2265

What is network database?

1083

Do the mongodb databases have schema?

how you can get the list of largest tables in a database? : Sql server administration

1105

For More Un-Answered { Databases } Questions Click Here