Search Header Logo

Chapter 10

Authored by Riddhish Thakore

Computers

University

Chapter 10
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

59 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

_________ refers to the range of activities involved in extracting data from a database

Query Optimization
Query Processing
Parsing
Query Evaluation

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The steps involved in processing __________

Parsing and translation
Optimization
Evaluation
All of these

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

____________ is the process of selecting the most efficient query-evaluation plan from among the many strategies usually possible for processing a given query, especially if the query is complex.

Query Processing
Regulary Expression
Query Optimization
SQL

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is true about query optimization?

The cost of evaluating a query can vary depending on its type.
The evaluation plan is built by the system, so the user need not focus on writing their query efficiently.
An efficient query evaluation plan is generated by a database system, which minimizes its costs.
A, B and C

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If the query was expressed in terms of a view, the _____ phase also replaces all uses of the view by the relational-algebra expression that defines the view.

Pairing
Parsing
Translation
Evaluation

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The optimizer needs to generate alternative plans that produce the ___________ as the given expression, and to choose the least-costly one.

partially different result
rows as result
columns as result
same result

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which statement is used to revoke an authorization?

Revoke
Modify
Alter
Define

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?

Discover more resources for Computers