1 A mobile phone has a 348 196inch screen size with a resol

1. A mobile phone has a 3.48- × 1.96-inch screen size with a resolution of 326 pixels per inch. (a) How many pixels does it have? (b) With 256 levels of brightness for each color of subpixel, what is the MiB size of the display memory?

2. Write the statements for the following queries of the database in Figure 1.31.

*(a) Find Beth’s home state. (b) List the fraternity members who are English majors. (c) List the sorority and fraternity members who have the same home state, and indicate what that home state is.

3. Why does software pricing for mainframes seem so complex?

4. Why does IBM have so many models (or capacity settings) in recent mainframe machines?

5. Multiprocessor means several processors (and that these processors are used by the operating system and applications). What does multiprogramming mean?

6. What z/VSE application changes are needed to work in an LPAR?

Sor S Name Beth Nancy Robin Allison Lulwa Frat F. Name Emile Sam Ron Mehdi David Jeff Craig Gary S. Class Soph Jr Sr Soph Sr F. Major Poly Sci Comp Sci Math Math English Hist English CompSci S. Major S. State Hist Math NY Hist Math CompSci CA F. State CA WA OR CA FIGURE 1.31 An example of a relational database. This database contains two relations Sor and Frat.

Solution

2)

a) select S.State where s.Name=beth\'s

b) select F.Name where f.Major=english

c) select F.Name,f.State from sor inner join FRAT ON S.State=f.State where S.States=F.States