Query Processing and Optimization

Query Processing and Optimization

University

50 Qs

quiz-placeholder

Similar activities

PHP Basics

PHP Basics

University

54 Qs

Design and Analysis of Algorithms [5th Sem BCA]

Design and Analysis of Algorithms [5th Sem BCA]

University

45 Qs

Modules 1-2

Modules 1-2

University

53 Qs

Information Technology, the Internet, and You

Information Technology, the Internet, and You

12th Grade - University

46 Qs

Introduction to Computer

Introduction to Computer

University

50 Qs

220 - 901 Test 2

220 - 901 Test 2

University

47 Qs

NILAI KUIS PERTAMA

NILAI KUIS PERTAMA

University - Professional Development

50 Qs

ICT 151-200

ICT 151-200

University

50 Qs

Query Processing and Optimization

Query Processing and Optimization

Assessment

Quiz

Computers

University

Easy

Created by

Riddhish Thakore

Used 3+ times

FREE Resource

50 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

1 min • 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

1 min • 1 pt

The steps involved in processing __________
Parsing and translation
Optimization
Evaluation
All of Given

3.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

In query processing, system must first translate given query into which form?
Internal form
Physical form
high level form
New form

4.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

In generating the internal form of the query, the parser checks ___________
Syntax of query
Verifies relation name
None of given
Both of Given

5.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Match the following: A) evaluation primitive B) query-execution plan c) query-execution engine 1) takes a query-evaluation plan, executes that plan, and returns the answers to the query 2) A relationalalgebra operation annotated with instructions on how to evaluate it 3)A sequence of primitive operations that can be used to evaluate a query
A-2, B-3, C-1
A-1, B-3, C-2
A-3, B-1, C-2
A-3, B-2, C-1

6.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which statement(S) is/are true? A) A query could be expressed in SQL several different ways. B) SQL query can be translated into a relationalalgebra expression in one of several ways. C) There are several ways to evaluate relational-algebra expressions D) We can execute each relational-algebra operation by one of several different algorithms.
Only A,B
Only A,C,D
Only D
All A,B,C,D

7.

MULTIPLE CHOICE QUESTION

1 min • 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

Create a free account and access millions of resources

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

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?