Search Header Logo

ADBMS_Quiz_2_Section_B

Authored by Hamza Ali

Information Technology (IT)

University

Used 1+ times

ADBMS_Quiz_2_Section_B
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the main purpose of query parsing?

Generate output

Optimize query

Check syntax and translate SQL to internal format

Evaluate results

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is an internal representation used in query processing?

SQL

Relational Schema

Extended Relational Algebra

Procedural Language

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In the query SELECT balance FROM account WHERE balance < 2500;, which relational algebra operation represents filtering?
A)
B)
C)
D)

Π (pi)

σ (sigma)

∪ (union)

× (cross product)

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a major disadvantage of centralized databases?

Single point of failure

Difficult to back up

Requires more developers

Lower performance

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following best describes a distributed database?

Runs on a single server

Uses a central system for storage

Cannot operate offline

Stores data across multiple locations

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following improves fault tolerance?

Centralization

Replication

Compression

Caching

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

When should vertical fragmentation be used?

When dividing data by location

When minimizing CPU time

When separating attributes used by different apps

When reducing server load

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?