Final-CS008 Textbook Questions

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

If a browser viewport is 400px wide, how wide are the two inner <div>elements? <div width="300px"> <div width="50vw">A</div> <div width="50%">B</div> </div> A = 200px, B = 150px A = 150px, B = 150px A = 200px, B = 200px

A = 200px, B = 150px

What default body font does Reboot use? Times New Roman Courier New A sans-serif font

A sans-serif font

What is wrong with the SQL statement below? SELECT first_name from student "from" must be "FROM". The WHERE clause is missing. A terminating semicolon is missing.

A terminating semicolon is missing.

Assuming warnings and error messages are set to output to the browser, what would be displayed in the browser if require in the figure above was replaced with include, and color.php was not in the current directory? "That's so random!" A warning message only A warning message and fatal error message

A warning message and fatal error message

Node.js, ASP.NET, Ruby on Rails, PHP, Java, Python, Collection of web development technologies first released in 2002 by Microsoft that uses the C# or VB.NET programming languages.

ASP.net

ALTER TABLE student ADD address VARCHAR(80);

Adds an address column.

Which team will win the SEC Championship? <label><input type="radio" name="team" value="Crimson Tide">University of Alabama</label> <label><input type="radio" name="team" value="Razorbacks">University of Arkansas</label> <label><input type="radio" name="team" value="Tigers">Auburn University</label> <label><input type="radio" name="team" value="Gators">University of Florida</label> <label><input type="radio" name="team" value="Volunteers">University of Tennessee</label> <label><input type="radio" name="team" value="Aggies">Texas A&M University</label> <label><input type="radio" name="team" value="Other">Other</label> What is the value of $_POST["team"] if the user selects Texas A&M University? Texas A&M University Aggies Impossible

Aggies

What dates are selected? SELECT release_date FROM tv_show WHERE NOT title = 'The Office'; No dates All dates 2012-10-10

All dates

All shows

What shows are deleted? DELETE FROM tv_show; All shows No shows The SQL is syntactically incorrect because the WHERE clause is missing.

All shows

What shows are updated? UPDATE tv_show SET release_date = '2017-12-25'; All shows No shows Arrow

All shows

UPDATE shows SET title='The Office', seasons=9;

All shows are assigned the title "The Office" and season set to 9.

DELETE FROM shows;

All shows are removed.

What is output if the user attempts to save Deshawn with ID 777, but the table students does not exist? Deshawn was successfully inserted. Couldn't insert Deshawn because ID 777 already exists. An exception error message.

An exception error message.

Application programming interface, Testing framework, Business logic, Server and hosting environment, User interface, data modeling Programmable actions that may be performed on the underlying data. Often used by the front-end to interact with the back-end.

Application programming interface

LIKE '%row'

Arrow

CREATE TABLE shows ( showId INTEGER, title VARCHAR(45), seasons INTEGER, releaseDate DATE, PRIMARY KEY (showId) ); INSERT INTO shows VALUES (111, 'Grey\'s Anatomy', 12, '2005-03-27'), (222, 'Arrow', 5, '2012-10-10'), (333, 'The Blacklist', 4, '2013-09-23'), (444, 'Parks and Recreation', 7, '2009-04-09'); What shows are selected by the following query? SELECT * FROM shows WHERE seasons <= 10 AND seasons >= 5; All shows Arrow and Parks and Recreation Grey's Anatomy

Arrow and Parks and Recreation

What shows are selected? SELECT * FROM tv_show WHERE seasons <= 10 AND seasons >= 6; All shows Arrow and Parks and Recreation Grey's Anatomy

Arrow and Parks and Recreation

What shows are selected? SELECT * FROM tv_show WHERE seasons = 6 OR release_date > '2013-01-01'; All shows Arrow and Parks and Recreation Arrow and The Blacklist

Arrow and The Blacklist

CREATE TABLE shows ( showId INTEGER, title VARCHAR(45), seasons INTEGER, releaseDate DATE, PRIMARY KEY (showId) ); INSERT INTO shows VALUES (111, 'Grey\'s Anatomy', 12, '2005-03-27'), (222, 'Arrow', 5, '2012-10-10'), (333, 'The Blacklist', 4, '2013-09-23'), (444, 'Parks and Recreation', 7, '2009-04-09'); In what order are the shows retrieved by the following query? SELECT * FROM shows ORDER BY title; Grey's Anatomy, Arrow, The Blacklist, Parks and Recreation Arrow, Grey's Anatomy, Parks and Recreation, and The Blacklist The Blacklist, Parks and Recreation, Grey's Anatomy, Arrow

Arrow, Grey's Anatomy, Parks and Recreation, and The Blacklist

CREATE TABLE __A__ ( fac_id __B__, last_name VARCHAR(50), first_name VARCHAR(50), dept_code __C__(4), hire_date __D__, tenured__E__, PRIMARY KEY(__F__) ); E

BOOLEAN

LEFT OUTER

Banner Math Department Grayson Art Department Grey NULL Parker Math Department Quinn Math Department Stark Computer Science Department Wayne Art Department The left join includes all rows from the faculty table (the left table). Grey has no department, so NULL appears for the department name in the join.

INNER

Banner Math Department Grayson Art Department Parker Math Department Quinn Math Department Stark Computer Science Department Wayne Art Department The inner join only includes rows where both tables share the same department code. The join results are ordered by last name.

M_LOG10E

Base 10 logarithm of E (0.43429448190325)

Where is the media query placed in the CSS? Above the bodyrule. Inside the bodyrule. Below the bodyrule.

Below the bodyrule.

What is the last name output by the for loop?$names = ["Beth", "Lance", "Jose"]; for ($i = count($names) - 1; $i >= 0; $i--) { echo $names[$i], "\n"; }

Beth

body { background: green; } @media only screen and (min-width: 600px) { body { background: blue; } } @media only screen and (min-width: 800px) { body { background: red; } } Which of the media queries evaluate to true on a desktop browser that is 900px wide? Neither of the media queries. The second media query only. Both media queries.

Both media queries.

Application programming interface, Testing framework, Business logic, Server and hosting environment, User interface, data modeling Programming logic on the front or back-end that determines how data can be created, displayed, stored, and changed.

Business logic

ALTER TBLE STUDENT MODIFY BIRTH_DATE INT;

Changes birth_date data type to INT.

A new ____ is needed to store each student's address. table column row

Column

LIKE '%c_m%'

Community

Performance testing, Usability testing, Security testing, Functionality testing, Compatibility testing, interface testing Testing the web application's ability to work on various browsers, operating systems, and platforms.

Compatibility testing

After saving Tom, what is output if the user attempts to save a second student named Mandy using ID 744? Mandy was successfully inserted. Couldn't insert Mandy because ID 744 already exists. An exception error message.

Couldn't insert Mandy because ID 744 already exists.

CREATE TABLE __A__ ( fac_id __B__, last_name VARCHAR(50), first_name VARCHAR(50), dept_code __C__(4), hire_date __D__, tenured__E__, PRIMARY KEY(__F__) ); D

DATE

The _____ data type is ideal for creating a column that stores a student's date of birth. DATETIME DATE

DATE

INSERT INTO student VALUES ('Parks', 'Ebony', 555, 3.9);

Data is not in the correct order.

INSERT INTO students VALUES ('Ebony', 555,3.9);

Data is not in the correct order.

Application programming interface, Testing framework, Business logic, Server and hosting environment, User interface, data modeling Representing, storing, and retrieving application data in relational and non-relational databases.

Data modeling

DROP TABLE student;

Deletes the student table

E_ERROR- fatal error, E_PARSE-parse error, E_WARNING- warning, E_NOTICE-notice while (TRUE);

E_ERROR- fatal error

E_ERROR- fatal error, E_PARSE-parse error, E_WARNING- warning, E_NOTICE-notice echo $answer

E_PARSE-parse error

E_ERROR- fatal error, E_PARSE-parse error, E_WARNING- warning, E_NOTICE-notice $answer = 2 / 0;

E_WARNING-warning

What is the title for the class with class_id 1002? English Composition African History Data Structures

English Composition

M_E

Euler's constant (2.718281828459)

SELECT * FROM tv_show;

Everything in the table

A developer that modifies an existing desktop website for a mobile device is using a progressive enhancement design strategy.

False

A mobile user should never have access to the desktop version of a website when a mobile version is available

False

A single INSERT statement can insert only one row into a table.

False

A web hosting company that hosts websites for free is likely to provide services like automated backups, unlimited disk space, and 24-hour customer support.

False

A website should serve a 3x image to a 2 DPR device even if a 2x image is available.

False

According to StatCounter, mobile browsers will likely account for more web traffic than desktop browsers in the next year.

False

An INSERT statement must name the table's columns.

False

Assuming no other CSS properties apply to the images below, the images appear directly next to each other. <img src="dog.jpg" class="img-fluid"> <img src="cat.jpg" class="img-fluid">

False

CREATE TABLE faculty ( fac_id INTEGER PRIMARY KEY, last_name VARCHAR(50), first_name VARCHAR(50), dept_code VARCHAR(4), hire_date DATE, tenured BOOLEAN ); The fac_id column can have a NULL value.

False

CSS front-end frameworks are required to build responsive websites that work well on mobile devices.

False

Changing the device in the emulator changes the user agent in the "Network conditions" tab.

False

Client-side data validation makes server-side data validation unnecessary.

False

Developers normally create 1x, 2x, and 3x SVG images to target various DPR devices.

False

Every student is enrolled in at least one class.

False

Flexbox is not used in the CSS.

False

Haml code can be rendered directly in a web browser.

False

If disk cache is disabled, the cache remains disabled when the DevTools are closed.

False

If the grade table had a grade for course 3000 that was not assigned to a student ID (stu_id is NULL), the grade would appear in the join results.

False

In the animation above, footer.php used a variable defined in header.php. header.php could also have used a variable defined in footer.php.

False

Navigation links are often just as visible on mobile websites as on desktop websites.

False

Only PHP files may be included with the includestatement.

False

Phone numbers and addresses are typically of equal importance to desktop and mobile website users

False

RWD requires the web server to examine the user agent string in HTTP requests

False

RWD uses JavaScript to alter the page contents to fit the browser.

False

Refer to the figure above that uses an UPDATE statement. If $stuid is not in the students table, a PDOException is thrown.

False

Referring to the figures above, if the user submitted the name as "<h1>Pam</h1>" and howmany as 4 , the browser would display: "Pam ordered 4 widgets."

False

Relational databases will likely not be used for many web applications in the future.

False

Removing display:grid; from the body selector changes the rendered web page significantly.

False

SQL syntax from one RDBMS usually works without modification in another RDBMS.

False

SVG is ideal for photographs.

False

StatCounter is able to track mobile and desktop browser usage by using a device's camera to watch users accessing the web.

False

The Pixel 2 with DPR 2.6 downloads the guitar_support_300.jpg image

False

The UPDATE statement changes Lopez's student ID and GPA. UPDATE student SET stu_id = 123, gpa = 2.5 WHERE stu_id = 456;

False

The UPDATE statement changes Miller's GPA to 3.0. UPDATE student SET gpa = 3.0 WHERE stu_id = 987;

False

The business logic of an SPA should generally be encoded in the front-end.

False

The code segment outputs "<p>How are you?</p>". function askQuestion() { echo "<p>$question</p>"; } $question = "How are you?"; askQuestion();

False

The code segment outputs 6.function multiplyNumbers($x, $y) { $answer = $x * $y; return $answer; } $z = multiplyNumbers(2, 3); echo $answer; True False

False

The desktop media query appears above the tablet media query.

False

The desktop media query is true on a desktop browser that is 700 pixels wide.

False

The developer can change the emulated width and height when the emulator is in Device mode.

False

The emulator is only capable of emulating the iPhone.

False

The following INSERT statements add two students into the students table. INSERT INTO student VALUES (777, 'Red', 'Rosy', 4.0); INSERT INTO student VALUES (777, 'White', 'Willow', 3.1);

False

The following code uses the getData() function from the figure above and provides sufficient data validation for a 16 digit credit card number. $creditCardNum = getData("creditCardNum"); if (strlen($creditCardNum) == 16) { // Valid number } else { // Invalid number }

False

The geolocation (latitude and longitude) of the emulated device is modified by moving the desktop computer to a different location.

False

The height property is often used in the viewport meta tag.

False

The if statement is true.if (ord("Hello") < ord("Goodbye")) { ... }

False

The number 5 billion may be stored in an INTEGER column

False

The students table may contain two students with the same stuId.

False

The words "CREATE TABLE" must be capitalized in a CREATE TABLE statement.

False

The www.whitehouse.gov home page looks identical in desktop Chrome and in an emulated iPhone 6 browser

False

TypeScript code is executed by the web browser.

False

UI libraries always use JavaScript to govern the behavior of the UI widgets.

False

Video is often played automatically on mobile websites

False

Web applications typically use the same physical database in both the development environment and deployment environment

False

Web hosting companies generally charge more for hosting on Linux servers than for hosting on Windows servers

False

When an HTML form uses method="post" and submits to a PHP script, the form values appear in the URL's query string.

False

SELECT SUBSTRING(best_move, 7, 6) FROM avatar WHERE avatar_id = 4;

Finale

date_format($date, "r")

Fri, 12 Sep 2014 20:04:15 -0500

Performance testing, Usability testing, Security testing, Functionality testing, Compatibility testing, interface testing Verifying that each individual application function is working as expected

Functionality Testing

What is $_SERVER["REQUEST_METHOD"]the first time a script is loaded in the web browser? GET POST

GET

What does the code below output? sayGoodbye("Sam"); function sayGoodbye($name) { echo "Goodbye, $name"; } Goodbye, Sam Goodbye, $name Goodbye,

Goodbye, Sam

CREATE TABLE shows ( showId INTEGER, title VARCHAR(45), seasons INTEGER, releaseDate DATE, PRIMARY KEY (showId) ); INSERT INTO shows VALUES (111, 'Grey\'s Anatomy', 12, '2005-03-27'), (222, 'Arrow', 5, '2012-10-10'), (333, 'The Blacklist', 4, '2013-09-23'), (444, 'Parks and Recreation', 7, '2009-04-09'); The DATEDIFF()function returns the number of days between two dates. What shows are selected by the following query? SELECT * FROM shows WHERE DATEDIFF('2016-08-01', releaseDate) > 365 * 10; All shows No shows Grey's Anatomy

Grey's Anatomy

CREATE TABLE shows ( showId INTEGER, title VARCHAR(45), seasons INTEGER, releaseDate DATE, PRIMARY KEY (showId) ); INSERT INTO shows VALUES (111, 'Grey\'s Anatomy', 12, '2005-03-27'), (222, 'Arrow', 5, '2012-10-10'), (333, 'The Blacklist', 4, '2013-09-23'), (444, 'Parks and Recreation', 7, '2009-04-09'); The YEAR() function extracts the year from the given date. What is selected by the following query? SELECT title, YEAR(releaseDate) FROM shows; Grey's Anatomy 2005 2005, 2012, 2013, 2009 Grey's Anatomy 2005, Arrow 2012, The Blacklist 2013, Parks and Recreation 2009

Grey's Anatomy 2005, Arrow 2012, The Blacklist 2013, Parks and Recreation 2009

What shows are deleted? DELETE FROM tv_show WHERE genre = 'drama'; All shows Grey's Anatomy Grey's Anatomy and The Blacklist

Grey's Anatomy and The Blacklist

What shows are selected? SELECT * FROM tv_show WHERE (seasons >= 6 AND seasons <= 10) OR release_date = '2005-03-27'; All shows Arrow and Parks and Recreation Grey's Anatomy, Arrow, and Parks and Recreation

Grey's Anatomy, Arrow, and Parks and Recreation

LIKE '%an%'

Greys Anatomy and Parks and Recreation

What does the below code output? sayHello("Sam"); sayHello("Juan", "Hola"); function sayHello($name, $greeting = "Hello") { echo "$greeting, $name\n"; } Hello, Sam Hello, Juan Hello, Sam Hola, Juan Hola, Sam Hola, Juan

Hello, Sam Hola, Juan

What values are required to create a PDO object? Username and password only Hostname only Hostname, database name, username, and password

Hostname, database name, username, and password

What value is $points?$points = 4; $points /= 0;

INF

CREATE TABLE __A__ ( fac_id __B__, last_name VARCHAR(50), first_name VARCHAR(50), dept_code __C__(4), hire_date __D__, tenured__E__, PRIMARY KEY(__F__) ); B

INTEGER

INSERT INTO student VALUES (777, 'O'Malley', 'Bill', 3.0);

Illegal use of single quotation mark.

INSERT INTO students VALUES (777, 'O'Malley', 3.0);

Illegal use of single quotation mark.

Where should the data validation code be placed?if ($_POST["num"] == "") { echo "<p>You didn't type a number.</p>"; } Before if ($_SERVER["REQUEST_METHOD"] == "POST") { ... } Inside if ($_SERVER["REQUEST_METHOD"] == "POST") { ... } After if ($_SERVER["REQUEST_METHOD"] == "POST") { ... }

Inside if ($_SERVER["REQUEST_METHOD"] == "POST") { ... }

department tabledept_codenameARTArt DepartmentCOMPComputer Science DepartmentENGEnglish DepartmentHISTHistory DepartmentMATHMath Department 666, 'Pratt', 'Becky', 'ENGG', '2017-07-16', FALSE Valid Invalid

Invalid

Node.js, ASP.NET, Ruby on Rails, PHP, Java, Python, Used to create applets on the front-end and servlets, JavaServer Pages, and web APIs on the back-end.

Java

left join

Join all rows from table A (the left table) along with rows from table B where the join condition is met.

right join

Join all rows from table B (the right table) along with rows from table A where the join condition is met.

outer join

Join all rows from tables A and B regardless if the join condition is met.

inner join

Join all rows from tables A and B where the join condition is met.

If the row with the F grade is removed from the grade table, then the FULL OUTER JOIN below produces the same results as what other join? SELECT last_name, course_id, grade FROM student FULL OUTER JOIN grade ON student.stu_id = grade.stu_id; RIGHT OUTER LEFT OUTER INNER

LEFT OUTER

SELECT REPLACE(name, "Kn", "Fr") FROM avatar WHERE avatar_id = 2;

Meta Fright

Which books did you read this summer? <label><input type="checkbox" name="books[]" value="Miranda"> Hamilton: The Revolution</label> <label><input type="checkbox" name="books[]" value="Duckworth"> Grit: The Power of Passion and Perseverance</label> <label><input type="checkbox" name="books[]" value="Sunstein"> The World According to Star Wars</label> <label><input type="checkbox" name="books[]" value="Knight"> Shoe Dog: A Memoir by the Creator of Nike</label> If Hamilton and Grit are the only books checked, what is the output?echo $_POST["books"][0]; Miranda Hamilton: The Revolution Miranda and Duckworth

Miranda

INSERT INTO student VALUES 222, 'Woods', 'Darnell', 3.0;

Missing parenthesis around data values.

INSERT INTO students VALUES 222, 'Darnell', 3.0;

Missing parenthesis around data values.

INSERT INTO student VALUES (444,Black,Zack,3.2);

Missing single quotation marks.

INSERT INTO students VALUES (444,Zack,3.2)

Missing single quotation marks.

FULL OUTER

NULL English Department NULL History Department Banner Math Department Grayson Art Department Grey NULL Parker Math Department Quinn Math Department Stark Computer Science Department Wayne Art Department The full outer join includes rows from the left and right tables that do not have matching department codes.

RIGHT OUTER

NULL English Department NULL History Department Banner Math Department Grayson Art Department Parker Math Department Quinn Math Department Stark Computer Science Department Wayne Art Department The right join includes the two departments in the department table (the right table) that do not have faculty.

M_LN2

Natural logarithm of 2 (0.69314718055995)

Are columns A and B ever on the same row? <div class="row"> <div class="col-sm-9">A</div> <div class="col-sm-4">B</div> </div> Yes No

Can two classes with the same course_id have a different number of credit hours? Yes No

Is there a media type that specifically targets mobile devices? Yes No

Must every primary key value be used in a foreign key? Yes No

Must media queries have at least one expression after the media type? Yes No

body { background: green; } @media only screen and (min-width: 600px) { body { background: blue; } } @media only screen and (min-width: 800px) { body { background: red; } } Does removing the keyword "only" from the media queries have any effect on the latest Chrome browser? Yes No

What dates are selected? SELECT release_date FROM tv_show WHERE title = 'The Office'; No dates 2012-10-10 2012-10-10 and 2009-04-09

No dates

LIKE '_row'

No matches

UPDATE shows SET title='The Office' WHERE should=999;

No shows are updated.

Node.js, ASP.NET, Ruby on Rails, PHP, Java, Python Runtime environment that uses modules written in JavaScript. Originally created in 2009 by Ryan Dahl.

Node.js

// Select students that have a GPA equal to or above 2.0 $sql = "SELECT stuid, name, gpa FROM students WHERE gpa >= 2.0"; // Issue the query $statement = $pdo->query($sql); // Loop through all the rows returned by the query foreach ($statement as $row) { echo "$row[stuid] - $row[name] has a $row[gpa] GPA<br>\n"; } Assuming the students table has only the three students in the animation above, what is output by the code below?$sql = "SELECT name FROM students WHERE stuId = 999"; $statement = $pdo->query($sql); $row = $statement->fetch(); if ($row) { echo $row["name"]; } else { echo "Not found"; } A PDOException is thrown. Sue Not found

Not found

preg_match("/\w+y/", "zing zany zone", $matches); echo $matches[1]; Notice message zing zany zone zany

Notice message

Greys Anatomy 12 drama The Blacklist 5 drama Parks and Recreation 7 comedy Community 6 comedy Arrow 6 action ORDER BY seasons DESC ORDER BY genre ORDER BY genre DESC

ORDER BY genre DESC

Arrow 6 action Community 6 comedy Parks and Recreation 7 comedy The Blacklist 5 drama Greys Anatomy 12 drama ORDER BY seasons, genre ORDER BY genre, seasons ORDER BY genre, title

ORDER BY genre, seasons

Arrow 6 action Community 6 comedy Greys Anatomy 12 drama Parks and Recreation 7 comedy The Blacklist 5 drama ORDER BY title ORDER BY seasons ORDER BY genre

ORDER BY title

The Blacklist 5 drama Arrow 6 action Community 6 comedy Parks and Recreation 7 comedy Greys Anatomy 12 drama ORDER BY title ORDER BY seasons ORDER BY genre

ORDER by seasons

Node,js, ASP.NET, Ruby on Rails, PHP, Java, Python, Scripting language created in 1994 by Rasmus Lerdorf. Currently the most popular server-side language in use.

PHP

Referring to the figure above, what is $_SERVER["REQUEST_METHOD"]when the user clicks the "Guess" button a second time? GET POST

POST

What shows are updated? UPDATE tv_show SET seasons = seasons + 1 WHERE genre = 'comedy'; All shows Parks and Recreation Parks and Recreation and Community

Parks and Recreation and Community

Performance testing, Usability testing, Security testing, Functionality testing, Compatibility testing, interface testing Verifying the web server is able to respond reasonably under various load conditions.

Performance testing

Node.js, ASP.NET, Ruby on Rails, PHP, Java, Python, General-purpose scripting language created by Guido van Rossum in the 1990s that uses frameworks like Django, web2py, and Flask to create web applications.

Python

What is missing to produce the same results as the LEFT OUTER JOIN in the animation? SELECT last_name, course_id, grade FROM grade ____ JOIN student ON student.stu_id = grade.stu_id; RIGHT OUTER LEFT OUTER FULL OUTER

RIGHT OUTER

$x = rand(5, 10); Random integer between 5 and 10 (inclusive) Random integer < 5 or > 10 5 or 10

Random integer between 5 and 10 (inclusive)

ALTER TABLE student DROP COLUMN birth_date;

Removes the birth_date column

Select

Retrieve

Which team will win the SEC Championship? <label><input type="radio" name="team" value="Crimson Tide">University of Alabama</label> <label><input type="radio" name="team" value="Razorbacks">University of Arkansas</label> <label><input type="radio" name="team" value="Tigers">Auburn University</label> <label><input type="radio" name="team" value="Gators">University of Florida</label> <label><input type="radio" name="team" value="Volunteers">University of Tennessee</label> <label><input type="radio" name="team" value="Aggies">Texas A&M University</label> <label><input type="radio" name="team" value="Other">Other</label> What is output when the user selects University of Arkansas?if ($_POST["team"] == "razorbacks") { echo "Woo Pig Sooie!"; } else { echo "Roll tide!"; } Woo Pig Sooie! Roll tide!

Roll tide!

Node.js, ASP.NET, Ruby on Rails, PHP, Java, Python Web application framework written in Ruby and created by David Heinemeier Hansson in 2004.

Ruby on Rails

Choose the correct call to the function below. function sayGoodbye($name) { echo "Goodbye, $name"; } sayGoodbye(); SAYGOODBYE("Sam"); say_goodbye("Sam");

SAYGOODBYE("Sam");

x y 5 2 9 1 3 10 3 8 7 SELECT x - y FROM problem; SELECT ABS(x - y) FROM problem; SELECT -1 * (x - y) FROM problem;

SELECT ABS(x - y) FROM problem;

SELECT DATEDIFF(due, assigned) FROM assignment WHERE assign_id = 1;

SELECT DAY(due) FROM assignment WHERE assign_id = 4;

SELECT HOUR(assigned) + MINUTE(assigned) FROM assignment WHERE assign_id = 2;

2014 SELECT MAX(year) FROM auto; SELECT MIN(price) FROM auto; SELECT MIN(year) FROM auto;

SELECT MIN(year) FROM auto;

x y 5 2 9 1 3 10 2.2 3.0 1.7 SELECT ROUND(x, 1) FROM problem; SELECT SQRT(x) FROM problem; SELECT ROUND(SQRT(x), 1) FROM problem;

SELECT ROUND(SQRT(x), 1) FROM problem;

x y 5 2 9 1 3 10 3 9 0 SELECT x / y FROM problem; SELECT ROUND(x / y, 0) FROM problem; SELECT ROUND(x / y, 1) FROM problem;

SELECT ROUND(x / y, 0) FROM problem;

92300 SELECT SUM(price) FROM auto; SELECT AVG(price) FROM auto; SELECT MAX(price) FROM auto;

SELECT SUM(price) FROM auto;

23:59:00

SELECT TIME(due) FROM assignment WHERE assign_id = 2;

01:00:00

SELECT TIMEDIFF(due, assigned) FROM assignment WHERE assign_id = 3;

Ford 1 Honda 2 Toyota 3 Volkswagen 1 SELECT make, COUNT(*) FROM auto; SELECT make, COUNT(*) FROM auto GROUP BY make; SELECT COUNT(*) FROM auto GROUP BY make;

SELECT make, COUNT(*) FROM auto GROUP BY make;

compact 8800 sedan 10200 suv 16900 crossover 17900 SELECT type, MAX(price) FROM auto GROUP BY type; SELECT type, MAX(price) FROM auto GROUP BY type ORDER BY price; SELECT type, MAX(price) FROM auto GROUP BY type ORDER BY MAX(price);

SELECT type, MAX(price) FROM auto GROUP BY type ORDER BY MAX(price);

x y 5 2 9 1 3 10 7 10 13 SELECT x + y FROM problem; SELECT x - y FROM problem; SELECT x * y FROM problem;

SELECT x + y FROM problem;

x y 5 2 9 1 3 10 5 1 5 9 0 1 3 3 27 SELECT x, POW(x, x % y) FROM problem; SELECT x, x % y, POW(x, y) FROM problem; SELECT x, x % y, POW(x, x % y) FROM problem;

SELECT x, x % y, POW(x, x % y) FROM problem;

2014 8800 2015 13350 2016 14200 2017 17900 SELECT year, AVG(price) FROM auto GROUP BY year; SELECT year, AVG(year) FROM auto GROUP BY year; SELECT price, AVG(price) FROM auto GROUP BY year;

SELECT year, AVG(price) FROM auto GROUP BY year;

2014 compact 8800 2015 sedan 9800 2015 suv 16900 2016 sedan 10200 2016 crossover 17900 SELECT year, MAX(price) FROM auto GROUP BY year, type ORDER BY year, MAX(price); SELECT year, type, MAX(price) FROM auto GROUP BY year ORDER BY year, MAX(price); SELECT year, type, MAX(price) FROM auto GROUP BY year, type ORDER BY year, MAX(price);

SELECT year, type, MAX(price) FROM auto GROUP BY year, type ORDER BY year, MAX(price);

What language is used to add new students to the students table? SQL RDBMS MySQL

SQL

Performance testing, Usability testing, Security testing, Functionality testing, Compatibility testing, interface testing Ensuring the integrity and privacy of the user's data and interactions with the web application.

Security testing

DELETE FROM shows WHERE MONTH(releaseDate)=7;

Seinfeld is removed from the table.

date_format($date, "M d")

Sep 12

Application programming interface, Testing framework, Business logic, Server and hosting environment, User interface, data modeling Issues regarding network throughput, cloud storage, virtualization, hardware constraints, multithreading, and data redundancy.

Server and hosting environment

date_format($date, "D")

Sun

SELECT CONCAT('Super ', name) FROM avatar WHERE avatar_id = 1;

Super Link

INSERT INTO student (stu_id, last_name) VALUES (888, 'Wang')

Syntactically correct statement.

INSERT INTO students (stuld, name) VALUES (888, 'Wang');

Syntactically correct statement.

Application programming interface, Testing framework, Business logic, Server and hosting environment, User interface, data modeling Automated tests that verify the web application components are working properly, independently and together.

Testing framework

Referring to the animation above, why might the PDOconstructor throw an exception? The username and password are correct. The MySQL server is running on localhost. The "test" database does not exist.

The "test" database does not exist.

CREATE TABLE shows ( showId INTEGER, title VARCHAR(45), seasons INTEGER, releaseDate DATE, PRIMARY KEY (showId) ); INSERT INTO shows VALUES (111, 'Grey\'s Anatomy', 12, '2005-03-27'), (222, 'Arrow', 5, '2012-10-10'), (333, 'The Blacklist', 4, '2013-09-23'), (444, 'Parks and Recreation', 7, '2009-04-09'); What shows are selected by the following query? SELECT * FROM shows WHERE seasons < 5; All shows Arrow and The Blacklist The Blacklist

The Blacklist

NOT LIKE '%0%'

The Blacklist

What shows are selected? SELECT * FROM tv_show WHERE seasons < 6; All shows Arrow and The Blacklist The Blacklist

The Blacklist

What is wrong with the SQL statement below? SELECT gpa --FROM student; The FROM clause is a comment. The WHERE clause is missing. gpa should be a table name.

The FROM clause is a comment.

What happens when the Modal is displayed and the user clicks the dark part of the screen outside of the Modal or presses the ESC key? The Modal hides, and the green Alert displays. The Modal remains visible. The Modal hides, and no Alerts are displayed.

The Modal hides, and no Alerts are displayed.

What is syntactically wrong with the SELECT statement? SELECT last_name, course_id, grade FROM student RIGHT OUTER JOIN grade ON stu_id = stu_id; RIGHT OUTER should be LEFT OUTER. grade must be the left table and student the right table. The ON clause is missing the table prefix for each stu_id column.

The ON clause is missing the table prefix for each stu_id column.

UPDATE shows SET title='The Office' WHERE seasons>6;

The X-Files and Seinfeld are assigned the title "The Office"

DELETE FROM shows WHERE title LIKE '%Files';

The X-Files is removed from the table.

What is wrong with the SQL statement below? SELECT first_name FROM student WHERE last_name = Smith; The identifier Smith must be surrounded by quotes. first_name should be a table name. No students have the last name "Smith".

The identifier Smith must be surrounded by quotes.

How will a website image that looks good on a standard display look like on a Retina display? The image will look pixelated or blocky. The image will look the same. The image will look sharper.

The image will look pixelated or blocky.

What is $c when the loop terminates?$c = 10; while ($c <= 20) echo $c; $c += 5; 15 20 The loop never terminates.

The loop never terminates.

What is $c when the loop terminates?$c = 10; while ($c <= 20); { echo $c; $c += 5; } 25 20 The loop never terminates.

The loop never terminates.

What is the value of $_GET["comment"] for the query string below?http://localhost/order.php?name=Bob&howmany=1&comment=This+is+a+gift This is a gift This+is+a+gift

This is a gift

What value is $message?$message = "Top"; $message .= "secret";

Top-secret

$name is set to "SPIDER-MAN".$name = strtoupper("Spider-Man");

True

A 1x image looks pixelated on a 2 DPR device.

True

A developer can drag the image that looks like a mobile device to modify the accelerometer's alpha (rotation around the z-axis), beta (left-to-right tilt), and gamma (front-to-back tilt) values.

True

A dynamic web page might look different for two different users who are accessing the same page.

True

A pinch gesture usually zooms in and out of the web page.

True

A relational database can be used to store documents, objects, graphs, and key-value pairs.

True

A small company may host the company's own website on the company's own web server.

True

A table typically has at least one column that uniquely identifies each row

True

According to StatCounter, the Safari mobile web browser is most often used to access the web in North America.

True

An RDBMS may be commercial or open-source software.

True

An SVG image may be defined in a .svg file or in the HTML with the <svg>tag.

True

An attacker could use an XSS attack to redirect the user's browser to a malicious website.

True

Best practice is to set the initial-scaleproperty to 1

True

Both relational and non-relational databases have been implemented with open source software.

True

CREATE TABLE faculty ( fac_id INTEGER PRIMARY KEY, last_name VARCHAR(50), first_name VARCHAR(50), dept_code VARCHAR(4), hire_date DATE, tenured BOOLEAN ); A NULL value in the last_name column may indicate the faculty member has no last name.

True

CREATE TABLE faculty ( fac_id INTEGER PRIMARY KEY, last_name VARCHAR(50), first_name VARCHAR(50), dept_code VARCHAR(4), hire_date DATE, tenured BOOLEAN ); The hire_date column can have a NULL value.

True

CSS preprocessors allow developers to write much less code compared to writing straight CSS.

True

Changing the Network throttling dropdown to "Offline" allows the developer to test how the website behaves with no Internet connection.

True

Column databases are generally faster than relational databases for accessing vast amounts of data.

True

Decreasing a desktop browser's width is an easy way to determine if RWD techniques are being used.

True

Developers use ASP.NET, Java, PHP, Python, Node.js, and Ruby on Rails to create web APIs.

True

Each MySQL user is assigned a username and password.

True

Every class has at least one enrolled student

True

If $_POST["name"] == "" then the user submitted the form without typing their name.

True

If a form submits data with method="get"then $_POST will be empty.

True

JavaScript does not run as quickly on a mobile web browser.

True

JavaScript frameworks often simplify the use of web APIs in the browser.

True

Keeping the content on a desktop website and a separate mobile website consistent can be a challenge.

True

Links are generally larger on mobile websites

True

Loading footer.php from the animation above alone in a web browser results in a warning.

True

Many PHP applications run on Linux with an Apache web server and MySQL as the database

True

Miller appears twice in the resulting join because Miller's student ID appears twice in the grade table.

True

Mobile websites often show less information than their desktop counterparts.

True

Mobile websites should not rely on mouse hovering to trigger actions on the website.

True

Most RDBMSs use SQL as the system's query language

True

MySQL is a popular choice for web hosting companies that provide an RDBMS for their customers.

True

Only one student has less than a 3.0 GPA.

True

PHP is used by Facebook, Wikipedia, and WordPress.

True

Progressive enhancement helps designers to simplify the amount of text displayed on a web page and remove unnecessary clutter.

True

Referring to the figures above, if the user typed a space in the name field, the required attribute would allow the form to be submitted, but the server-side data validation would produce an error message.

True

Rida does not appear in the resulting join because Rida's student ID does not exist in the grade table.

True

SPAs generally result in less data being sent over the network than web applications developed with dynamically generated web pages.

True

Setting the viewport meta tag property user-scalable=no disables zooming.

True

The <body> grid container has 4 grid items.

True

The Chrome browser seems to be replacing the Android browser on many phones.

True

The Chrome screen emulator can display a mobile website in portrait or landscape

True

The UPDATE statement changes Nguyen's student ID and GPA. UPDATE student SET stu_id = 444, gpa = 2.5 WHERE last_name = 'Nguyen';

True

The UPDATE statement changes no one's GPA. UPDATE student SET gpa = 2.0 WHERE stu_id = 333;

True

The body selector's grid-gap property may be modified to put more space between the header and each section.

True

The class that meets in room SCI 200 has 2 enrolled students.

True

The code below outputs 12.$greeting = "How are you?"; echo strlen($greeting);

True

The columns selected must exist in the FROM table or the JOIN table.

True

The desktop media query is true on a desktop browser that is 900 pixels wide.

True

The following INSERT statements add two students into the students table. INSERT INTO student VALUES (999, 'Black', 'Bill', 3.9); INSERT INTO student VALUES (888, 'Green', 'Gary', 3.1);

True

The guitar_support_300.jpg image is downloaded when the device's DPR is 2.

True

The mysql tool attempts to connect to MySQL server running on the same machine as the tool.

True

The mysql tool must be supplied a username and password to connect to MySQL server.

True

The regex /run/matches the string "pruning".

True

The rounded-circleclass makes an image appear in an ellipse.

True

The students table is empty after the table is created.

True

The students table may contain two students with the same name

True

The tablet media query is true on a desktop browser that is 900 pixels wide.

True

Web hosting companies provide various levels of security

True

Web hosting companies provide various levels of security.

True

When an HTML form uses method="get"and submits to a PHP script, $_GET will contain all the values entered in the form.

True

When implementing separate websites, a mobile browser accessing the desktop website may be redirected by the server to the mobile site automatically.

True

mouse.jpg resizes when the <div> resizes. <div class="container-fluid"> <img src="mouse.jpg" class="img-fluid"> </div>

True

rowCount() returns 0 if the executed DELETE statement does not delete any rows.

True

rowCount() returns the number of rows selected by a SELECT statement.

True

Performance testing, Usability testing, Security testing, Functionality testing, Compatibility testing, interface testing Testing the user's ability to properly use the web application for specific purposes.

Usability testing

Application programming interface, Testing framework, Business logic, Server and hosting environment, User interface, data modeling Visual part of the application that users interact with.

User interface

CREATE TABLE __A__ ( fac_id __B__, last_name VARCHAR(50), first_name VARCHAR(50), dept_code __C__(4), hire_date __D__, tenured__E__, PRIMARY KEY(__F__) ); C

VARCHAR

department tabledept_codenameARTArt DepartmentCOMPComputer Science DepartmentENGEnglish DepartmentHISTHistory DepartmentMATHMath Department 777, 'Cruise', 'Tommy', 'COMP', '1999-01-20', TRUE Valid Invalid

Valid

department tabledept_codenameARTArt DepartmentCOMPComputer Science DepartmentENGEnglish DepartmentHISTHistory DepartmentMATHMath Department 999, 'Jones', 'Pam', 'ART', '2000-02-10', FALSE Valid Invalid

Valid

M_PI

Value of π (3.1415926535898)

<picture> <source media="(min-width: 600px)" srcset="dog-wide.jpg, [email protected] 1.5x, [email protected] 2x"> <source media="(min-width: 400px)" srcset="dog.jpg, [email protected] 1.5x [email protected] 2x"> <img src="dog-narrow.jpg" srcset="[email protected] 1.5x, [email protected] 2x" alt="Dog"> </picture> Can the <source> element use the "sizes" attribute like the <img> does? Yes No

Yes

Must PHP statements be terminated by a semicolon? Yes No

Yes

Must every foreign key value come from an existing primary key value? Yes No

Yes

Should column classes always be nested inside of a row class? Yes No

Yes

Will the media query evaluate to true when the web page is being printed? Yes No

Yes

What argument is missing that makes the prepared statement select songs with artists that start with "Black"? $sql = "SELECT * from songs WHERE artist LIKE :artist"; $stmt = $pdo->prepare($sql); $stmt->execute(____);

["artist"=>"Black%"]

Match anything except a vowel (a, e, i, o, u)./[___]/

^aeiou

Match only the letters a through f. /[___]/

a-f

What does the code output?$test = "adios"; echo "$test test"; $test test $adios test adios test

adios test

What media type is used if no media type is specified? all print screen

all

asort($medals); sort($medals); krsort($medals); assort($medals); Japan, China, Soviet Union, USA

asort($medals)

asort($medals); sort($medals); krsort($medals); assort($medals); USA, Soviet Union, China, Japan

assort($medals);

What string does NOT match the regex /cat|bat|mat/? bbatt at mat

/1\s\d/

bison1 9

body { background: green; } @media only screen and (min-width: 600px) { body { background: blue; } } @media only screen and (min-width: 800px) { body { background: red; } } What is the body's background color on an iPhone 8 in landscape mode with a viewport width of 667px? green blue red

blue

What Bootstrap file contains the definition of the bg-success CSS class? bootstrap.min.css bootstrap.min.js jquery-3.1.1.slim.min.js

bootstrap.min.css

Which table should be modified to add an instructor? course class

class

Which column cannot have duplicate values? dept_code class_id credit_hrs

class_id

What CSS class initially hides an Alert? alert-success alert collapse

collapse

Create table

create

Which statement is equivalent to const EMAIL = "[email protected]";? define("EMAIL") = "[email protected]"; define("EMAIL", "[email protected]"); EMAIL = "[email protected]"; Correct

define("EMAIL", "[email protected]");

<img src="dog-small.jpg" srcset="dog-medium.jpg 2x, dog-large.jpg 3x" alt="Dog"> Which image is requested by a device with a 1.5 DPR? dog-small.jpg dog-medium.jpg dog-large.jpg

dog-medium.jpg

<picture> <source media="(min-width: 600px)" srcset="dog-wide.jpg, [email protected] 1.5x, [email protected] 2x"> <source media="(min-width: 400px)" srcset="dog.jpg, [email protected] 1.5x [email protected] 2x"> <img src="dog-narrow.jpg" srcset="[email protected] 1.5x, [email protected] 2x" alt="Dog"> </picture> What image is requested by a 3x device with width = 350px? [email protected] dog-narrow.jpg [email protected]

[email protected]

<img src="dog-small.jpg" srcset="dog-medium.jpg 2x, dog-large.jpg 3x" alt="Dog"> Which image is requested by an old browser that doesn't understand the "srcset" attribute? dog-small.jpg dog-medium.jpg All three images

dog-small.jpg

<picture> <source media="(min-width: 600px)" srcset="dog-wide.jpg, [email protected] 1.5x, [email protected] 2x"> <source media="(min-width: 400px)" srcset="dog.jpg, [email protected] 1.5x [email protected] 2x"> <img src="dog-narrow.jpg" srcset="[email protected] 1.5x, [email protected] 2x" alt="Dog"> </picture> What image is requested by a 1x device with width = 650px? dog-wide.jpg [email protected] dog-narrow.jpg

dog-wide.jpg

<img src="dog400.jpg" sizes="(min-width: 700px) 30vw, (min-width: 500px) 60vw, 100vw" srcset="dog200.jpg 200w, dog400.jpg 400w, dog800.jpg 800w, dog1600.jpg 1600w, dog2000.jpg 2000w"> What image is requested by a 1x device with width = 600px? dog200.jpg dog400.jpg dog800.jpg

dog400.jpg

<img src="dog400.jpg" sizes="(min-width: 700px) 30vw, (min-width: 500px) 60vw, 100vw" srcset="dog200.jpg 200w, dog400.jpg 400w, dog800.jpg 800w, dog1600.jpg 1600w, dog2000.jpg 2000w"> What image is requested by an old browser that does not know what the "sizes" and "srcset" attributes are? dog400.jpg dog800.jpg dog2000.jpg

dog400.jpg

<img src="dog400.jpg" sizes="(min-width: 700px) 30vw, (min-width: 500px) 60vw, 100vw" srcset="dog200.jpg 200w, dog400.jpg 400w, dog800.jpg 800w, dog1600.jpg 1600w, dog2000.jpg 2000w"> What image is requested by a 2x device with width = 400px? dog200.jpg dog400.jpg dog800.jpg

dog800.jpg

<img src="dog400.jpg" sizes="(min-width: 700px) 30vw, (min-width: 500px) 60vw, 100vw" srcset="dog200.jpg 200w, dog400.jpg 400w, dog800.jpg 800w, dog1600.jpg 1600w, dog2000.jpg 2000w"> What image is requested by a 3x device with width = 800px? What image is requested by a 3x device with width = 800px? dog800.jpg dog1600.jpg dog2000.jpg

dog800.jpg

<picture> <source media="(min-width: 600px)" srcset="dog-wide.jpg, [email protected] 1.5x, [email protected] 2x"> <source media="(min-width: 400px)" srcset="dog.jpg, [email protected] 1.5x [email protected] 2x"> <img src="dog-narrow.jpg" srcset="[email protected] 1.5x, [email protected] 2x" alt="Dog"> </picture> What image is requested by a 2x device with width = 400px? dog.jpg [email protected] dog-narrow.jpg

[email protected]

echo "0 $x 0"; echo "9 \$x"; echo '9 $x0'; echo '9 ' . $x; echo '9\\'; echo "9{$x}0"; echo "9$x0"; 9 12 0

echo "9 $x 0";

echo "0 $x 0"; echo "9 \$x"; echo '9 $x0'; echo '9 ' . $x; echo '9\\'; echo "9{$x}0"; echo "9$x0"; 9$x

echo "9 \$x";

echo "0 $x 0"; echo "9 \$x"; echo '9 $x0'; echo '9 ' . $x; echo '9\\'; echo "9{$x}0"; echo "9$x0"; Warning

echo "9$x0";

echo "0 $x 0"; echo "9 \$x"; echo '9 $x0'; echo '9 ' . $x; echo '9\\'; echo "9{$x}0"; echo "9$x0"; 9120

echo "9{$x}0";

E_ERROR- fatal error, E_PARSE-parse error, E_WARNING- warning, E_NOTICE-notice echo $uninitializedVariable;

echo $uninitializedVariable; E_NOTICE- notice

echo "0 $x 0"; echo "9 \$x"; echo '9 $x0'; echo '9 ' . $x; echo '9\\'; echo "9{$x}0"; echo "9$x0"; 9 12

echo '9' . $x;

echo "0 $x 0"; echo "9 \$x"; echo '9 $x0'; echo '9 ' . $x; echo '9\\'; echo "9{$x}0"; echo "9$x0"; 9\

echo '9\\';

CREATE TABLE __A__ ( fac_id __B__, last_name VARCHAR(50), first_name VARCHAR(50), dept_code __C__(4), hire_date __D__, tenured__E__, PRIMARY KEY(__F__) ); F

fac_id

Number

fac_id

CREATE TABLE __A__ ( fac_id __B__, last_name VARCHAR(50), first_name VARCHAR(50), dept_code __C__(4), hire_date __D__, tenured__E__, PRIMARY KEY(__F__) ); A

faculty

CREATE TABLE faculty ( fac_id INTEGER AUTO_INCREMENT, last_name VARCHAR(50), first_name VARCHAR(50), dept_code VARCHAR(4), hire_date DATE NOT NULL, PRIMARY KEY(fac_id) ); INSERT INTO __A__ (__B__) VALUES (__C__); What should A be replaced with? fac_id faculty table_name

faculty

"123" !== "123"

false

"123" === 123

false

"bat" < "ball"

false

2 > 10 || 1 > 2

false

The var_dump(variable)function outputs the data type of a variable. What is the output of the code below? $x = 1.23; var_dump($x); int(1.23) float(1.23) number(1.23)

float(1.23)

What is missing to set the seasons to 1 and genre to "fantasy" for shows released after 2010? UPDATE tv_show SET _____ WHERE YEAR(release_date) > 2010; genre = 'fantasy' AND seasons = 1 genre = fantasy, seasons = 1 genre = 'fantasy', seasons = 1

genre = 'fantasy', seasons = 1

What is syntactically wrong with the SELECT statement? SELECT last_name, grade FROM student RIGHT OUTER JOIN student ON grade.stu_id = student.stu_id; RIGHT OUTER should be LEFT OUTER. grade must be either the left table or the right table. The course_id column is missing from the SELECT clause.

grade must be either the left table or the right table.

What string does NOT match the regex /grea*t/? gret greaaat grat

grat

body { background: green; } @media only screen and (min-width: 600px) { body { background: blue; } } @media only screen and (min-width: 800px) { body { background: red; } } What is the body's background color on an iPhone 8 in portrait mode with a viewport width of 375px? green blue red

green

What CSS property names the sections used in the grid-template-areas value? grid-template-columns grid-name grid-area

grid-area

Date

hire_date

CREATE TABLE faculty ( fac_id INTEGER PRIMARY KEY, last_name VARCHAR(50), first_name VARCHAR(50), dept_code VARCHAR(4), hire_date DATE, tenured BOOLEAN ); What alteration to the CREATE TABLE statement prevents hire_date from having a NULL value? hire_date NOT NULL DATE, hire_date DATE NOT NULL,

hire_date DATE NOT NULL,

What string does NOT match the regex /w+hy/? why hy wwwwhy

Which statement generates a warning if util.php is not found? include "util.php"; require "util.php"; require "./util.php";

include "util.php";

$quiz = [ [ "question" => "Who is John Galt?", "answer" => "We are!", "points" => 5 ], [ "question" => "Who you gonna call?", "answer" => "Ghostbusters", "points" => 5 ], [ "question" => "What is the air speed velocity of an unladen swallow?", "answer" => "About 24 miles per hour", "points" => 10 ] ]; $quiz is an __________. indexed array of associative arrays associative array of associative arrays associative array of indexed arrays

indexed array of associative arrays

preg_match("/z(\w+)/", "zing zany zone", $matches); echo $matches[1]; zing ing ing zany zone

ing

Performance testing, Usability testing, Security testing, Functionality testing, Compatibility testing, interface testing Testing the interaction between the front-end and back-end and the interactions between the server-side programs and the database.

interface testing

asort($medals); sort($medals); krsort($medals); assort($medals); USA, Soviet Union, Japan, China

krsort($medals);

Character

last_name

last_name, first_name, dept_code, hire_date

$date1 = date_create("2015-10-12"); $date2 = date_create("2016-09-22"); if ($date1 > $date2) { echo "greater than"; } elseif ($date1 < $date2) { echo "less than"; } else { echo "same"; } greater than less than same

less than

What data-targetattribute value makes a button display a Modal? modal modal's ID modal's class name

modal's ID

What does a developer with username "manning" type to start the mysql tool? mysql -p manning mysql -u manning -p

mysql -u manning -p

What DSN value was omitted from the animation above? DSN prefix host port dbname

port

Very mn ds. Nt dry mn lvs

preg_replace("/[aeiou]/", "", $quote);

Every man dies. Not every man lives.

preg_replace("/\d+/", "one", $quote);

one one dies. one one one lives.

preg_replace("/\w+ /", "one ", $quote);

Every one dies. Not every one lives.

preg_replace("/man/", "one", $quote);

SELECT LOWER(best_move) FROM avatar WHERE avatar_id = 3;

psystrike

Enter the command to exit the mysql tool.

quit

body { background: green; } @media only screen and (min-width: 600px) { body { background: blue; } } @media only screen and (min-width: 800px) { body { background: red; } } What is the body's background color for a desktop browser that is 900px wide? green blue red

red

What is missing to set the release date to January 22, 2010 for shows that have 6 seasons? UPDATE tv_show SET _____ WHERE seasons = 6; release_date = '2010-01-22' release_date = 2010-01-22 release_date = 'Jan 1, 2010'

release_date = '2010-01-22'

Which statement terminates the script if util.php is not found in the current directory? include "./util.php"; require "util.php"; require "./util.php";

require "./util.php";

Show tables

retrieve

Complete the SQL command to display all the songs in the songs table. ____ * from songs;

select

Enter the command to display all the tables in the music database.

show tables;

What is missing to delete only Community? DELETE FROM tv_show WHERE _____; show_id = 555 title = Community season = 6

show_id = 555

asort($medals); sort($medals); krsort($medals); assort($medals); China, Japan, Soviet Union, USA

sort($medals);

Which media type targets users who are blind? all screen speech

speech

What CSS Bootstrap class makes the text red? text-primary text-danger text-success

text-danger

"123" == 123

true

("10" <=> "010") == 0

true

("bat" <=> "ball") > 0

true

2 > 10 || (3 % 2 != 2 && 5 > 0)

true

Alter table

update

Enter the command to select the music database.

use music;

Pass-by-_______ assigns a copy of an argument to the parameter.

value

What CSS Bootstrap class only affects an element's width? mb-0 w-50 table

w-50

In PHP, an empty string is treated like a 0 when used as a number. Assuming no student has an ID of 0, what is output if the user submits the form without typing an ID, name, and GPA? was successfully inserted. Couldn't insert because ID 0 already exists. An exception error message.

was successfully inserted.

preg_match("/(.+) (.+) (.+)/", "zing zany zone", $matches); echo $matches[2]; zany zone zing zany zone

zany

preg_match("/\w+y/", "zing zany zone", $matches); echo $matches[0]; zing zing zany zany

zany

How wide must the browser be to display A and B each occupying 50% of the row? <div class="row"> <div class="col-md-9 col-sm-6">A</div> <div class="col-md-3 col-sm-6">B</div> </div> < 576px ≥ 576px and < 768px ≥ 768px

≥ 576px and < 768px

Which team will win the SEC Championship? <label><input type="radio" name="team" value="Crimson Tide">University of Alabama</label> <label><input type="radio" name="team" value="Razorbacks">University of Arkansas</label> <label><input type="radio" name="team" value="Tigers">Auburn University</label> <label><input type="radio" name="team" value="Gators">University of Florida</label> <label><input type="radio" name="team" value="Volunteers">University of Tennessee</label> <label><input type="radio" name="team" value="Aggies">Texas A&M University</label> <label><input type="radio" name="team" value="Other">Other</label> Which expression evaluates to true if the user does not select any radio buttons?if (_______) { echo "No team selected"; } $_POST["team"] == "" isset($_POST["team"]) !isset($_POST["team"])

!isset($_POST["team"])

$quiz = [ [ "question" => "Who is John Galt?", "answer" => "We are!", "points" => 5 ], [ "question" => "Who you gonna call?", "answer" => "Ghostbusters", "points" => 5 ], [ "question" => "What is the air speed velocity of an unladen swallow?", "answer" => "About 24 miles per hour", "points" => 10 ] ]; What outputs the answer to the second question?$q = $quiz[1]; echo _______; "<h2>", $q[answer], "</h2>" "<h2>$q['answer']</h2>" "<h2>$q[answer]</h2>"

"<h2>$q[answer]</h2>"

$quote = "I am Spartacus!"; $x = str_replace("am", "was", $quote);

"I was Spartacus!"

$quote = "I am Spartacus!"; $x = "This is " . substr($quote, 5, 6) . "!";

"This is Sparta!"

Add Tim's grade to the $grades array. $grades = ["Beth" => "B", "Lance" => "C", "Jose" => "A"]; $grades[_____] = "D";

"Tim"

What argument is missing? $sql = "SELECT * from songs WHERE artist LIKE :artist"; $stmt = $pdo->prepare($sql); $stmt = $pdo->bindValue(_____, "Black%"); $stmt->execute();

"artist"

$quote = "I am Spartacus!"; $x = strpbrk($quote, "bcd");

"cus!"

What grid-template-areas value places the Members to the right of the Concerts and Contact section? "head head" "concerts members" "contact members" "members members" "concerts head" "contact head" "head head" "concerts contact" "members members"

"head head" "concerts members" "contact members"

$quote = "I am Spartacus!"; if (strcmp($quote, "I am TIRED!") < 0) { $x = "yes"; } else { $x = "no"; }

"yes"

Which variable is illegally named? $a1_ $null $2b_

$2b_

Which constant is illegally named? $A1_ _A1 TEST_23

$A1_

What condition makes the loop output even numbers 2 through 20?$c = 2; while (_____) { echo $c; $c += 2; } $c >= 20 $c <= 20 $c < 20

$c <= 20

What condition causes the for loop to output the numbers 100 down to 50, inclusively?for ($c = 100; ______; $c--) { echo $c; } $c < 50 $c > 50 $c >= 50

$c >= 50

Which code segment produces a notice error message? $count = 2; echo $COUNT; $count = 2; ECHO $count; Both code segments produce notice errors.

$count = 2; echo $COUNT;

If $item is "milk", what variables are incremented? $other $drinks only $drinks and $dairy

$drinks and $dairy

Output Jose's grade from the $grades array.$grades = ["Beth" => "B", "Lance" => "C", "Jose" => "A"]; echo ______;

$grades["Jose"]

If $item is "beef", what variables are incremented? $other $meat only $meat and $other

$meat only

Complete the foreach loop to output all the names and grades in the $grades array. $grades = ["Beth" => "B", "Lance" => "C", "Jose" => "A"]; foreach ($grades as __________) { echo "$name's grade is $grade.\n"; }

$name=>$grade

Complete the foreach loop to output each name. $names = ["Beth", "Lance", "Jose"]; foreach (_______ as $name) { echo "$name\n"; }

$names

Output "Jose" from the $namesarray. $names = ["Beth", "Lance", "Jose"]; echo _____;

$names[2]

If $item is "Apple", what variables are incremented? $other $fruits Nothing is incremented.

$other

Which statement produces a parse error? $owner = "Pam's"; $owner = 'Pam's'; $owner = 'Pam"s';

$owner = 'Pam's';

$quiz = [ [ "question" => "Who is John Galt?", "answer" => "We are!", "points" => 5 ], [ "question" => "Who you gonna call?", "answer" => "Ghostbusters", "points" => 5 ], [ "question" => "What is the air speed velocity of an unladen swallow?", "answer" => "About 24 miles per hour", "points" => 10 ] ]; What is missing to output the sum of the quiz points?$total = 0; foreach (__________) { $total += $q["points"]; } echo "Total points = $total"; $quiz as $q $q as $quiz $quiz

$quiz as $q

// Select students that have a GPA equal to or above 2.0 $sql = "SELECT stuid, name, gpa FROM students WHERE gpa >= 2.0"; // Issue the query $statement = $pdo->query($sql); // Loop through all the rows returned by the query foreach ($statement as $row) { echo "$row[stuid] - $row[name] has a $row[gpa] GPA<br>\n"; } Select the expression to complete the code below.$statement = $pdo->query("SELECT gpa FROM students"); foreach (_____ as $row) { echo "<p>$row[gpa]</p>"; } $statement $statement->fetch() $pdo

$statement

// Select students that have a GPA equal to or above 2.0 $sql = "SELECT stuid, name, gpa FROM students WHERE gpa >= 2.0"; // Issue the query $statement = $pdo->query($sql); // Loop through all the rows returned by the query foreach ($statement as $row) { echo "$row[stuid] - $row[name] has a $row[gpa] GPA<br>\n"; } Select the function call to complete the code below.$statement = $pdo->query("SELECT gpa FROM students"); while ($row = _____) { echo "<p>$row[gpa]</p>"; } $statement->query() $statement->fetch() $statement->fetchAll()

$statement->fetch()

Complete the code to create a reference parameter called $s.function insertDashes(____) { for ($i = 0; $i < strlen($s); $i++) { if ($s[$i] == " ") { $s[$i] = "-"; } } } $words = "Pass by reference"; dashes($words); echo $words; // Pass-by-reference

&$s

If the textarea below was added to the form in the animation above, what would be added to the query string when the form is submitted?<textarea name="comment">This is a gift</textarea> &comment=This is a gift &comment=This+is+a+gift

&comment=This+is+a+gift

'Wallace', 'William', 'HIST', '2017-07-10'

/\W\W\D/

()bison

Which media query is true for a viewport width 1000px width? (min-device-width: 500px) (max-width: 500px) (min-width: 500px)

(min-width: 500px)

What is output by the code below? function negateArray(&$x) { for ($i = 0; $i < count($x); $i++) { $x[$i] *= -1; } } $nums = [6, -7, 0]; negateArray($nums); echo $nums[0];

-6

What file extension does a PHP script have? .html .php .png

.php

What compound assignment operator makes $pointsbecome 2.5?$points = 5; $points ___ 2;

What regex matches the string "Regular Expression"? /Exp/ /exp/

/Exp/

What regex matches the string "sleep like a baby"? /^like/ /like$/ /^sleep/

/^sleep/

What regex matches the string "that's easy"? /b?eas$/ /b?sy$/ /e+sy$/

/b?sy$/

What regex matches the string "boom"? /ba?oom/ /b\?oom/ /bo?m/

/ba?oom/

What regex matches the string "breaeak"? /bre+a+k/ /br(ea)+k/ /er|bk/

/br(ea)+k/

What regex matches the string "PHP"? /php/ /php/i

/php/i

What regex matches the string "what?"? /what?$/ /what\?$/ /what$/

/what\?$/

$a = 2; if ($a == "2") { if ($a === "2") { $x = 1; } else { $x = 0; } }

$date1 = date_create("2015-10-12"); $date2 = date_create("2016-09-22"); $dateDiff = date_diff($date1, $date2); echo $dateDiff->y;

$x = 0; if ($x > 10) { $x = 1; }

$x = 30; if ($x < 0) { $x++; } elseif ($x < 10) { $x--; } else { $x = 0; }

What number outputs "#eurotravel" to the browser?preg_match_all("/#\w+/", $tweet, $matches); echo $matches[0][_____];

What value is $x?$x = preg_match("/regex/", "regular expression"); 1 0

count_nums(5,15);

Match only the digits 0 through 5. /[___]/

0-5

/\d\./

0.bison

"3" - "2too" + "sixty6" = ?

$x = sin(M_PI / 2); 0 0.5 1

What value is $x?$x = preg_match("/c\/1/", "abc/123"); 1 0

if ("history" < "math") { $x = 1; } else { $x = 0; }

What does the code below output? $nums = [6, -3, 10, 2]; echo find_max($nums); function find_max($nums) { $max = $nums[0]; foreach ($nums as $n) { if ($n > $max) { $max = $n; } } return $max; } 6 -3 10

What is output by the code below?function swapValues($x, $y) { $temp = $x; $x = $y; $y = $temp; } $a = 10; $b = 20; swapValues($a, $b); echo $a;

What are the first and last numbers output by the code segment?$c = 100; while ($c > 0) { echo $c; $c -= 10; } 100 and 0 90 and 0 100 and 10

100 and 10

If an image that is 50 x 50 logical pixels was modified for a 2 DPR display, how large is the new image? 50 x 50 25 x 25 100 x 100

100 x 100

<img src="dog-small.jpg" srcset="dog-medium.jpg 2x, dog-large.jpg 3x" alt="Dog"> A browser on a 3x screen downloaded dog-large.jpg, which was 300 x 225 pixels. What is the image size in logical pixels when displayed in the browser? 300 x 225 900 x 675 100 x 75

100 x 75

Which row contains correct values for a new Data Structures class? 1003, 52, 1, MWF 2pm, SCI 200 1004, COMP, 1, MWF 2pm, SCI 200 1004, 52, 1, MWF 2pm, SCI 200

1004, 52, 1, MWF 2pm, SCI 200

UPDATE shows SET genre= 'reality' WHERE seasons>6;

1054: Unknown column name

INSERT into shows VALUES (999, 'Stranger Things', 2 '2016-07-15');

1062: Duplicate entry for primary key

// Select students that have a GPA equal to or above 2.0 $sql = "SELECT stuid, name, gpa FROM students WHERE gpa >= 2.0"; // Issue the query $statement = $pdo->query($sql); // Loop through all the rows returned by the query foreach ($statement as $row) { echo "$row[stuid] - $row[name] has a $row[gpa] GPA<br>\n"; } In the animation above, the query() method throws a PDOException indicating the MySQL error 1146 occurred because the test.students table does not exist. What MySQL error does the SELECT statement below cause?$sql = "SELECT gpa IN students"; 1054 - Unknown column name 1064 - Parsing error, bad syntax 1336 - Bad value being inserted

1064 - Parsing error, bad syntax

UPDATE title='The Office' WHERE showld=999;

1064: Parsing error, bad syntax

$date1 = date_create("2015-10-12 10:00:30"); $date2 = date_create("2016-09-22 20:05:00"); $dateDiff = date_diff($date1, $date2); echo "$dateDiff->h:$dateDiff->i:$dateDiff->s"; 10:4:30 10:5:30 0:0:0

10:4:30

$points = 10; $points--; $points + 2 = ?

SELECT show_id FROM tv_show;

111 222 333

SELECT show_id, release_date, FROM tv_show;

111, 2005-03-27, 12 222, 2012-10-10, 6 333, 2009-04-09, 7

INSERT into shows VALUES (888, 'Stranger Things', 2);

1136: Number of values given in INSERT does not match number of columns

INSERT into showsTable VALUES (888, 'Stranger Things', 2, '2016-07-15');

1146: Table doesn't exist

SELECT seasons, title FROM tv_show;

12, Grey's Anatomy 6, Arrow 7, Parks and Recreation

3 + 5 * 2 = ?

5 + 3 ** 2 = ?

$x = round(12.6) + floor(3.7); 15 16 17

1, 'Miller', 'Susan', '2000-10-01', 3.1

1st

(3 + 4) % 5 = ?

The INSERT statement adds a student to the student table. How many clauses are in the INSERT statement? INSERT INTO student VALUES (888, 'Smith', 'Jim', 3.0); 1 2 3

What argument is missing? $sql = "SELECT * from songs WHERE title LIKE ? AND year > ?"; $stmt = $pdo->prepare($sql); $stmt = $pdo->bindParam(1, $title); $stmt = $pdo->bindParam(_____, $year); $stmt->execute();

What is $numMatches? $numMatches = preg_match_all("/@\w+/", $tweet, $matches);

count_nums(0,-2,3);

What numbers are output by the code segment?for ($x = 1; $x <= 3; $x++) { // outer loop for ($y = 2; $y <= 4; $y++) { // inner loop echo $y; } } 2, 3, 4 2, 3, 4, 2, 3, 4, 2, 3, 4 2, 3, 4, 5, 6, 7, 8, 9, 10

2, 3, 4, 2, 3, 4, 2, 3, 4

Billy 2.5 What is Billy's GPA? 3.1 2.5 4.0

2.5

What does the code below output? function special_nums() { return [3.142, 2.718, 1.618]; } list($pi, $euler, $phi) = special_nums(); echo $euler; 3.142 2.718 1.618

2.718

If a browser viewport is 400px wide and 300px high, how wide is an element with width:50vmax? 400px 100px 200px

200px

If a browser viewport is 400px wide, how wide is an element with width:50vw? 400px 200px 100px

200px

What dates are selected? SELECT release_date FROM tv_show WHERE title = 'Arrow'; No dates 2012-10-10 2012-10-10 and 2009-04-09

2012-10-10

date_format($date, "G:i")

20:04

$x = max(8, -10, 21, 4); -10 8 21

An image that is 50 x 50 logical pixels will use how many total device pixels on a 3 DPR display? 250 22,500 1,000

22,500

2, 'Lopez', 'Juan', '2001-12-11',2.8

2nd

$x = sqrt(9); 0 3 9

// Select students that have a GPA equal to or above 2.0 $sql = "SELECT stuid, name, gpa FROM students WHERE gpa >= 2.0"; // Issue the query $statement = $pdo->query($sql); // Loop through all the rows returned by the query foreach ($statement as $row) { echo "$row[stuid] - $row[name] has a $row[gpa] GPA<br>\n"; } If the students table contains 10 students and 7 students have a GPA less than 3.0, how many names does the foreach loop output?$sql = "SELECT name FROM students WHERE gpa >= 3.0"; $statement = $pdo->query($sql); foreach ($statement as $row) { echo "<p>$row[name]</p>"; } 10 7 3

Add the name "Stacy" to the end of the $names array. $names = ["Beth", "Lance", "Jose"]; $names[___] = "Stacy";

How many JavaScript files are necessary for some Bootstrap components to work? 1 3 4

count_nums("one", "two", "three");

If a browser viewport is 300px high, how wide is an element with width:10vh? 300px 30px 150px

30px

3, 'Rida', 'Adib', '1999-08-21', 3.7

3rd

How many rows would the students table have if a new student were added to the table? 2 3 4

count_nums(2,4,6,8);

"4e3" + 1 = ?

4001

4, 'Nguyen', 'Tye', '2001-05-02', 3.0

4th

$quiz = [ [ "question" => "Who is John Galt?", "answer" => "We are!", "points" => 5 ], [ "question" => "Who you gonna call?", "answer" => "Ghostbusters", "points" => 5 ], [ "question" => "What is the air speed velocity of an unladen swallow?", "answer" => "About 24 miles per hour", "points" => 10 ] ]; What is output by the code below?echo $quiz[0]["points"]; Who is John Galt? 5 10

What is the last number output by the loop?$c = 0; do { $c++; echo $c; } while ($c < 5);

/\d..\S/

5!?bison

What numbers are output by the code segment?for ($c = 5; $c < 10; $c += 2) { echo $c; } 5, 7, 9 5, 6, 7, 8, 9 Infinite loop

5, 7, 9

If a column uses the class col-lg-6, how much of the row does the column occupy when the browser is 1000px wide? 50% 60% 100%

50%

Which row contains correct values for a new history course? 51, HIST, Indian Culture, 3 53, COMP, Indian Culture, 3 53, HIST, Indian Culture, 3

53, HIST, Indian Culture, 3

How many columns does A span? <div class="row"> <div class="col-sm">A</div> <div class="col-sm">B</div> </div> 4 6 8

What breakpoint is used in the media query for detecting a tablet? 500px 600px 768px

600px

What is output?function addNumber($num) { global $sum; $sum += $num; } $sum = 0; addNumber(2); addNumber(5); echo $sum; 0 7

What is the grid's width if the browser is 800px wide? <div class="container"> <div class="row"> <div class="col-sm-10">A</div> <div class="col-sm-2">B</div> </div> </div> 576px 768px 800px

768px

What value is $points?$points = 2; $points *= 3 + 1;

echo "0 $x 0"; echo "9 \$x"; echo '9 $x0'; echo '9 ' . $x; echo '9\\'; echo "9{$x}0"; echo "9$x0"; 9 $x 0

9 $x 0 echo '9 $x 0';

date_format($date, "n/j/y")

9/12/14

/9\d+/

923 bison

What conditional operator makes the do-while loop output 10, 20, 30, ..., 100? $c = 10; do { echo $c; $c += 10; } while ($c ___ 100);

What output is produced by the PHP script?<h1>This is a test</h1> echo "This is only a test"; <h1>This is a test</h1> echo "This is only a test"; <h1>This is a test</h1> This is only a test This is only a test

<h1>This is a test</h1> echo "This is only a test";

What is missing from the parameterized SQL? $sql = "SELECT * from songs WHERE title = _____"; $stmt = $pdo->prepare($sql); $stmt = $pdo->bindValue(1, "Twist"); $stmt->execute();

What is output to the browser? preg_match_all("/@\w+/", $tweet, $matches); echo $matches[0][1];

@jan4prez

Which media query matches devices with a 320px width screen that are in landscape mode? @media screen and (device-width: 320px) and (orientation: landscape) { . . . } @media screen and (orientation: landscape) { . . . } @media screen and (device-width: 320px) { . . . }

@media screen and (device-width: 320px) and (orientation: landscape) { . . . }

What row must be added to the enroll table to give Tye a C in the class with course_id 52? 555, 1001, C 555, 1004, C

555, 1004, C

$quote = "I am Spartacus!"; $x = strpos($quote, "part");

The include statement inserts the contents of another file before the PHP script executes.

False

The University databases has three tables

True

department tabledept_codenameARTArt DepartmentCOMPComputer Science DepartmentENGEnglish DepartmentHISTHistory DepartmentMATHMath Department 888, 'Gomez', 'Victor', 'PHY', '1990-12-16', TRUE Valid Invalid

Invalid

Which books did you read this summer? <label><input type="checkbox" name="books[]" value="Miranda"> Hamilton: The Revolution</label> <label><input type="checkbox" name="books[]" value="Duckworth"> Grit: The Power of Passion and Perseverance</label> <label><input type="checkbox" name="books[]" value="Sunstein"> The World According to Star Wars</label> <label><input type="checkbox" name="books[]" value="Knight"> Shoe Dog: A Memoir by the Creator of Nike</label> Which expression evaluates to true if the user does not check any checkboxes?if (_______) { echo "No titles selected"; } count($_POST["books"]) == 0 !isset($_POST["books[]"]) !isset($_POST["books"])

!isset($_POST["books"])

If another row is added to the student table, another column must also be added.

False

Which loop always executes the loop body at least once? while do-while for

do-while

The regex /run/matches the string "pr uning".

False

The resulting join will always have the same number of rows as the student table

False

The row with values 123, 1004, C can be added to the enroll table.

False

The student table has a column for storing student addresses

False

A 2x image will look the same as an equivalent 1x image on a 1 DPR device.

True

A VPS generally runs slower than a dedicated host.

True

A small company may host the company's own website on the company's own web server

True

The web server detects mobile browsers by examining the User-Agent request header.

True

What CSS Bootstrap class only affects an element's margin? mb-0 width table

mb-0

/1\w+/

123bison

Insert

Create

Delete

PHP code runs in a web browser.

False

M_SQRT2

Square root of 2 (1.4142135623731)

Drop table

delete

$x = pow(2, 3); 6 8 9

LIKE BINARY '%A%'

Greys Anatomy and Arrow

Update

!(2 > 10 && 5 > 0)

true

Voir tous les ensembles d'études

Final-CS008 Textbook Questions

Ensembles d'études connexes

Chapter 11 Intermediate Accounting: Questions

Ch. 14 History Inquisitive

Таблица умножения на русском языке / Times Tables / English /

Unit 4 Avoiding hazardous Substances

NEC Chapter 5 Review questions

Intro to macro economics

Chapter 5&6 Biology 121 ULL

PSYC Revel Quiz 2.1-2.3 (Neurons and Nerves: Building the Network)

ECON 201 midterm

Community 11

Chap. 19

Patho Module 3: INFLAMMATION AND IMMUNITY

Motivation

Relias: Nursing Care of the Patient with Obstetric and Postpartum Hemorrhage Assessment

Diabetes #7

Early American Literature Final

Chapter 16 - Dysfunctional Labor

Documentation

Ch. 9 Test - Student t-Test

HTML