subject

All tables are stored in packed form in blocks of length 4096 bytes. student has 10,000 tuples, each 200 bytes long. it is hashed on stuid, the primary key, and has a secondary non-clustered index on lastname, with three levels. there are 8000 values for lastname, 2000 values for firstname, 25 values for major, and 150 values for credit. faculty has 800 tuples of length 100 bytes. it has an index on facid, the primary key, with two levels. there is a secondary non-clustered index on department, with one level. facname has 650 values, department has 25 values, and rank has 4 values. class has 2500 tuples with length of 100 bytes. it is hashed on classname, the primary key, and has no secondary indexes. facid has 700 values here, schedule has 35 values, and room has 350 values. enroll has 50,000 tuples with length of 100 bytes. it has a composite index on the primary key, {class number, stupid}, with four levels, and it has no other index. the attribute grade has 10 values.

1) find the read cost only (no writing costs) of class |x| enroll using nested loops with:
- class as the outside loop and buffer size of only two blocks
- enroll as the outside loop and buffers size of two blocks
- class as the outside loop and buffer size of 10 blocks
- enroll as the outside loop and buffer size of 10 blocks

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 06:00
Write a function that draws a pool ball. this function should take as parameters, the color, the number that should go on the pool ball, and the location of the center of the pool ball. the radius of the pool balls should be pool_ball_radius, and the font of the number should be pool_ball_font. the text of the pool ball font should be white. drawpoolball(color.orange, 5, 100, 100); drawpoolball(color.green, 6, 50, 200); drawpoolball(color.red, 3, 150, 350); drawpoolball(color.blue, 2, 250, 140); to center the numbers on the pool ball, you should use the getwidth() and getheight() methods. you are allowed to call these methods on your text object, such as txt.
Answers: 3
question
Computers and Technology, 23.06.2019 18:40
How does is make you feel when you're kind to others? what are some opportunities in your life to be more kind to your friends and loved ones? imagine a world where kindness has be outlawed. how would people act differently? would your day-to-day life change significantly? why or why not?
Answers: 2
question
Computers and Technology, 24.06.2019 10:20
Multiple choice project create a program with two multiple choice questions. 1. users have two attempts only, show attempt number each time. hint: while loop with break control. (20%) 2. only one correct answer for each question, use switch case for each question. (20%) 3. show total score after the two questions are answered. hint: . (20%) 4. user have options to answer the two questions again if first attempt score is not 100%. hint: if statment. (20%) 5. use string method .toupper() to allow users to enter with lowercase or uppercase letters. (20%) 1. where is the capital of the state of florida? a. orlando b. tallahassee c. miami d. tampa b 2. where is walt disney world park located in florida? a. orlando b. tallahassee c. miami d. tampa a
Answers: 1
question
Computers and Technology, 24.06.2019 18:20
Use a while-end loop in a script file to calculate the sum of the first n terms of the series: summation sign on the top n bottom k=1 : )^k * k^2 +5k)/3^k show the script file and the two results of n = 10 and n = 20.
Answers: 2
You know the right answer?
All tables are stored in packed form in blocks of length 4096 bytes. student has 10,000 tuples, each...
Questions
question
Mathematics, 25.07.2019 02:10
question
Mathematics, 25.07.2019 02:10
question
Mathematics, 25.07.2019 02:10
Questions on the website: 13722366