I am stuck with the followin question below. Please help!

Question

What is true about the <tt>mysql_*</tt> family of PHP functions?

a. Failing to eventually call <tt>mysql_close()</tt> will cause MySQL to deadlock when the connection is dropped.

b.They have been approved as advanced functions in PHP 5.5.0.1.

c.They are prone to heap corruption.

d. They are prone to allowing SQL-injection attacks.

What mechanism does MySQL provide to ensure that operations on the database can occur concurrently?

a. Transactions

b. Copy-on-Write Memory

c. MySQL is not thread-safe and cannot deal with concurrency.

d. Semaphores

How will the following CSS rule alter the web page if it is applied in a style sheet? h1 ( font-family: Arial, sans-serif}

a. All text in h1 elements will use a sans-serif font if Arial is not supported by the system

b. All text in h1 elements will have the Arial font, while text in other elements will use a sans-serif font.

c. All text in h1 elements will have use a sans-serif font, while text in other elements will use Arial.

d. All text in h1 elements will have the Arial font if sans-serif is not supported by the system

In which of the following do you set the MIME (Multipurpose Internet Mail Extensions) type of the external style sheet?

a. <mime><&

b. <a><&

c. <link><&

d. <style><&

Which of the following are true about PDO Data Source Names (DSNs)?

a.The URI "http://www.slashdot.org" is a DSN.

b. The username and password are usually a part of DSNs based off of URIs.

c. A DSN can be a URI.

d.A DSN is also known as a Hochwinkel von Traubenzucker short DNS name.

The hover pseudo-class allows you to change to an element’s style in which situation?

a.When the mouse moves off of the element

b.When the mouse is over the element

c.None of the options/answers

d.When the mouse is to the left of the element

Answer 1

What is true about the mysql_* family of PHP functions?

d. They are prone to allowing SQL-injection attacks.

The old mysql extension does not support prepared statements or parameterized queries, which are probably the simplest way to sanitize user input for database insertion. People commonly pass user input straight into database queries, which is a much bigger security risk without this functionality.

What mechanism does MySQL provide to ensure that operations on the database can occur concurrently?

a. Transactions

These are a way of bundling write operations together such that the database can execute them all as quickly as possible and if any one operation in the transaction fails, all operations that have already been processed in that transaction will be rolled back. This way you can be assured that either all operations were completed, or none were.

How will the following CSS rule alter the web page if it is applied in a style sheet? h1 { font-family: Arial, sans-serif}

a. All text in h1 elements will use a sans-serif font if Arial is not supported by the system

Font families are applied from left to right, stopping at the first one supported by the system.

In which of the following do you set the MIME (Multipurpose Internet Mail Extensions) type of the external style sheet?

c. <link>

The keyword in this question is "external". <mime> is not a valid HTML tag; <a> is generally used for clickable links; and <style> is used for inline stylesheets.

Which of the following are true about PDO Data Source Names (DSNs)?

c. A DSN can be a URI.

This one was a little confusing; I would have worded this choice as "A DSN is a type of URI." But none of the others are correct. See: https://www.php.net/manual/en/ref.pdo-mysql.connection.php

The hover pseudo-class allows you to change to an element’s style in which situation?

b.When the mouse is over the element