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

SELECT country,city FROM customers GROUP BY country ORDER BY city DESC

HCL,

5 11283

how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

Deloitte, Lason,

9 29295

A left outer join B B right outer join A gives the same result then what is the use of two?

1 5452

WHAT IS UNIQUE IDENTIFIER DATA TYPE?

Sparsh,

2 8666

event classes in sql server

Accenture, AFE,

2 7932

WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX

CarrizalSoft Technologies, L&T,

4 11530

what is macro?

Excel, Global Innovation, Wipro,

5 13005

what is an object groups?

2 20320

If server is in US and client is in india there is timezone is diffrence, How can we display date in indian time when data is displayed from US server timezone?

1 4293

how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?

1 5056

what are steps for interface? where is exchange rate defined in which table?

1 2254

Describe the Index, Types of index, At what situation we have used? Which one s better than others?

IBM, TCS,

1 3793

how report can be generated if we have the database designed in oracle 10g?

1 1951

how report can be generated if we have the database designed in oracle 10g?

1 4453

Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.

1 2292

Un-Answered Questions { Databases }

Can we shrink data file in sql server?

1112

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

1163

what is the difference between openrowset and openquery?

1174

What is sql server query analyzer?

1111

How to define array in mongoose schema?

What is self contained sub query?

1130

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1177

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

Why and when do stored procedure recompile?

1042

How do I find query history in sql server?

1000

what is sql server agent? : Sql dba

1162

How to start an oracle instance?

1086

Can one drop a column from a table?

1075

Have you created fact table and dimension tables?

694

What is a scheduled job or what is a scheduled task?

1019

For More Un-Answered { Databases } Questions Click Here