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,

1055

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

B-Ways TecnoSoft,

1026

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

Flextronics, Thomson Reuters, Virtusa,

1058

What is CTE in SQL

Infosys,

900

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

Global Logic,

974

What is NOT NULL Constraint in sql server 2012?

CDC,

953

Tell me about pre-defined functions of sql?

EXL,

1084

Differentiate between SQL and ORACLE joins and write their syntax.

Global Logic,

991

Explain about Views?

Infosys,

1020

How to create hyperlink from returned sql query ?

MCN Solutions,

1090

Give an example of SQL injection attack ?

HAL,

959

What is lookup override?

Informatica,

982

Explain what you mean by 3 tier architecture.

TCS,

1035

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

Genpact,

1 2302

What is an active database?

HCL,

973

Un-Answered Questions { Databases }

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

984

What is a boolean in sql?

959

How do you know if a relationship is 2nf?

895

What is backup in Oracle?

966

Is Mysql query is case sensitive?

986

Difference between group by clause and having clause in SQL?

941

What is best institute to Learn DotNET And SQL in chennai?

2138

What is sap sql anywhere?

1009

How to get current date in postgresql?

935

What is a parameter query?

1039

What are advantages of ssrs or why we should use ssrs?

137

How much money does a dba make?

556

Is postgres a database?

789

What is sql used for?

1082

How to use the inserted and deleted pseudo tables?

928

For More Un-Answered { Databases } Questions Click Here