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

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

2574

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

Fidelity,

4 10300

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 12324

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

Fidelity, Oracle,

1 8433

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

Orion Laboratories,

7 10139

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 10714

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 20071

What is materialised View?

IBM,

2 5865

Give an example of Full Outer Join?

IBM,

1 5589

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

IBM,

3624

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

ABC,

1 3156

how to retrive xml data for using sql query?

IBM, TCS,

3 7105

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 4750

Difeerence between ssis 2005 and ssis2008?

Convergys,

1 6378

How to provide Security for package?

Convergys,

1 7135

Un-Answered Questions { Databases }

What are the differences between left join and inner join in sql server?

1157

Explain the use of consistent option in exp command.

1142

You want to delete a table in sybase. How would you do it?

904

How do I delete a table in postgresql?

912

Name the different triggers associated with oracle forms having a master-detail relationship.

1057

Why is there a need for sqlcode and sqlerrm variables?

1104

How do you import data from another access database?

917

What measures are there to increase the db space?

965

How do you update f as m and m as f from the below table testtable?

1930

What do we have to check in database testing?

1059

Describe and explain about SQL native client?

1159

How to list all user names in a database?

1096

Is sql a backend language?

1146

What are the results of running this script?

976

Is it possible to pass parameters to triggers?

1164

For More Un-Answered { Databases } Questions Click Here