An advantage of using SQL instead of QBE is:

It is a standardised system and therefore can easily communicate with other programs that use SQL.

It is more intuitive to use than the QBE

It prevents data redundancy due to not using an overly-complicated DBMS

It increases the chance of a failover system being activated, protecting data in the event of a malicious attack.

A database query is used to...

find data based on certain criteria

A module in a database...

is some code that automates a useful function

is a 'cluster' of databases joined together

What is an ox-bow lake?

A remnant meander, left after a river has straightened its course.

A post-glacial lake caused by a moraine dam

A small lake normally found in a 'birds-foot' delta

A lake on a flood plain formed by man made levees.

GCSE Database Theory

Authored by Paul Revell

Computers, Geography

9th - 11th Grade

Used 38+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View
Student View

19 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does “SQL” stand for?

Standard Query Language.

Structured Query Language.

Structured Quick-access Language.

Standard Questioning Language.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a DBMS?

It runs a database, and can provide control over user permission levels, provides both a visual and SQL interface and can allow a database to work across multiple devices.

It is a technology which reduces lag time when running a query.

It is the organisation that set up and maintains SQL.

It is a Database Backup Management system that can be switched to if an active database fails.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does a Relationship do within a database?

It reduces data redundancy by linking fields in different tables.

It shows which users in a database are related.

It increases data redundancy by linking fields in different tables.

The fields are the vertical columns in a table.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is data redundancy?

Data that is repeated multiple times.

Data that is safe from SQL attacks.

Data that is weak to SQL attacks.

Data that has no use anymore.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does data validation do?

Checks that an input fits certain parameters such as length.

Checks that inputted data is completely correct.

Checks that there is no redundant data in a field.

Checks that the correct SQL Query has been used.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is QBE?

A graphical, form based method of running a query on a database.

A way of achieving data validation.

An alternative to a DBMS.

Another name for an SQL query.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A database is separated from the applications that use it so that…

Different groups of users can have custom interfaces

The tables don’t get mixed up

Things are kept simple using “divide and conquer”

It takes up less disk space

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Microsoft

or continue with

Facebook

Apple

Others

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

Already have an account?

Similar Resources on Wayground

17 questions

FormazioneSicurezzaSpecifica_Mod. 3.1

Quiz

•

9th - 12th Grade

14 questions

Le capitali

Quiz

•

4th - 10th Grade

20 questions

Earth's interior layers

Quiz

•

9th Grade

20 questions

Skill Competition Quiz 2024

Quiz

•

10th Grade - University

17 questions

ARQUITECTURA DE COMPUTADORAS

Quiz

•

10th Grade

15 questions

Introducción Redes Tele1 IB

Quiz

•

10th Grade - University

20 questions

Perakitan dan Pengujian Komputer - KJD

Quiz

•

10th Grade

20 questions

Sumber Semula Jadi di Malaysia

Quiz

•

7th Grade - University

Popular Resources on Wayground

21 questions

Continents and Oceans

Quiz

•

6th Grade

20 questions

Parts of Speech

Quiz

•

5th Grade

16 questions

Subject & Predicate

Quiz

•

5th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

12 questions

Map Skills

Quiz

•

3rd Grade

22 questions

Continents and Oceans

Quiz

•

5th Grade

15 questions

Rounding Decimals

Quiz

•

5th Grade

20 questions

Brand Labels

Quiz

•

5th - 12th Grade

Discover more resources for Computers

16 questions

Module 1 Topic 2 Vocabulary Test

Quiz

•

9th - 12th Grade

17 questions

Chapter 1 Review

Quiz

•

9th Grade

20 questions

Google Slides Quiz

Quiz

•

9th Grade

30 questions

Python- if -ifelse-elif

Quiz

•

9th - 12th Grade

10 questions

Exploring Digital Citizenship Essentials

Interactive video

•

6th - 10th Grade

46 questions

Level 1 Google Sheets Midterm Flashcard

Flashcard

•

9th - 12th Grade

40 questions

Introduction to Microsoft Word

Quiz

•

8th - 12th Grade

10 questions

Exploring Cybersecurity Techniques and Threats

Interactive video

•

6th - 10th Grade

GCSE Database Theory

What does “SQL” stand for?

What is a DBMS?

What does a Relationship do within a database?

What is data redundancy?

What does data validation do?

What is QBE?

A database is separated from the applications that use it so that…

An advantage of using SQL instead of QBE is:

A database is a store of data that is...

A database form is useful for...

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers