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

Quiz

•

Computers

•

12th Grade

•

Practice Problem

•

Medium

Daniel TAIT

Used 14+ times

FREE Resource

50 questions

Show all answers

1.

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

2.

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

3.

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

4.

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

5.

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

6.

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

7.

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 PERAKITAN KOMPUTER

Quiz

•

12th Grade

51 questions

Testout IT Fundamentals Chapter 3

Quiz

•

11th - 12th Grade

45 questions

LATIHAN SOAL PSTS INFORMATIKA KELAS 7 GNP

Quiz

•

9th - 12th Grade

51 questions

Soal Pilihan Ganda informatika

Quiz

•

9th - 12th Grade

50 questions

ULANGAN HARIAN TEKNIK PENGOLAHAN AUDIO DAN VIDEO

Quiz

•

1st - 12th Grade

45 questions

PAT Informatika Genap

Quiz

•

9th - 12th Grade

45 questions

PAS - PKK - Kelas XII TKJ

Quiz

•

12th Grade

47 questions

IT Fundamentals Chapter 6

Quiz

•

8th - 12th Grade

Popular Resources on Wayground

8 questions

2 Step Word Problems

Quiz

•

KG - University

20 questions

Comparing Fractions

Quiz

•

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

10 questions

Latin Bases claus(clois,clos, clud, clus) and ped

Quiz

•

6th - 8th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

7 questions

The Story of Books

Quiz

•

6th - 8th Grade

Discover more resources for Computers

8 questions

2 Step Word Problems

Quiz

•

KG - University

10 questions

Martin Luther King, Jr. For Kids

Interactive video

•

1st - 12th Grade

10 questions

Dr. King's Speech and Its Impact

Interactive video

•

7th - 12th Grade

20 questions

-AR -ER -IR present tense

Quiz

•

10th - 12th Grade

7 questions

Anti-Bullying ARS 15-341

Quiz

•

9th - 12th Grade

13 questions

Model Exponential Growth and Decay Scenarios

Quiz

•

9th - 12th Grade

15 questions

TSI Math Practice Questions

Quiz

•

8th - 12th Grade

24 questions

Identify Properties of Polygons and Quadrilaterals

Quiz

•

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