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

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

HCL,

1099

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

B-Ways TecnoSoft,

1067

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

Flextronics, Thomson Reuters, Virtusa,

1096

What is CTE in SQL

Infosys,

945

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

Global Logic,

1010

What is NOT NULL Constraint in sql server 2012?

CDC,

1000

Tell me about pre-defined functions of sql?

EXL,

1112

Differentiate between SQL and ORACLE joins and write their syntax.

Global Logic,

1033

Explain about Views?

Infosys,

1067

How to create hyperlink from returned sql query ?

MCN Solutions,

1125

Give an example of SQL injection attack ?

HAL,

1006

What is lookup override?

Informatica,

1037

Explain what you mean by 3 tier architecture.

TCS,

1077

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

Genpact,

1 2349

What is an active database?

HCL,

1012

Un-Answered Questions { Databases }

What is mysql ndb?

890

why an information gap exists in most organizations.

1014

How much ram can sql express use?

985

How do I view postgresql data?

783

What is sql resultset?

985

What are data driven subscriptions?

112

What are the different windows events activated at runtime ?

2900

How do I count records in sql?

1002

what are the tools used for oracle 10g in real time.

2441

All questions related to Control m monitoring tool

2543

Explain the difference between physical and logical data independence?

908

What is data source view or dsv? : sql server analysis services, ssas

1000

Can we use commit inside a trigger?

1088

how many sql dml commands are supported by 'mysql'? : Sql dba

1121

Do ddl statements need commit?

969

For More Un-Answered { Databases } Questions Click Here