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

What is the command used to fetch the first 5 characters of a string?

1 1276

What is the difference between local variables and global variables?

1 1207

What are all the different normalization?

1 1104

What is a field in a database?

1 1116

Can a table contain multiple primary key’s?

1 1175

What is the sql case statement?

1 1069

Explain sql data types?

1 1149

What is the largest value that can be stored in a byte data field?

1 1065

What are operators available in sql?

1 1108

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1 1294

What are user defined functions?

1 1077

What is auto increment in sql?

1 1188

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1 1505

What is a table in a database?

1 1112

What is the difference between an inner and outer join?

1 1077

Un-Answered Questions { Databases }

Why should you use or avoid select * statements?

1103

What are different types of constraints?

995

What is the best sql course?

1041

How do I create a trace in sql server?

1109

What is your daily office routine?

2334

how to use regular expression in pattern match conditions? : Sql dba

1102

How to start an oracle instance?

1093

What is the current mysql version?

1086

What is normalization and what are the advantages of it?

1050

How did mongodb get its name?

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1207

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

1063

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2091

Can we rollback truncate?

1070

How do I start sql server 2017?

1005

For More Un-Answered { Databases } Questions Click Here