I need help with these questions!! 15. Which of the following does MySQL NOT support?

I need help with these questions!! 

15. Which of the following does MySQL NOT support?

a. Blobs (storing binary large objects in the database)

b. Varchars (saving variable length character arrays in the database)

c. Embedded PHP (running PHP inside the database)

d. Auto-incremented columns

16. Which of the following is a valid reason to use PHP instead of other server-side languages (such

as Java, C#, or JS)?

a. PHP has far better performance than any of these other languages

b. PHP has far higher security than any of these other languages

c. These other languages are deprecated for web server use and unlikely to be supported

at some point in the future

d. Many hosts (especially those that are free) support PHP, but some do not support these

other languages

17. US phone numbers have ten digits, with a hyphen after the third and sixth digits. Which of the following regular expressions is most appropriate for validating US phone number strings?

a. “[0-9]*-[0-9]*-[0-9]*”

b. “^[0-9]*-[0-9]*-[0-9]*$”

c. “[0-9]{3}-[0-9]{3}-[0-9]{4}”

d. “^[0-9]{3}-[0-9]{3}-[0-9]{4}$”

18. Which of the following is a good situation for using server-to-server http connections in PHP?

a. Maybe you want to retrieve RSS from a server on another domain

b. Maybe you want to retrieve data from your own database and convert it to JSON

c. Maybe you need to retrieve the list of posts from a Facebook page via an <IFRAME> tag

d. Maybe you need to retrieve a map from Google’s API via a <script> tag

19. Which of these is a situation when you’d use an associative array, rather than an alternative?

a. If you need to sort a list in PHP, then you’d use an associative array because there is no

way to sort a regular array (i.e., a linear array indexed from 0)

b. If you want to store and look up information in JS memory, based on some key that is a

string (like “betty”), then you’d use an associative array instead of a linear array

c. If you want to guarantee that certain data values are secure, then you would store them

in a JavaScript associative array instead of a database

d. If you want to improve the usability of your web site by reducing responsiveness, then

you would store data in an associative array on the server, instead of in the database

20. What is the purpose of using nameless (anonymous) functions in JavaScript?

a. To make it less likely that closure will occur

b. To avoid polluting the namespace

c. To improve the performance of functions

d. To make the web page more usable

e. To reduce the amount of traffic to the database

21. What is the purpose of htmlspecialchars in PHP?

a. To prevent unintended characters from leaking into your SQL queries

b. To reduce the risk of unintended characters from leaking into your HTML stream

c. To avoid polluting the namespace

d. To improve the performance of functions

e. To improve the usability of your web page

22. Two web pages X and Y are nearly identical. Both of them retrieve a list of puppies from a

database and output that list to the web. But page X outputs this list as JSON, and page Y outputs the list as HTML. Which of these statements is true?

a. Page X is more likely than page Y to contain a security hole, due to the possibility that

the puppy names contain unintended <script> tags in the JSON stream

b. Page Y is more likely than page X to contain a security hole, due to the possibility that the puppy names contain unintended <script> tags in the HTML stream

c. Page X is probably only accessible via a POST operation, but page Y probably can be

accessed via GET or POST

d. Page Y is probably only accessible via a POST operation, but page X probably can be

accessed via GET or POST

23. Which of these is an important difference between JSON and XML?

a. JSON can contain JS functions, but XML cannot

b. JSON is susceptible to important security risks, and XML is not

c. JSON is usually more concise and therefore offers better performance than XML

d. JSON is older than XML and therefore is compatible with more legacy systems

24. Suppose you create a web page that can send emails. Which of these is a good way to prevent

spammers from hijacking your web page?

a. Transmit the receiver (“to”) and email body to the server using JSON (via AJAX)

b. Transmit the receiver (“to”) and email body to the server via a GET request

c. Transmit the receiver (“to”) and email body to the server in XML format

d. Write your server code in such a way that it accepts any “to” address

e. Write your server code in such a way that it hardcodes the email body f. Write your server code in such a way that it hardcodes the “from” address

25. What is the single origin policy in JavaScript?

a. A script can only be used (referenced) by single web page

b. A script can only load data from the same web site that it was loaded from

c. A script can only access its own web page once; it cannot access its page twice or more

d. A script can only access its own web page; it cannot ask the server for more data

26. What effect, if any, would the single origin policy have on your PHP’s ability to send emails?

a. Your PHP may only send emails to users on the same domain as the website

b. Your PHP may send emails to any users, but it may not send text messages

c. Your PHP may only make server-to-server connections to servers on the same domain

d. The single origin policy only affects JavaScript, and it has no effect on PHP at all

27. Suppose that you have a PHP that sends out some emails, and you want your PHP to save a copy of every email in your database before it sends out that email. Which of the following is most likely to be true?

a. Your database will probably have at least one blob (or clob) column

b. Your database will definitely have at least one auto-increment column

c. Your PHP code definitely does not use any prepared statements

d. Your PHP code will probably need to send a regular expression to the database

28. What is the difference between cookies and sessions?

a. Sessions are little pieces of data that flow back and forth between the client and server;

cookies only exist on the client side

b. Sessions are little pieces of data that flow back and forth between the client and server;

cookies only exist on the server side

c. Cookies are little pieces of data that flow back and forth between the client and server;

sessions only exist on the client side

d. Cookies are little pieces of data that flow back and forth between the client and server;

sessions only exist on the server side

29. What is the relationship between cookies and sessions?

a. Cookies are internally used by the web site to support sessions

b. Sessions are internally used by the web site to support cookies

c. Cookies are the means by which the server links sessions with CSS

d. Sessions are the means by which the client links cookies with CSS

30. In AJAX with jQuery, which would you use to send a non-idempotent request?

a. Invoke $.ajax and specify that the type is GET

b. Invoke $.ajax and specify that the type is a content type (such as text/html)

c. Invoke $.ajax and specify that the type is POST

d. Invoke $.ajax and specify that the content is not a file upload

e. Invoke $.ajax and specify that the type is null