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 to insert multiple rows with a subquery?

1148

How to delete existing rows in a table?

1181

How to create an identity column?

1238

How to make a column nullable?

1137

What is a result set object returned by odbc_exec()?

1042

What is a result set object returned by mssql_query()?

1172

Explain what are the authentication modes in sql server?

1038

How to use linked server?

1210

Explain what is cte (common table expression)?

1146

Explain features and concepts of analysis services?

991

Do you know what is user defined datatypes and when you should go for them?

981

Do you know what is difference between index seek vs. Index scan?

965

Can we use custom code in ssrs?

1127

Explain what are the restrictions while creating batches in sql server?

1085

Explain about sql server login?

1096

Un-Answered Questions { Databases }

What is the data type of time?

970

what are the different tables present in mysql? : Sql dba

999

Why c++ used in clipper?

926

Is there any function in oracle similar like group_concat of mysql?

1071

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

934

How many columns can exist together per table?

1171

What are the different normalization forms?

1129

What is query optimization process?

1024

What is meant by database server?

1015

What is the return type of executeupdate ()?

917

What are tuples in sql?

1147

Is it possible to execute a dynamic sql from forms?

1083

What is oracle and what are its different editions?

1086

What is rowid in sql?

1002

WHAT IS NEED BY METION DATFMT AND TIMFMT IN H-SEPICITION IN RPGLE?

2985

For More Un-Answered { Databases } Questions Click Here