1. Which of the following represents the aggregations with increasing level of d

Question

1. Which of the following represents the aggregations with increasing level of details? a. Drill-Down b. Pivot c. Slice d. Sorting 2. Triggers follow a(n) model a. Condition-Action-Event b. Action-Condition-Event c. Event-Condition-Action d. Event-Action-Condition 3. This occurs when two transactions that access the same database items have their operation interleaved in a way that makes the value of some database item incorrect a. Incorrect Summary Problem b. Lost Update c. Temporary Update d. Filthy Update 4. The process of continuing to revise/adjust the physical database design called: a. Tuning b. Normalization c. Denormalization d. None of the above 5. A schedule S is if it is equivalent to some serial schedule of the same n transactions a. Serial b. Serializable c. Result equivalent d. None of the above 6. "All users must have passwords" is an example of a a. Rule b. Policy c. procedure d. Standard deals with ensuring that data is protected against unauthorized access, and if the data are accessed by an authorized user, that the data are used only for an authorized purpose. a. Integrity b. Availability c. Compliance d. Confidentiality

Explanation / Answer

The paragraph number 10 is having the wrong answer. The first step in the query processing is the measure of the query cost. Let us breifly explain the basic steps of the query processing:

1. Measure of the query cost.

2. Selection operation.

3. External sorting.

4. Join operation.

5. Other operations.

6. Evaluation of expressions.

4.

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

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