If you are trying to optimze your database to allow for the fastest possible ins

Question

If you are trying to optimze your database to allow for the fastest possible insertion of data (one that requires no additonal work/steps), what type of files storage is preferred? A. Heap B. Ordered C. Hashed D. Composite QUESTION 8 The process of normalization usually improves the performance of a database by reducing table joins therefore improving the performance of select statements. True False QUESTION 9 A join operation: brings together data from two different fields. causes two tables with a common domain to be combined into a single table or view. causes two disparate tables to be combined into a single table or view. is used to combine indexing operations. QUESTION 10 In theory, what type of index, clustered or non-clustered, would be best for the query below? Select last_name from employees where date_of_birth> '10/1/1965' and date_of_birth

Explanation / Answer

1. Option A
Insertion into a heap is fastest of all the methods. The time complexity is O(logn)

2. False
Normalisation improves the performance of a database by spliting the data into different tables thus making to do more joins between tables

3. Option B
Join to used to combine data from two tables by using some common key.

4. Non-Clustered
Here if the output is required from different years, so the data cant be clustered format.

5. Least recently used
this is to replace the recently used ones with the most used ones.

6. Option A
the select statement is ordered based on the last name

7. Clustered
The data under same project number can be grouped and displayed

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.