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

Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

2525

wa procedure to return the month and the no'f developers joined in each month.

Fidelity,

4 10155

using cursors salesman get bonus as 10% of their salary , managers get 20% , analalist get 30%. generae a report showing the employee name, salary , bonus.

Fidelity,

4 12158

sales persons should always receive commission of 100 at least. employees who r not sales persons should never receive commission.(Triggers)

Fidelity, Oracle,

1 8338

how to retrieve the top 2 salaried persons from a database?

Orion Laboratories,

7 9891

Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F

IBM,

6 10490

Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.

Cap Gemini, IBM,

4 19909

What is materialised View?

IBM,

2 5768

Give an example of Full Outer Join?

IBM,

1 5499

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

IBM,

3567

What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ?

ABC,

1 3068

how to retrive xml data for using sql query?

IBM, TCS,

3 7005

1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?

IBM,

1 4680

Difeerence between ssis 2005 and ssis2008?

Convergys,

1 6303

How to provide Security for package?

Convergys,

1 7035

Un-Answered Questions { Databases }

Why is the basic difference between left join, right join and inner join?

1030

How do I view blob data?

855

Explain how to convert a report into excel sheet.

Which sorts rows in sql?

1017

What command is used to type files to the screen?

594

What are the differences between char and varchar in ms sql server?

1063

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

2500

How to replace not in with not exist?

2086

What is Sequences?

630

Is mysql better than sql server?

1059

How to present a past time in hours, minutes and seconds?

1048

What is flashback in Oracle?

1017

What is a table index?

1098

Can the “if update (colname)” statement be used in a delete trigger?

990

What is substitution variable?

1052

For More Un-Answered { Databases } Questions Click Here