subject

For the following queries, determine the minimum cost of the query (in I/Os), if you can have any number of secondary (also known as alternative-2) indexes available. Each index has to be on a single key attribute; composite keys are not allowed. a) select count(*) from employees where name = ‘John Smith’; b) select avg(salary) from employees where name = ‘John Smith’; c) select count(*) from employees where birthdate < ‘1-1-1980 00:00’;

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 16:20
Consider the following statements, then select one of the answers below: the signal() function shown below registers "sig_handler()" as the signal handler function for the sigkill signal, without the complexity of using when the sigkill signal is sent to a process running this code, by a user typing "kill -kill ", where the correct process id is used for to target the process, sig_handler() will be executed.
Answers: 1
question
Computers and Technology, 23.06.2019 17:00
1. which of the following is not an example of an objective question? a. multiple choice. b. essay. c. true/false. d. matching 2. why is it important to recognize the key word in the essay question? a. it will provide the answer to the essay. b. it will show you a friend's answer. c. it will provide you time to look for the answer. d. it will guide you on which kind of answer is required.
Answers: 1
question
Computers and Technology, 23.06.2019 18:00
Apunishment or the threat of punishment used to enforce conformity. select the best answer from the choices provided t f
Answers: 1
question
Computers and Technology, 24.06.2019 04:30
How do you share someone else’s tweet with your own twitter followers?
Answers: 1
You know the right answer?
For the following queries, determine the minimum cost of the query (in I/Os), if you can have any nu...
Questions
question
World Languages, 12.11.2020 14:00
question
Mathematics, 12.11.2020 14:00