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

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

HCL,

5 11048

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 28957

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

1 5372

WHAT IS UNIQUE IDENTIFIER DATA TYPE?

Sparsh,

2 8553

event classes in sql server

Accenture, AFE,

2 7814

WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX

CarrizalSoft Technologies, L&T,

4 11328

what is macro?

Excel, Global Innovation, Wipro,

5 12830

what is an object groups?

2 20187

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 4216

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

1 4969

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

2162

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

IBM, TCS,

1 3713

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

1888

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

1 4362

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.

2232

Un-Answered Questions { Databases }

how to pass a variable more than one values?

656

Can group functions be mixed with non-group selection fields in ms sql server?

947

What is the datatype of image?

958

What is Relationship type?

905

Can you import Microsoft Excel data to SSRS?

132

what is the difference between LENGTH AND SIZE?

2487

Which sorts rows in sql?

1025

What are the 4 objects in access?

890

What is over () in sql?

969

Tell me what is difference between clustered and non clustered index?

946

When you used JKM ?

590

How do I trace a query in sql server?

958

How to create database with physical files specified in ms sql server?

1004

What are elements of administration?

601

What are the ansi data types supported in oracle?

948

For More Un-Answered { Databases } Questions Click Here