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

2570

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

Fidelity,

4 10299

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 12321

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

Fidelity, Oracle,

1 8432

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

Orion Laboratories,

7 10134

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 10706

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 20069

What is materialised View?

IBM,

2 5865

Give an example of Full Outer Join?

IBM,

1 5585

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

IBM,

3622

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

ABC,

1 3153

how to retrive xml data for using sql query?

IBM, TCS,

3 7103

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 4749

Difeerence between ssis 2005 and ssis2008?

Convergys,

1 6376

How to provide Security for package?

Convergys,

1 7131

Un-Answered Questions { Databases }

What is etl process in data warehousing? What are the different stages in 'data warehousing'?

897

what command would you use to move the physical log?

199

Difference between Logical Page and Physical Page in SSRS.

491

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

1096

What is cursor in pl sql with examples?

1091

role of sql sever 2005 in database rather than any other database

1990

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

981

What is a natural primary key?

1108

What is a recovery catalog?

How to fetch the next row from a cursor with a "fetch" statement?

1111

Does mongodb store data in memory?

Do you know what is replace and stuff function in sql server?

1082

What are the types of lock supported by ?

1093

What do you mean by Correlated subquery in database?

1045

What is sql used for?

1165

For More Un-Answered { Databases } Questions Click Here