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 1030

State some of the products of sybase?

1 971

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 1034

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 1081

How do check the current running processes?

1 1041

What is sybase ?

1 991

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

1 969

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 948

Un-Answered Questions { Databases }

What are different types of constraints?

996

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2209

Is microsoft getting rid of access?

883

Where can you add custom error messages to sql server?

1204

Equi join and non equi join is possible with sql server?

1130

How to connect php with different port numbers?

1181

How do I create a trace in sql server?

1113

What is self contained sub query?

1138

When should you use an instead of trigger?

1045

What is an indexed view?

1018

How do I start sql server 2017?

1012

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2177

Explain system functions or built-in functions? What are different types of system functions?

1060

What is normalization and what are the advantages of it?

1054

what is bcp? When does it used? : Sql dba

1053

For More Un-Answered { Databases } Questions Click Here