Using Databases for Web Development Lowersixth Science Computer Science

Froggy Jumps

Played 0

Create copy

About this activity

Foundational web DB concepts.

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

Ethos, Pathos, and Logos Quiz

Kristine Vester

United States

(132)

Test your knowledge of ethos, pathos, and logos with these 10 questions on examples of persuasive techniques.
Phlebotomy Order of Draw Quiz

Pamela Chapman

United States

(60)

Test your knowledge of the order of draw in Phlebotomy with these 10 questions!
Bill of Rights Game - The Constitutionalist

Doni The Don

United States

(90)

Test your knowledge on the Bill of Rights. A fun way to test your knowledge and focus on where you need to improve.
pizza

Lorelay Tyana

Romania

(262)

joc despre pizza
The Integumentary System

Breanna Nesbitt

United States

(58)

Functions and Structures of the skin

		%
	Anonymous	%
		%
		%

Print your game

Using Databases for Web Development Lowersixth Science Computer Science


Froggy Jumps Using Databases for Web Development Lowersixth Science Computer ScienceOnline version Foundational web DB concepts. by YAKILI LMS 1 Which PHP function connects to a MySQL database? a db_connect b mysqli_connect c mysql_open 2 Which data type should you store a user's password? a hashed string b integer c plaintext 3 Which PHP extension is commonly used to interact with MySQL? a MySQLi b MysqliLite c PDO 4 What is a secure way to verify passwords in PHP? a password_verify b check_pass c hash_password 5 Which SQL statement inserts a new user? a CREATE USER ...; b INSERT INTO users (...) VALUES (...); c ADD USER ... 6 Which SQL statement retrieves user login data? a GET username FROM users b FETCH login FROM users c SELECT username, password FROM users WHERE ... 7 What is the role of a UNIQUE constraint? a Prevents duplicate usernames b Locks table c Allows duplicates 8 Which method helps prevent SQL injection? a Prepared statements b Escape only c String concatenation 9 Which PHP superglobal holds form data? a $_POST b $_GET c $form 10 Which HTTP method submits login forms securely? a POST b PUT c GET 11 What is a common way to hash passwords in PHP 8? a password_hash b md5 c hash_password 12 Which database parameter is essential for security? a salt b pepper c budget 13 What is a publishable database term? a Public endpoint b Local file c Private IP 14 Which protocol secures data transfer to the database server? a FTP b TLS/SSL c HTTP 15 Which PHP feature helps organize code for projects? a Macros b Globals c Namespaces 16 Which project management concept tracks tasks visually? a Gantt-only b Waterfall c Kanban 17 Which artifact documents requirements? a Codebase b Login form c Requirements spec 18 What is a key risk in web projects? a Over-budget b Too few users c Scope creep 19 Which stage involves testing the database? a Design b Quality assurance c Deployment 20 What do you call a separate environment for testing? a Sandbox b Staging c Production 21 Which tool helps publish a database on the internet? a Web hosting + domain b USB drive c Local server 22 What is database normalization primarily for? a Eliminate data redundancy b Increase queries c Lock tables 23 Which SQL clause filters rows? a ORDER BY b WHERE c HAVING ALL 24 What is the purpose of an index? a Speed up queries b Encrypt data c Increase storage 25 Which PHP function starts a session? a begin_session b start_session c session_start 26 Which file stores DB credentials securely? a config.php b index.html c .env.local 27 Which approach protects passwords best? a Store plain text b Hash and verify c Encrypt only once 28 Which HTTP status indicates success? a 500 Internal Server Error b 200 OK c 404 Not Found 29 Which phase follows design in PM? a Closure b Implementation c Testing 30 Which document defines milestones? a Project charter b User manual c Bug report 31 Which role manages the project plan? a Project manager b DBA c Developer 32 Which practice improves reliability of login? a Ignore failures b Account lockout after failed attempts c Always allow retries 33 Which technique hides DB details from the UI? a MVC pattern b Monolithic c Direct SQL in UI 34 Which security measure limits data access? a Anonymous access b IP whitelisting only c Role-based access control 35 Which term means making a site live? a Deployment b Design c Drafting 36 Which SQL join returns all rows from left table? a LEFT JOIN b RIGHT JOIN c INNER JOIN 37 Which project metric measures time to deliver? a Width b Velocity c Depth 38 Which tool automates tests? a SSH b CI/CD c FTP 39 Which PHP feature helps reuse code? a Globals b Functions / include c Inline scripts 40 What is a safe default for DB ports? a Use non-default when possible b Hide port entirely c Always use 3306 41 Which technique protects session data? a Store in GET b Ignore sessions c Regenerate session_id 42 Which term describes a database view? a Physical table b File c Virtual table 43 Which method stores passwords securely in PHP? a base64_encode b md5 alone c password_hash with PASSWORD_DEFAULT 44 Which database design principle minimizes anomalies? a Denormalization b Normalization c Replication 45 Which statement updates user info? a MODIFY users ... b CHANGE users ... c UPDATE users SET ... WHERE ...; 46 What architecture separates concerns in web apps? a Spaghetti code b MVC architecture c Monolithic 47 Which tool helps publish DB schemas online? a Database hosting service b Local file c Desktop editor 48 Which concept ensures only necessary users access data? a No access b Principle of least privilege c All access 49 Which SQL clause sorts results? a FILTER b ORDER BY c GROUP BY 50 What is a primary key? a Unique row identifier b Foreign key c Column type

Using Databases for Web Development Lowersixth Science Computer Science

Froggy Jumps

About this activity

Created by

Download the paper version to play

Top Games

Froggy Jumps

Ethos, Pathos, and Logos Quiz

Froggy Jumps

Phlebotomy Order of Draw Quiz

Froggy Jumps

Bill of Rights Game - The Constitutionalist

Froggy Jumps

pizza

Froggy Jumps

The Integumentary System

Froggy Jumps

Using Databases for Web Development Lowersixth Science Computer ScienceOnline version

by YAKILI LMS

Which PHP function connects to a MySQL database?

Which data type should you store a user's password?

Which PHP extension is commonly used to interact with MySQL?

What is a secure way to verify passwords in PHP?

Which SQL statement inserts a new user?

Which SQL statement retrieves user login data?

What is the role of a UNIQUE constraint?

Which method helps prevent SQL injection?

Which PHP superglobal holds form data?

Which HTTP method submits login forms securely?

What is a common way to hash passwords in PHP 8?

Which database parameter is essential for security?

What is a publishable database term?

Which protocol secures data transfer to the database server?

Which PHP feature helps organize code for projects?

Which project management concept tracks tasks visually?

Which artifact documents requirements?

What is a key risk in web projects?

Which stage involves testing the database?

What do you call a separate environment for testing?

Which tool helps publish a database on the internet?

What is database normalization primarily for?

Which SQL clause filters rows?

What is the purpose of an index?

Which PHP function starts a session?

Which file stores DB credentials securely?

Which approach protects passwords best?

Which HTTP status indicates success?

Which phase follows design in PM?

Which document defines milestones?

Which role manages the project plan?

Which practice improves reliability of login?

Which technique hides DB details from the UI?

Which security measure limits data access?

Which term means making a site live?

Which SQL join returns all rows from left table?

Which project metric measures time to deliver?

Which tool automates tests?

Which PHP feature helps reuse code?

What is a safe default for DB ports?

Which technique protects session data?

Which term describes a database view?

Which method stores passwords securely in PHP?

Which database design principle minimizes anomalies?

Which statement updates user info?

What architecture separates concerns in web apps?

Which tool helps publish DB schemas online?

Which concept ensures only necessary users access data?

Which SQL clause sorts results?

What is a primary key?