Suppose we have 999 records of employees Emp1, Emp2, Emp5, Emp6 and so on up to Emp998 and Emp999 stored in a sequence. Hence, records are nothing but a row in the table. In the employee table, we want to insert new records Emp3 and Emp4 in the sequence, and once we have done insertion we need to update and retrieve the record efficiently to optimize the performance of a database by minimizing the access time when query is being executed.
Answers
The records in the table represents the employee ID of each employee. Assume the table name is EMPLOYEES and the field name of employee IDs is ID, the following SQL query inserts Emp3 and Emp4 into the employees table.
INSERT INTO EMPLOYEES (ID) values (Emp3), (Emp4)
The complete question requires that we list the pros and cons of solving the problem using Index sequential access method (ISAM).
The advantage of using ISAM is that priorities are given to the indices of the records being inserted. So, Emp3 and Emp4 will be inserted immediately after Emp2.
However, a major disadvantage of using ISAM is that it is very expensive to keep the indices in a sequential order;
See attachment for the illustration of Index sequential access method (ISAM).
Read more about Index sequential access method (ISAM) at:
https://brainly.com/question/4692093
Related Questions
hỗ trợ mình với được không các bạn
Answers
Answer:
Explanation:
Be bop
Question in Statistics and Probability 2
Petrol samples were taken at three different stations along a national highway to determine whether the octane rating varied from one station to another. Six petrol specimens of the same category were randomly selected at each station in different days. We are interested to know if there is sufficient evidence to indicate a difference in the mean octane rating at the different stations.
State the Null and the Alternative Hypotheses.
Answers
What is the following diagram called?
Answers
Answer:
business
Explanation:
because shopping has great income
Answer:
is ur question right
Explanation:
is ur question right
is ur question right
an atom that gained an electron is called
Answers
Answer:
Hey mate......
Explanation:
This is ur answer.....
When an atom gains/loses an electron, the atom becomes charged, and is called an ion.Hope it helps!
Brainliest pls!
Follow me :)
Why is logging done during drilling?
Answers
Answer:
Logging while drilling (LWD) is a technique of conveying well logging tools into the well borehole downhole as part of the bottom hole assembly (BHA). ... In these situations, the LWD measurement ensures that some measurement of the subsurface is captured in the event that wireline operations are not possible
A resistor has code 104 printed on it .What is the resistive value of this resistor
Answers
Answer:
X = 1 (1st digit in the code)
Y = 0 (2nd digit)
Z = 4 (3rd multiplier digit)
104 → 10 × 10^4 Ω
→ 10 × 10000Ω
→ 100 kΩ
resistors are marked 104, 105, 205, 751, and 754. The resistor marked with 104 should be 100kΩ (10x10^4), 105 would be 1MΩ (10x10^5), and 205 is 2MΩ (20x10^5). 751 is 750Ω (75x10^1), and 754 is 750kΩ (75x10^4).
Here we need to understand how a code in a resistor gives us information on the resistor. Here we will see that the code means that the resistance is 100,000 Ω.
When we use numbers, let's assume that we have 3 single-digit numbers abc.
So if the code in our resistor is abc, this will mean that the resistance of the resistor is:
ab×10^c Ω
Using this general rule we can see that if the code is 104, then the resistance will be:
r = 10×10^4 Ω
= 100,000 Ω
Then we can conclude that the resistive value of this resistor is 100,000 Ω
If you want to learn more, you can read:
https://brainly.com/question/74415
Hydraulic fracturing is: Select one: a. a first step in storage of high-level radioactive waste b. a way of extracting natural gas shale formations c. a step in oil refining where oil is separated into different viscosities d. none of the above
Answers
Hydraulic fracturing is “a way of extracting natural gas shale formations.”
Shale and other types of "tight" rock, or impermeable rock formations that lock in oil and gas and complicate the production of fossil fuels, can be extracted of their natural gas or oil using the modern high-volume hydraulic fracturing process. Thus, option B is correct.
What are the factor involving in Hydraulic fracturing?Shale gas is extracted through a procedure called hydraulic fracturing, also referred to as “fracking.” Due to the fact that shale reserves are often dispersed horizontally rather than vertically, deep holes are first drilled into the shale rock, then horizontal drilling is used to reach more of the gas.
A mixture of sand, chemicals, and water is pushed at high pressure down a borehole during hydraulic fracturing. The released gas can flow out of the rocks and back up the borehole because the water pressure causes cracks in the rock to widen, and the sand particles settle into the openings to keep them open.
Therefore, a way of extracting natural gas shale formations.
Learn more about Hydraulic fracturing here:
https://brainly.com/question/28559289
#SPJ2
Troy must keep track of the amount of refrigerant he uses from a 50-pound cylinder to ensure that accurate
records are kept. He used 13 pounds on a systein for Ms. Jones and 9 pounds on a system for a commercial
client. How many pounds should he have left in the cylinder?
tof
Troy should have
pounds of refrigerant left in the cylinder.
baon naid Thamar basic
محمود احمد مجد
12
اهداء ما در
Answers
Answer:
Amount of gas still in cylinder = 28 pound
Explanation:
Given:
Amount of gas in cylinder = 50 pound
Amount of gas used in Ms. Jones system = 13 pound
Amount of gas used in client system = 9 pound
Find:
Amount of gas still in cylinder
Computation:
Amount of gas still in cylinder = Amount of gas in cylinder - Amount of gas used in Ms. Jones system - Amount of gas used in client system
Amount of gas still in cylinder = 50 - 13 - 9
Amount of gas still in cylinder = 28 pound
