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

Compare join and subquery in performance?

970

State some of the products of sybase?

916

For synchronizing the logins from lower version to higher version, just take the 11.9.2 syslogins structure, go to 12.5 higher version server?

833

What happen when we delete the table using trigger?

921

Explain about the sybase group?

937

What you need to do is issue an ase kill command on the connection then un-suspend the db?

952

What is the difference between replication server and sql remote in sybase?

966

what is the difference between an ltm and a repagent in sybase?

937

How to find the time taken for rollback of the processed?

989

How do check the current running processes?

977

What is sybase ?

942

What is the stored procedure to view current lock and processes respectively?

910

What is the drawbacks of normalization?

981

What is an advantage to using a stored procedure as opposed to passing an sql query from an application ?

937

How do I tell which tables have identities in sybase?

888

Un-Answered Questions { Databases }

How does postgresql compare to "nosql"?

1050

Which is faster mysql or mongodb?

935

What do you mean by fill factor concept with respect to indexes?

978

What is difference between clustered and non clustered index?

1004

Will you be able to store pictures in the database?explain.

1008

How to make the project as .exe file in oracle forms & reports(d2k)?

What is a database in microsoft access?

879

What is pga_aggregate_target?

587

What is store procedure?

1077

What is the difference between varchar and nvarchar datatypes?

1105

Does server sql treat char as a variable-length or fixed-length column?

1062

What is primary and secondary replica set in mongodb?

What is difference between index and primary key?

1110

How do you organize a database?

944

What is an oracle database schema?

1135

For More Un-Answered { Databases } Questions Click Here