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?

1313

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

1407

Why Update is too slow

1405

What does the option psql -l of PostgreSQL display?

1446

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

1268

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

1314

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

1324

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

1601

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

1279

Explain what is PostgreSQL?

1 2054

State some of the advanced features of PostgreSQL?

1 2294

Explain about Write Ahead logging?

1 2381

Explain about Multi version concurrency control?

1 2203

How to start the database server?

1 2043

How to stop the database server?

1 2149

Un-Answered Questions { Databases }

Enlist the data types that can be used in pl/sql?

1071

What is pragma serially_reusable and why is it used?

866

Which was the neo4j first version and when was it released?

what is 'mysqlcheck'? : Sql dba

1012

Explain error handling in ssis?

1023

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

988

Explain the purpose of %type and %rowtype data types?

928

How to get execution path reports on query statements?

987

What are referenced objects? Explain the importance of referencing.

i am writing a query select EmpNo from Emp how can i call in after parameter form

2124

what is a database? : Sql dba

1169

What do you understand by replication in sql server?

1061

Is mariadb faster than mysql?

964

What will be objects between two dates in mongodb?

How to start and stop sybase database in linux sap?

928

For More Un-Answered { Databases } Questions Click Here