What is one major advantage of storing information in electronic databases?

It is easy to add new information and sort it.

It is difficult to add new information.

It is easy to lose information.

It is hard to search through records.

What can you do with information in electronic databases?

Sort information into any order you like.

How can electronic databases help in finding specific information?

By allowing you to search through millions of records.

By limiting the number of records.

What does a search try to find?

Matches for whatever you search for

What does the number of matches in a search depend on?

What data is stored and what you are searching for

Why are queries important in the real world?

They make it possible to search through thousands of records efficiently.

They allow for manual data entry.

They are used to print documents.

What is SQL used for?

To search and sort the database

How is SQL described in terms of learning difficulty?

One of the easiest languages to learn

One of the hardest languages to learn

A moderately difficult language to learn

An impossible language to learn

What is the purpose of the SQL command "SELECT"?

To sort the results by ascending or descending

From the table where the records are coming from

What does the SQL command "WHERE" specify?

To sort the results by ascending or descending

From the table where the records are coming from

How is the SQL command "ORDER BY" used?

To sort the results by ascending or descending

From the table where the records are coming from

What does the SQL command "SELECT *" do?

Displays all fields from the table

Deletes all fields from the table

Updates all fields in the table

Inserts new fields into the table

What is the purpose of the "WHERE" clause in an SQL statement?

To define the criteria for selection

What does the SQL keyword "SELECT" do in a query?

It displays only those fields from the table.

It deletes records from a table.

In the SQL statement "SELECT Firstname, Surname FROM Pupils WHERE GENDER = 'M';", what does the "FROM" keyword indicate?

It indicates which table you are using.

It specifies the fields to display.

It sets the criteria for selection.

What is the purpose of the "WHERE" clause in an SQL query?

It sets the criteria you will use.

It specifies the fields to display.

It indicates which table you are using.

What are the two ways you can sort records in a database?

Ascending (A→Z) and Descending (Z→A)

Chronological and Reverse Chronological

What is the purpose of the SQL query shown in the image?

To select and order movies with an IMDB rating of 8 by the year made

To delete records with an IMDB rating of 8

To update records with an IMDB rating of 8

To insert new records with an IMDB rating of 8

S3 Database Revision

Quiz

•

Computers

•

9th Grade

•

Practice Problem

•

Medium

Laura Robbie

Used 6+ times

FREE Resource

50 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the whole set of data in a database called?

Record

Field

Table

Entry

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the set of information on one single subject in a database called?

Table

Record

Field

Column

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is each separate heading of information inside a record called?

Table

Record

Field

Data

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is required to create a database?

Defining the file structure

Installing software

Writing code

Designing a website

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is a field type you have learn about?

Text

Audio

Video

Animation

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is NOT a field type in Access?

Numbers

Date

Graphics

Sound

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What type of data do text fields store?

Numbers

Characters or words

Images

Dates

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 Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

50 questions

PH INFORMATIKA KELAS 9 BAB 1

Quiz

•

9th - 12th Grade

48 questions

Algorithms

Quiz

•

9th - 11th Grade

47 questions

Các loại mạng

Quiz

•

KG - 10th Grade

50 questions

Soal MID Semester

Quiz

•

9th Grade

50 questions

UJIAN SEKOLAH IX

Quiz

•

9th Grade

50 questions

Ôn tập KTGK2 Tin 11

Quiz

•

9th - 12th Grade

50 questions

SC FOC Final Exam - Dorman Freshman Campus

Quiz

•

9th Grade

45 questions

Introduction to Typing

Quiz

•

7th - 12th Grade

Popular Resources on Wayground

7 questions

History of Valentine's Day

Interactive video

•

4th Grade

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

15 questions

Valentine's Day Trivia

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

Discover more resources for Computers

10 questions

Exploring Valentine's Day with Charlie Brown

Interactive video

•

6th - 10th Grade

18 questions

Valentines Day Trivia

Quiz

•

3rd Grade - University

20 questions

El Verbo IR Practice

Quiz

•

9th Grade

10 questions

Valentine's Day History and Traditions

Interactive video

•

6th - 10th Grade

20 questions

Graphing Inequalities on a Number Line

Quiz

•

6th - 9th Grade

20 questions

Exponent Properties

Quiz

•

9th Grade

21 questions

Presidents Day Trivia

Quiz

•

6th - 12th Grade

10 questions

Valentine's Day: History and Modern Celebration

Interactive video

•

9th - 12th Grade

S3 Database Revision

50 questions

What is the whole set of data in a database called?

What is the set of information on one single subject in a database called?

What is each separate heading of information inside a record called?

What is required to create a database?

Which of the following is a field type you have learn about?

Which of the following is NOT a field type in Access?

What type of data do text fields store?

Which field type can store whole numbers and numbers with decimal places?

What type of data do graphic fields store?

Which field type is used to store dates?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers