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 11034

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 28940

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

1 5366

WHAT IS UNIQUE IDENTIFIER DATA TYPE?

Sparsh,

2 8546

event classes in sql server

Accenture, AFE,

2 7804

WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX

CarrizalSoft Technologies, L&T,

4 11318

what is macro?

Excel, Global Innovation, Wipro,

5 12807

what is an object groups?

2 20173

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 4212

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

1 4961

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

2158

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

IBM, TCS,

1 3709

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 4356

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.

2230

Un-Answered Questions { Databases }

What is checkpoint in sql server?

1160

Where mongodb data is stored?

Explain storage manager?

1037

Explain intellisense for query editing

1029

How do I view a stored procedure in sql server?

982

What are triggers mysql?

898

Is sql a rdbms?

811

How do you open tables in pgadmin?

802

What are different types of receipt reversals ? Explain them : oracle accounts receivable

1262

Does a sql server 2005 select statement require a from?

1020

What are the tool windows in sql server management studio? : sql server management studio

1075

Explain the Ways to improve the performance of a sql azure database?

What are collection pools? What are the advantages?

894

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

985

Discuss row chaining, how does it happen? How do you correct it?

549

For More Un-Answered { Databases } Questions Click Here