Answer:
C. Unclustered index has the same ordering of data records as that of the data entries in the database
Explanation:
Indexes are used to split up queries in an SQL server or database management system DBMS.
There are two types of indexes namely clustered indexed and unclustered indexes.
Clustered indexes define the order in which data is stored in a table while unclustered index does not sort the order in a table.
In an unclustered index, the data table and the index are stored in different places, they are easy to maintain and update since they do not follow a particular order and there can be several indexes in a data file since the data table is stored differently from the index file.
So, all the other options except C are features of unclustered indexes since unclustered index does not have the same ordering of data records as that of the data entries in the database.
So, C is the answer.
Answer:
i) The time taken for 1500 records = 15 seconds.
ii) The time taken for 1500 records = 50 seconds.
Explanation:
A is an O(n) algorithm.
An algorithm with O(n) efficiency is described as a linearly increasing algorithm, this mean that the rate at which the input increases is linear to the time needed to compute that algorithm with n inputs.
From the question, it is given that for 1000 records, the time required is: 10 seconds.
Algorithm time taken is O(n)
Hence,
1) For 1,500 records
=> 10/1000 = x/1500
=> 10x1500/1000 = x
x = 15 seconds
Thus, the time taken for 1500 records = 15 seconds.
2) For 5,000 records
=> 10/1000 = x/5000
=> 10x5000/1000 = x
x = 50 seconds
Thus, the time taken for 1500 records = 50 seconds.
Answer:
Go to the
✔ Page Layout
tab on the ribbon and the
✔ Themes
group.
Click Themes and select one.
Go into the workbook, make the changes, and return to the Themes gallery.
Select
✔ Save Current Theme
to save the changes.
Explanation:
yup
Answer:
Hi there! This question is good to check your knowledge of entities and their relationships. The diagram and explanation are provided below.
Explanation:
The entity relationship diagram for the association between the entities according to the description in the question is drawn in the first attachment. We can further simplify the relationship by removing this many to many relationship between "Chemists" and "Projects" by adding another entity called "Worklist" as detailed in second attachment.
,I don't know you all about computer
