Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...



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

2461

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

Fidelity,

4 9952

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 11968

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

Fidelity, Oracle,

1 8256

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

Orion Laboratories,

7 9612

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 10241

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 19690

What is materialised View?

IBM,

2 5669

Give an example of Full Outer Join?

IBM,

1 5414

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

IBM,

3518

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

ABC,

1 2979

how to retrive xml data for using sql query?

IBM, TCS,

3 6870

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 4575

Difeerence between ssis 2005 and ssis2008?

Convergys,

1 6212

How to provide Security for package?

Convergys,

1 6934


Un-Answered Questions { Databases }

How can you select unique records from a table?

995


What are the functions of database management system?

901


What are the protection features in ms access?

824


What is the maximum number of columns in sql table?

1089


What is the full meaning of dbms?

990


What is the cartesian product of table?

932


What is the concept of optimization?

991


what is the information that can be stored inside a bit column? : Sql server database administration

904


What do you need to connect php to mysql?

934


What is difference between mysql_connect and mysql_pconnect?

976


what is the difference between data migration and production migration.

2276


What are the drivers in MySQL?

1369


What is the difference between inner join and left join?

938


Explain about merge replications?

967


What is the difference between case version and decode version?

963