Question 1 [20 Marks]View more random threads:
- CS610 Computer Networks Assignment no 02 FALL Spring 10...
- IT430 E Commerce Assignment No 03 Semester 31 May Spring...
- CS402 Theory of Automata Assignment no 3 spring May 2012
- cs502 Fundamentals of Algorithms assignment no 5 spring...
- cs403 assginment no 2 data base management spring 2011 idea...
- cs605 Assignment No. 05 idea solution on 23-1-2012
- MCM301 Communication Skills Assignment No.1 Semester Fall...
- Assignment No.4 (Course STA301) Fall 2010 (Total Marks 30)
- CS402 Theory of Automata Assignment No.4 Fall 2012 Due Date...
- CS601 Data Communication Assignment no.5 idea solution Due...
Consider the following table:
Player_Country
Player_ID
Player_type
Country_name
IND-01
Wicket Keeper
India
IND-05
Bowler
India
SA-07
Batsman
South Africa
SA-09
All Rounder
South Africa
AF-01
Batsman
Afghanistan
AF-04
Wicket Keeper
Afghanistan
WI-01
Batsman
West Indies
WI-06
Spinner
West Indies
Create bitmap index for the following queries.
1) Select * from Player_Country where Player_type =”Bowler” AND Country_name=”India”
2) Select*from Player_Country where Player_type =”Wicket Keeper” OR Country_name=”Afghanistan”
Sponsored Links
There are currently 1 users browsing this thread. (0 members and 1 guests)