Which of the following is an example of a record ?

351, Nature, Documentary, Bling, False

Which of the following is an example of a field ?

351, Nature, Documentary, Bling, False

A structured collection of information

A piece of software to do calculations

A device to load information onto the computer.

Which of these is not an advantage of using an electronic database?

Easy to move information - portable

Which of the following is the best definition of a database?

A persistent collection of related data stored and organised in a logical way.

A collection of tables and views to serve customers.

A computer program that allows the storage and retrieval of data.

The following query "SELECT * FROM Videos" can be interpreted as:

Requesting to show all records stored in the table called Video.

Deleting all records stored in the table called Video.

Requesting to show all records with ID of 1 character stored in the table called Video.

To select all items in the above table costing over £100 and in stock, the following SQL statement is needed:

SELECT * FROM Items WHERE Price>100 AND Quantity>0

SELECT * FROM Items WHERE Price>100 OR Quantity>0

INSERT * FROM Items WHERE Price>100 OR Quantity>0

SELECT * FROM Items WHERE Price>=100 AND Quantity>=0

The following query UPDATE Customers SET Price=Price*0.75, WHERE (Quantity>100 OR Price<30) AND OnSale=FALSE; will do this:

For all non-sale items with over 100 units unsold, apply a 25% discount.

Show all non-sale items with over 100 units unsold, priced 75p or lower.

Take 75% off all overstocked items and mark them as non-sale items.

What is the purpose of *?

Selects ALL fields from the table

Selects only the first field in the table

Selects the last field in the table

Shows only the first row in the table

To join a table, connect the ___________ of one table to the ___________ of the other.

aggregate function, where clause

Write a code for the following: Return all romances that have an imdb_rating over 6.

SELECT * FROM movies WHERE genre = ‘romance’ AND imdb_rating > 6;

SELECT * FROM movies WHERE genre = ‘romance’ AND imdb_rating < 6;

SELECT imdb_rating, name FROM movie WHERE genre = ‘romance’ AND imdb_rating > 6;

SELECT * FROM movies WHERE genre = romance and imdb_rating < 6;

Return the name and genre of each movie with an imdb_rating greater than 5 and year greater than 2012.

SELECT name, genre FROM movies WHERE imdb_rating > 5 AND year > 2012;

SELECT * FROM movies WHERE imdb_rating > 5 AND year > 2012;

SELECT name, genre FROM movies WHERE imdb_rating < 5 AND year < 2012;

SELECT name, year FROM movies WHERE imdb_rating > 5 year > 2012;

Return 5 movies with an imdb rating of 7 or higher.

SELECT * FROM movies WHERE imdb_rating >= 7 LIMIT 5;

SELECT * FROM movies WHERE imdb_rating = 7 limit 5;

SELECT * FROM movies WHERE imdb-rating >= 7 LIMIT 5;

SELECT * FROM movies WHERE imdb_rating <= 7 LIMIT 5;

Return 8 romances that were made before 1999.

SELECT * FROM movies WHERE genre = ‘romance’ AND year < 1999 LIMIT 8;

SELECT * FROM movies WHERE genre = romance AND year > 1999 LIMIT 8;

SELECT * FROM games WHERE genre = ‘romance’ AND year < 1999 LIMIT 8;

SELECT * FROM Movies WHERE genre = ‘romance’ AND year > 1999 LIMIT 8;

Which of the following code is written correctly?

SELECT * FROM movies WHERE genre = ‘horror’;

SELECT * FROM movies WHERE imdb_rating is 1 AND ORDER by desc;

SELECT * FROM movies WHERE genre = ‘comedy’ AND ORDER BY ASC LIMIT 1:

SELECT * FROM movies genre is horror, and rating is 2;

Write the code for the following: Return all movies made before 2011 and order by the imdb rating from highest to lowest.

SELECT * FROM movies WHERE year < 2011 ORDER BY imdb_rating DESC;

RETURN * FROM movies WHERE year < 2011 AND imdb_rating ASC;

SELECT * FROM movies WHERE year > 2011 ORDER BY imdb_rating DESC;

SELECT * FROM movies WHERE year = 2011 ORDER BY imdb_rating ASC;

What is wrong with the following code: SELECT * FROM movies WHERE genre = comedy AND year < 2016 ORDER BY year DESC;

Comedy should have single quotes around it

Which would find Pupils whose name begins in C from Haddon forms?

SELECT * FROM Pupils Where Name LIKE "C%" AND House = Haddon

SELECT * FROM Pupils Where Name = "C%" AND House = Haddon

SELECT * FROM Pupils Where Name = "C" AND House = Haddon

SELECT * FROM Pupils Where Name LIKE "C" AND House = Haddon

Organize these options into the right categories

All non-key attributes are fully functionally dependent on the primary key

Unique identifier of a database table

Used for faster indexing of a database

Related primary key of another table

A database with multiple tables

Databases and SQL

12th Grade

•

50 Qs

Similar activities

Adobe Photoshop

10th Grade - Professional Development

•

50 Qs

Sec-D Javascript-1

12th Grade - University

•

52 Qs

SOALAN TMK

KG - University

•

46 Qs

ULANGAN HARIAN TEKNIK PENGOLAHAN AUDIO DAN VIDEO

1st - 12th Grade

•

50 Qs

Intro to Computing Midterms

12th Grade

•

50 Qs

UH ORIENTASI DASAR TEKNIK JARINGAN KOMPUTER DAN TELEKOMUNIKASI

10th Grade - University

•

50 Qs

PAS - PKK - Kelas XII TKJ

12th Grade

•

45 Qs

CSEC IT - 04 Loops & Trace Tables

10th - 12th Grade

•

50 Qs

Databases and SQL

Quiz

•

Computers

•

12th Grade

•

Practice Problem

•

Medium

Daniel TAIT

Used 14+ times

FREE Resource

50 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A database is a large collection of related data and computerised ones are used because....

Paper filing cabinets are outdated and take up too much room

Computerised databases are much better then paper ones

Computerised databases take up less space, can be easily edited and are faster at searching and sorting information

Computerised databases are much more efficient than paper ones, there are fewer errors and its faster to find all the data you need

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Databases have a structure that has

A file which is made up of records and each record has a number of fields

A table which is the file. It has records and fields in the table.

Multiple tables each with their own file, records and fields

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which best explains the differences between a flat file and a relational database?

Flat files only have one table

Flat files only have one table and are prone to data inconsistencies unlike relational databases

Relational databases have multiple tables to avoid data anomalies which are commonplace in flat file databases

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Validation of data is conducted to ensure

That any data entered is correct

That any data entered is accurate

That any data entered is acceptable and sensible

That any data entered is accurate and sensible

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A foreign key

is a primary key in its own table and used in a second table to create a link between them

is a field in both tables used to create a link between them

is a primary key used in two tables to create a link between them

is where the primary key is made up of two or more fields

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is a category of object, person, event or a thing of interest to an organisation?

Flat File

Entity

Attribute

Primary key

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is used to present the relationship between entities in a database?

ER Diagram

Referential integrity

Primary Key

Foreign Key

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

SOAL MS WORD

Quiz

•

9th - 12th Grade

50 questions

DDPTJKT - Latihan Soal PTS Genap

Quiz

•

10th Grade - University

50 questions

PERBAIKAN DAN PENGAYAAN KELAS 9

Quiz

•

9th Grade - University

53 questions

HTML And CSS

Quiz

•

4th Grade - Professio...

50 questions

LATIHAN SOAL PTS GENAP KELAS 8

Quiz

•

11th - 12th Grade

45 questions

TryOut Ujian Sekolah Pengetahuan - TIK SMP N 1 JEPARA

Quiz

•

12th Grade

50 questions

Information Technology

Quiz

•

12th Grade

50 questions

CCST Networking Basics, Unit test

Quiz

•

12th Grade

Popular Resources on Wayground

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

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

20 questions

Figurative Language Review

Quiz

•

6th Grade

Discover more resources for Computers

18 questions

[AP CSP] JavaScript Programming Lesson 2025-2026

Lesson

•

9th - 12th Grade

Databases and SQL

50 questions

A database is a large collection of related data and computerised ones are used because....

Databases have a structure that has

Which best explains the differences between a flat file and a relational database?

Validation of data is conducted to ensure

A foreign key

Which of the following is a category of object, person, event or a thing of interest to an organisation?

What is used to present the relationship between entities in a database?

Which type of key is a unique identifier?

Which best describes a characteristic about an entity

Which type of relationship best describes the following?

Head teacher who runs a School

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers

Databases and SQL

50 questions

A database is a large collection of related data and computerised ones are used because....

Databases have a structure that has

Which best explains the differences between a flat file and a relational database?

Validation of data is conducted to ensure

A foreign key

Which of the following is a category of object, person, event or a thing of interest to an organisation?

What is used to present the relationship between entities in a database?

Which type of key is a unique identifier?

Which best describes a characteristic about an entity

Which type of relationship best describes the following?Head teacher who runs a School

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers

Which type of relationship best describes the following?

Head teacher who runs a School