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

How many byte Unique integers does OIDs in PostgreSQL have?

1270

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

1361

Why Update is too slow

1363

What does the option psql -l of PostgreSQL display?

1396

What is the operator that is used for case-insensitive regular expression searches in PostgreSQL?

1224

What is the option that can be used in PostgreSQL to find out how the query optimizer is evaluating the query given?

1263

What is the option used in PostgreSQL to increase the number of shared memory buffers shared among the backend processes

1280

What is the powerful database utility that can be used for building, executing and processing queries upon PostgreSQL databases?

1554

Does PostgrSQL support Column constraints? If so how is it done?

1246

Explain what is PostgreSQL?

1 1997

State some of the advanced features of PostgreSQL?

1 2241

Explain about Write Ahead logging?

1 2312

Explain about Multi version concurrency control?

1 2129

How to start the database server?

1 1966

How to stop the database server?

1 2077

Un-Answered Questions { Databases }

What are scalar functions in sql?

1093

How do I completely uninstall postgresql?

818

List the data types available in mssql?

977

what is the difference between union and union all? : Sql dba

987

In what version of sql server were synonyms released?

922

How do I start mysql client?

921

Name and describe few console utilities for ssrs?

282

Why couchdb is used?

What is storage engine in mongodb?

Is not null in sql?

943

Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool

1808

How many types of functions are there in sql?

911

Explain the use of log option in exp command.

1063

How do you create a blank database?

897

What is a coalesce? What is the equivalent of oracle/db2 coalesce function in sybase?

868

For More Un-Answered { Databases } Questions Click Here