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

Give main differences between "Truncate" and "Delete".

HCL,

1 1176

What method is used by the Command classes to execute SQL statements that return single values?

B-Ways TecnoSoft,

1 1129

How can you insert values in multiple rows using one Insert statement?

Flextronics, Thomson Reuters, Virtusa,

1 1171

What is CTE in SQL

Infosys,

1 1007

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

Global Logic,

1 1061

What is NOT NULL Constraint in sql server 2012?

CDC,

1 1064

Tell me about pre-defined functions of sql?

EXL,

1 1164

Differentiate between SQL and ORACLE joins and write their syntax.

Global Logic,

1 1094

Explain about Views?

Infosys,

1 1137

How to create hyperlink from returned sql query ?

MCN Solutions,

1 1206

Give an example of SQL injection attack ?

HAL,

1 1067

What is lookup override?

Informatica,

1 1098

Explain what you mean by 3 tier architecture.

TCS,

1 1138

What is the difference between UNIQUE and DISTINCT keywords in DBMS?

Genpact,

1 2467

What is an active database?

HCL,

1 1084

Un-Answered Questions { Databases }

How to put more than 1000 values into an oracle in clause?

1099

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1041

Does group by remove duplicates?

1106

Why should you use or avoid select * statements?

1100

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

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1938

Were you involved in any data conversion, which one?

How do I create a trace in sql server?

1109

How did mongodb get its name?

Can delete statement be rollbacked?

1046

Why we use the openxml clause?

1063

When should you use an instead of trigger?

1041

Who proposed the relational model?

1027

How do I remove duplicates in two columns?

1172

What is temporary table in sql server? Why we use temp table?

1006

For More Un-Answered { Databases } Questions Click Here