Search Header Logo

Unit 5 Review

Authored by Michael Jakubowski

Other

9th - 12th Grade

Used 28+ times

Unit 5 Review
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The following browser request displays the search results of all fiction books that are available to purchase from an online book store.

https://insecure-website.com/products?category=Fiction

Which of the following browser requests correctly attempts to use a SQL injection to extract additional data from the original request?

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the statements is true based on the following query?

SELECT name, occupation FROM Employee WHERE age < 45;

The name of the database is ‘occupation’.

There is a column for Employee in the table.

There is a column for age in the table.

The name of the database is name.

The name of the database is ‘occupation’.

There is a column for Employee in the table

There is a column for age in the table.

The name of the database is name.

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which is not true according to the following query?

SELECT name FROM Users WHERE id = 90;

The name of the table is Users.

There is a column for name in the table.

There is a row for id in the table.

The name column will be displayed as a result of this query for all records where the id = 90.

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which query will return the entire Gamers table?

SELECT all FROM Gamers;

SELECT * FROM Gamers;

SELECT DATABASE FROM Gamers;

SELECT ALL FROM Gamers;

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which type of SQL injection attack occurs by adding a condition that is always true to a query to extract additional information from the database?

Error-based SQLi

Union-based SQLi

Blind SQLi

Conditional SQLi

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Some of the best ways to prevent or at least mitigate a SQLi attack are to

A. Keep data separate from commands and queries

B. Use a safe API

C. Reduce the amount of SQL used overall

D. Use server-side input validation

E. Use other SQL controls to prevent mass disclosure of records

F. Avoid leaving any raw SQL in the code G. Have SQL reside behind multiple layers in the code base and not accessible by the site

C, E, F, and G

A, B, and D

A, B, C, and D

All options are correct.

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which operator means “not equal to” in SQL?

x=

=!

<>

/=

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?