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

Compare join and subquery in performance?

1 1028

State some of the products of sybase?

1 969

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?

1 886

What happen when we delete the table using trigger?

1 965

Explain about the sybase group?

1 984

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

1 1009

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

1 1032

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

1 992

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

1 1079

How do check the current running processes?

1 1036

What is sybase ?

1 991

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

1 965

What is the drawbacks of normalization?

1 1033

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

1 995

How do I tell which tables have identities in sybase?

1 947

Un-Answered Questions { Databases }

Why and when do stored procedure recompile?

1053

What are the different types of subquery?

1229

How to convert character strings into numeric values?

1186

What are the kinds of subquery?

1101

How to connect php with different port numbers?

1181

How efficient you are in oracle and SQL server?

1252

What is sql or structured query language?

1220

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1293

Do we need to rebuild index after truncate?

1130

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

1083

How can you append an identity column to a temporary table?

1066

How to remove duplicate rows from table except one?

1081

What is the latest version of postgresql?

951

what is the command syntax for inserting a document?

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

For More Un-Answered { Databases } Questions Click Here