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 11315

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 29330

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

1 5463

WHAT IS UNIQUE IDENTIFIER DATA TYPE?

Sparsh,

2 8681

event classes in sql server

Accenture, AFE,

2 7956

WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX

CarrizalSoft Technologies, L&T,

4 11550

what is macro?

Excel, Global Innovation, Wipro,

5 13024

what is an object groups?

2 20343

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 4309

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

1 5071

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

1 2279

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

IBM, TCS,

1 3814

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

1 1966

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

1 4476

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 2301

Un-Answered Questions { Databases }

in oracle BPM composer in part BA model on design model in enterprise model i cannot connection with value chain model work not links in part properties do you can me help me?

1601

Is it possible to have clustered index on separate drive from original table location?

1034

Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:

2306

This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?

2553

what is schema? : Sql dba

1132

define sql insert statement ? : Sql dba

1093

What are different types of constraints?

995

what is the difference between openrowset and openquery?

1186

What is a view in sql?

1035

what is bcp? When does it used? : Sql dba

1052

Can you index views?

951

Why we use the openxml clause?

1065

What is self contained sub query?

1138

How do I find query history in sql server?

1018

How to convert numeric expression data types using the cast() function?

1142

For More Un-Answered { Databases } Questions Click Here