Database Design (Form 5, Computer Science)

Froggy Jumps

Played 0

Create copy

About this activity

Test your knowledge on pseudo codes for algorithms with sequences, decisions, and loops!

Created by

YAKILI LMS

Cameroon

Download the paper version to play

Make your own free game from our game creator

Compete against your friends to see who gets the best score in this game

Make challenge

The Integumentary System

Breanna Nesbitt

United States

(58)

Functions and Structures of the skin
Bill of Rights Game - The Constitutionalist

Doni The Don

United States

(89)

Test your knowledge on the Bill of Rights. A fun way to test your knowledge and focus on where you need to improve.
Ethos, Pathos, and Logos Quiz

Kristine Vester

United States

(131)

Test your knowledge of ethos, pathos, and logos with these 10 questions on examples of persuasive techniques.
pizza

Lorelay Tyana

Romania

(258)

joc despre pizza
Phlebotomy Order of Draw Quiz

Pamela Chapman

United States

(59)

Test your knowledge of the order of draw in Phlebotomy with these 10 questions!

		%
	Anonymous	%
		%
		%

Print your game

Database Design (Form 5, Computer Science)


Froggy Jumps Database Design (Form 5, Computer Science)Online version Test your knowledge on pseudo codes for algorithms with sequences, decisions, and loops! by YAKILI LMS 1 What is a key advantage of flat-file systems? a Supports complex queries b Simple to set up and use c High data security 2 What is a limitation of flat-file systems? a Data redundancy and inconsistency b Efficient data retrieval c Supports multiple users 3 Which is an advantage of flat-file systems? a High concurrency b Supports large-scale data c Low cost for small data sets 4 What is a disadvantage of flat-file systems? a Difficult to manage large data volumes b Supports complex relationships c Easy to backup 5 Flat-file systems are best suited for: a High transaction environments b Small, simple data storage needs c Large enterprise data 6 A limitation of flat-file systems is: a Supports multi-user access b Supports complex queries c Lack of data integrity controls 7 An advantage of flat-file systems over databases is: a Ease of implementation b Advanced data security c Efficient data sharing 8 What is a common problem with flat-file systems? a Data redundancy b Fast data processing c High scalability 9 Flat-file systems are limited because they: a Allow complex queries b Support multiple users c Cannot easily handle relationships between data 10 Compared to databases, flat-files are: a More secure b More scalable c Less suitable for large, complex data 11 What is a key feature of a relational database? a Data is stored in tables b Data is stored in files c Data is stored in images 12 What does SQL stand for? a Structured Question Language b Simple Query Language c Structured Query Language 13 Which element links tables in a relational database? a Views b Indexes c Primary and foreign keys 14 What is the purpose of normalization? a Increase data redundancy b Improve graphics c Reduce data redundancy 15 Can relational databases handle multiple users simultaneously? a No b Only one user at a time c Yes 16 What is a table in a relational database? a A collection of related data entries b A single data point c A programming language 17 Which language is primarily used to query relational databases? a Python b SQL c Java 18 Are relational databases suitable for complex queries? a Yes b Only simple queries c No 19 What is a relation in a relational database? a A column b A table c A row 20 Do relational databases support data integrity? a No b Yes c Sometimes 21 What is normalization in computer science? a A method to delete data. b A way to increase data redundancy. c A process to organize data to reduce redundancy. 22 Why is normalization important? a To add more data. b To eliminate data duplication and improve efficiency. c To make data less organized. 23 Which normal form is the first step in normalization? a Second Normal Form (2NF). b Third Normal Form (3NF). c First Normal Form (1NF). 24 What does normalization help prevent? a Data anomalies and inconsistencies. b Data compression. c Data encryption. 25 Normalization is mainly used in which database component? a User interfaces. b Network protocols. c Tables and data structure. 26 Which of the following is NOT a normal form? a First Normal Form (1NF). b Fourth Normal Form (4NF). c Second Normal Form (2NF). 27 What is the goal of normalization? a To increase data duplication. b To make data less accessible. c To organize data efficiently and reduce redundancy. 28 Normalization typically involves dividing data into what? a Related tables. b Single large table. c Unrelated files. 29 Which normal form removes partial dependency? a Second Normal Form (2NF). b Third Normal Form (3NF). c First Normal Form (1NF). 30 What is a key benefit of normalization? a Improved data integrity and consistency. b Slower data retrieval. c Increased data redundancy. 31 What is the main goal of 1NF in databases? a Increase data redundancy b Eliminate repeating groups and ensure atomicity c Create complex tables 32 In 2NF, what must be removed from the table? a Multivalued dependencies b Atomicity issues c Partial dependency on the primary key 33 What does 3NF aim to eliminate? a Atomicity violations b Transitive dependencies c Partial dependencies 34 Which property is NOT part of 1NF? a Unique rows b Atomic columns c Multiple values in a single field 35 Which normalization form requires all non-key attributes to depend only on the primary key? a 3NF b 2NF c 1NF 36 What is a key characteristic of 1NF? a Partial dependencies b Atomicity of data c Multivalued attributes 37 In 2NF, what type of dependency is addressed? a Multivalued dependency b Partial dependency c Transitive dependency 38 Which property is added in 2NF that wasn't in 1NF? a Elimination of partial dependencies b Atomic columns c Multivalued attributes 39 Why is 3NF important? a To reduce redundancy and improve data integrity b To increase data duplication c To complicate database design 40 Which normalization form is the most advanced among 1NF, 2NF, and 3NF? a 1NF b 2NF c 3NF 41 What SQL command is used to retrieve data from a database? a INSERT b SELECT c UPDATE 42 Which clause specifies the columns to be returned in a query? a WHERE b SELECT c FROM 43 What keyword is used to filter records in a SQL query? a FILTER b HAVING c WHERE 44 Which SQL statement is used to add new data into a table? a INSERT b CREATE c ADD 45 What does the 'FROM' clause specify in a SQL query? a The columns to display b The conditions for filtering c The table to select data from 46 Which clause is used to sort query results? a GROUP BY b SORT c ORDER BY 47 What is the purpose of the 'UPDATE' statement? a Delete data b Modify existing data c Create a new table 48 Which SQL command deletes data from a table? a DROP b DELETE c REMOVE 49 What does the 'GROUP BY' clause do? a Groups records with similar data b Sorts records c Filters records 50 Which clause is used to specify conditions in SQL? a ORDER BY b WHERE c HAVING

Database Design (Form 5, Computer Science)

Froggy Jumps

About this activity

Created by

Download the paper version to play

Top Games

Froggy Jumps

The Integumentary System

Froggy Jumps

Bill of Rights Game - The Constitutionalist

Froggy Jumps

Ethos, Pathos, and Logos Quiz

Froggy Jumps

pizza

Froggy Jumps

Phlebotomy Order of Draw Quiz

Froggy Jumps

Database Design (Form 5, Computer Science)Online version

by YAKILI LMS

What is a key advantage of flat-file systems?

What is a limitation of flat-file systems?

Which is an advantage of flat-file systems?

What is a disadvantage of flat-file systems?

Flat-file systems are best suited for:

A limitation of flat-file systems is:

An advantage of flat-file systems over databases is:

What is a common problem with flat-file systems?

Flat-file systems are limited because they:

Compared to databases, flat-files are:

What is a key feature of a relational database?

What does SQL stand for?

Which element links tables in a relational database?

What is the purpose of normalization?

Can relational databases handle multiple users simultaneously?

What is a table in a relational database?

Which language is primarily used to query relational databases?

Are relational databases suitable for complex queries?

What is a relation in a relational database?

Do relational databases support data integrity?

What is normalization in computer science?

Why is normalization important?

Which normal form is the first step in normalization?

What does normalization help prevent?

Normalization is mainly used in which database component?

Which of the following is NOT a normal form?

What is the goal of normalization?

Normalization typically involves dividing data into what?

Which normal form removes partial dependency?

What is a key benefit of normalization?

What is the main goal of 1NF in databases?

In 2NF, what must be removed from the table?

What does 3NF aim to eliminate?

Which property is NOT part of 1NF?

Which normalization form requires all non-key attributes to depend only on the primary key?

What is a key characteristic of 1NF?

In 2NF, what type of dependency is addressed?

Which property is added in 2NF that wasn't in 1NF?

Why is 3NF important?

Which normalization form is the most advanced among 1NF, 2NF, and 3NF?

What SQL command is used to retrieve data from a database?

Which clause specifies the columns to be returned in a query?

What keyword is used to filter records in a SQL query?

Which SQL statement is used to add new data into a table?

What does the 'FROM' clause specify in a SQL query?

Which clause is used to sort query results?

What is the purpose of the 'UPDATE' statement?

Which SQL command deletes data from a table?

What does the 'GROUP BY' clause do?

Which clause is used to specify conditions in SQL?