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

In MS Access the long and short date option does not show 4 digit years. how do I achieve the mm/dd/yyyy format?

856

What format should my database be saved in to allow different versions of Microsoft Access to open the database?

887

State the criteria which a trusted publisher should meet before adding him?

858

how do you add a developer to a trusted publishers list?

852

Explain about relationships and look up fields?

946

How do you create an append query?

931

What is the maximum size of a database that can be opened in Microsoft Access?

885

What happens if the both source and destination are named the same?

857

Would you like to easily automate your MS Access database through menu driven selections?

833

I am designing an Access database form. how can I get my next control in the form to be automatically selected?

829

State some criteria and their effects of a database?

911

Explain about creating a report tool by using the report tool and report wizard?

980

What are the other commands to know the structure of a table using mysql commands except explain command?

1035

How many ways we can retrieve the date in result set of mysql using php?

1119

How to create a table?

992

Un-Answered Questions { Databases }

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

Which tcl commands are available on the sql server?

1083

How to execute a sql statement using odbc_exec()?

1140

What is mongoose odm?

How can I create table in mysql?

1021

Write steps for neo4j installation?

What database does facebook use?

960

What is a ‘namespace’?

How many concurrent programs you have customized, can you name some of them?

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1075

What is the max size for access database?

898

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

973

You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?

590

What is blob database?

937

Write a query to fetch common records between two tables using mysql?

1028

For More Un-Answered { Databases } Questions Click Here