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 1163

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

B-Ways TecnoSoft,

1 1119

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

Flextronics, Thomson Reuters, Virtusa,

1 1163

What is CTE in SQL

Infosys,

1 1003

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

Global Logic,

1 1057

What is NOT NULL Constraint in sql server 2012?

CDC,

1 1053

Tell me about pre-defined functions of sql?

EXL,

1 1160

Differentiate between SQL and ORACLE joins and write their syntax.

Global Logic,

1 1084

Explain about Views?

Infosys,

1 1133

How to create hyperlink from returned sql query ?

MCN Solutions,

1 1192

Give an example of SQL injection attack ?

HAL,

1 1059

What is lookup override?

Informatica,

1 1088

Explain what you mean by 3 tier architecture.

TCS,

1 1136

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

Genpact,

1 2445

What is an active database?

HCL,

1 1078

Un-Answered Questions { Databases }

How to export data from database and import into another?

978

What are the different SQL Server Versions you have worked on?

1071

List out the different types of locks available in sql server?

1037

How do I create a trace in sql server?

1102

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1055

What are wait types?

1219

What is the best sql course?

1031

What are the types of database explain each of them briefly?

1038

How to write a left outer join with the where clause in oracle?

1136

Which statement is used in a select query for partial matching?

1232

How to connect php with different port numbers?

1159

When should you use an instead of trigger?

1033

What is the difference between upgrade and migration in sql server?

1163

Any work done in oracle workflow builder. Did you customize or build a new workflow?

What are the properties of the transaction?

1059

For More Un-Answered { Databases } Questions Click Here