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,

1069

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

Flextronics, Thomson Reuters, Virtusa,

1098

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,

1034

Explain about Views?

Infosys,

1069

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,

1040

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,

1013

Un-Answered Questions { Databases }

What is a sql join?

1018

Explain about merge replications?

1024

What is degree of Relationship type?

851

who introduced sql?

1018

How to insert data from one table to another in postgresql?

836

What is an execution plan? How would you view the execution plan?

1077

How do I start a pgadmin server?

864

Differentiate between a having clause and a where clause.

965

what is heap table? : Sql dba

1105

What are the features of dbms?

945

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2814

What do you mean by redo log file mirroring?

1032

How is use pl and sql?

1059

How does index hunting help in improving query performance?

941

what is oracle data integrator (odi)?

623

For More Un-Answered { Databases } Questions Click Here