Test Midterm Spring 2003 Sample

Instructions: This is a closed book, notes, neighbor examination. Select the best answer. All output is to be considered what appears in the browser. DO write on the examination.

1. What language is the PHP application server coded in?
   1. Basic
   2. C
   3. Fortran
   4. Java
   5. None of the above


2. Define Coupling.
   1. Joining 2 strings together.
   2. The measure of how dependent two modules are.
   3. Adding numbers.
   4. Sharing a variable.
   5. None of the above


3. What will this print?
   <?php
   $bushApprovalRating = "17.5 percent";
   
   print ("Bush approval rating is: ");
   
   print (intval($bushApprovalRating));
   ?>
   1. Bush approval rating is: 17.5
   2. Bush approval rating is: 17
   3. Bush approval rating is: 17.5 percent
   4. 17
   5. None of the above


4. If I create a Web Application that uses MySQL, I can use the same code with any other database without having to change the functions I used to interact with the database.
   1. True as long as it is a relational database.
   2. This is true as long as I use the same operation system.
   3. False because my mom said so.
   4. False because the functions are specific to a database and the SQL varies slightly from a database to another.
   5. None of the above


5. Modules are organized into objects. The characteristics of these objects are made up of methods and properties. From a programming perspective what characteristic(s) do objects have.
   1. Functions
   2. Variables
   3. Arrays
   4. Both A & B
   5. None of the above


6. Which is the proper opening and closing tags for a PHP statement?
   1. <? ?>
   2. <?php ?>
   3. <% %>
   4. All of the above.
   5. None of the above


7. What Syntax mysql is correct
   1. SELECT *,* FROM name;
   2. SELECT ID,Summary,Date,Assignee,Submitter,Status,Priority,Kind FROM *;
   3. INSERT INTO issue (Date) VALUES(now());
   4. UPDATE issue VALUES Status=$Status;
   5. None of the above


8. Which of the following is not a valid PHP function for scripting using PHP Classes and Objects?
   1. get_class()
   2. get_object_vars()
   3. get_class_methods()
   4. is_subclass of()
   5. None of the above


9. Which of the PHP extension described in Chapter 13 for databases should you attempt to use if native support for your database doesn't exist?
   1. InterBase
   2. Postgres
   3. JDBC
   4. ODBC
   5. None of the above


10. What is a database abstraction layer?
    1. A way to make Oracle work smoother.
    2. A way to seperate the business logic when switching being different database languages.
    3. A graphics layer within the database.
    4. The name of a movie.
    5. None of the above


11. when you declare a class, you are really making a template for the creation of
    1. funtion
    2. module
    3. object
    4. variable
    5. None of the above


12. Which of the following statements is Not true?
    1. Objects can be used as an index of an array.
    2. Arrays can contain multiple data types.
    3. Multidimensional arrays are just arrays of arrays.
    4. Only strings and integers can be used to index an array.
    5. None of the above


13. Which is the proper syntax to register the variables "$Name" and "$Count" that you may wish to preserve across page requests?
    1. session_register($Name);
       session_register($Count);
    2. session_($Name);
       session_($Count);
    3. register_session($Name);
       register_session($Count);
    4. session_register("Name");
       session_register("Count");
    5. None of the above


14. which statement will stop all execution?
    1. return
    2. halt
    3. exit
    4. kill
    5. None of the above


15. What is the value of $var after the following code is executed?
    
    <?php
$var = "Hello World";
$var += 5;
$var++;
?>
    1. 5
    2. 6
    3. "Hello World"
    4. "Hello World6"
    5. None of the above


16. Which of the following functions returns an array?
    1. mysql_fetch_array
    2. mysql_fetch_field
    3. mysql_fetch_row
    4. mysql_fetch_object
    1. 1
    2. 1 and 3
    3. 1 and 2
    4. 1, 2 and 3
    5. None of the above


17. What does this code output?
    <?php
for($index = 2; $index <= 6; $index++) {
    print($index - 1);
    print(" ");
}
?>
    1. 23456
    2. 1 2 3 4 5
    3. 2-1 3-1 4-1 5-1 6-1
    4. 2 3 4 5
    5. None of the above


18. What does this code output?
    <?php
    $myArray = array(1,2,3,"one","two","three", one => 4, two => 5, three => 6);
    print("{$myArray[$myArray[one]]}");
?>
    1. one
    2. 1
    3. two
    4. four
    5. None of the above


19. The process of a function calling itself is
    1. recursion
    2. argument
    3. dynamic call
    4. return statement
    5. None of the above


20. The following code will produce which of the results below?
    
    <?php

$alpha = array(2, "PHP", 5, 7, 11);
$beta = array("one" => 1, "two" => 2, "three" => "is");
$gamma = array("bob" => "Rules!", 5 => "six", "great!");

print($alpha[1]." ".$beta["three"]." ".$gamma[6]);

?>
    1. 11 > 6
    2. PHP is great!
    3. 2 2 six
    4. PHP Rules!
    5. None of the above


21. What is the difference between:
    1. function double_it( &$x )
    and
    2. function double_it( $x )
    1. &$x means the value is passed by reference and $x means the value is passed as an copy
    2. &$x means the value is passed by value and $x means the value is passed as an reference
    3. &$x is not alowed in php. $x is the only possible syntax
    4. $x is not alowed in php. &$x is the only possible syntax
    5. None of the above


22. What will the following code output?
    <?php
        $i = 0;
        do {
            print("$i\n");
            $i++;
            $i = ($i > 5) ? 10: $i;
        } while ($i < 7)
    ?>
    1. 0 1 2 3 4 5
    2. 0 1 2 3 4 5 6 8 9 10
    3. 0 1 2 3 4 5 6 7
    4. 0 1 2 3 4 5 10
    5. None of the above


23. Which of the following is not a PHP mysql function that returns data rows each in data structure that is either an array or an object.
    1. mysql_fetch_array()
    2. mysql_fetch_assoc()
    3. mysql_fetch_object()
    4. mysql_fetch_row()
    5. None of the above


24. What is the most popular database used by PHP coders?
    1. InterBase
    2. MySQL
    3. Oracle
    4. mSQL
    5. None of the above


25. What is the way to comment a block of code lines?
    1. /* comment
       comment
       */
    2. // comment
       comment
       //
    3. # comment
       comment
       #
    4. ' comment
       comment
       '
    5. None of the above


26. How does the PHP language specify the end of a statement?
    1. :
    2. \n
    3. ;
    4. no character. hitting return is sufficient.
    5. None of the above


27. How many databases does PHP Support?
    1. 1
    2. 2
    3. 3
    4. many
    5. None of the above


28. No every web site needs to store every piece of content in a database. Which of the below scenarios would most likely NOT require a database?
    1. Bulletin Board System (BBS) where messages are posted and a message can be related to zero or more other messages.
    2. Product catalog that contains textual product descriptions and images that correspond to each description.
    3. A searchable on-line PHP code repository where user can submit PHP code snippets.
    4. Web-based e-mail. E-mails are stored on a mail server. The web page/PHP code must list, retrieve, compose, and send e-mails specified by the user.
    5. None of the above


29. Where must functions be declared?
    1. Above the call to it.
    2. Below the call to it.
    3. Anywhere.
    4. In an included file.
    5. None of the above


30. Where is session data stored?
    1. On the client computer.
    2. On the server.
    3. In a cookie.
    4. It is serialized in the Session ID (SID)
    5. None of the above


31. Which of the following PHP statements will print "Hello, world."?
    
    1. <?php
    print("<H3>Hello, world.</h3>\n");
?>
    2. <?php
    PRINT("<H3>Hello, world.</h3>\n");
?>
    3. <?php
    PrInT("<H3>Hello, world.</h3>\n");
?>
    4. All of the above.
    5. None of the above


32. Which of the following regular expressions is best for US zip code validation?
    1. ^([0-9]{5})(-[0-9]{4})?$
    2. ^([0-9]{5})(-[0-9]{4})$
    3. ^([1-9]{5})(-[0-9]{4})?$
    4. ([0-9]{5})(-[0-9]{4})?
    5. None of the above


33. Which of the following statement about arrays is right?
    1. You do not have to declare anything about the array before you use it.
    2. Arrays can only be indexed by integers.
    3. If you refer to an array element that does not exist, it will evalute to be zero.
    4. All of the above
    5. None of the above


34. Using the 'global' statement...
    1. brings a variable into a function's name space, and any changes made to the variable within the function will NOT persist outside of the function. This is just a way to get a variable inside a function without having to pass it as an argument.
    2. brings a variable into a function's name space, and any changes made to the variable within the function will persist outside of the function.
    3. is poor programming practice and should always be avoided.
    4. prevents a variable from being changed. It is like declaring it a constant.
    5. None of the above


35. Which of the following is not an operator?
    1. --
    2. ++
    3. /
    4. $
    5. None of the above


36. Casting an array as an object...
    1. is not legal in PHP.
    2. is not necessary. Arrays are objects.
    3. has the effect that the elements of the array can be accessed as properties of an object.
    4. should be avoided because information can be lost upon recasting the the object as an array.
    5. None of the above


37. Given the following lines of script:
    $numArray = array(2,4,8,1);
foreach($numArray as $numVal) {
    numVal%2==0 ? ++$numVal : $numVal;
}
    What will the values in $numArray be at the end of the foreach loop? (starting with index 0)
    1. 2, 4, 8, 1
    2. 3, 5, 9, 1
    3. 1, 9, 5, 3
    4. 2, 4, 8, 2
    5. None of the above


38. What does the PHP keyword "extend" mean.
    1. Changes the scope of a variable.
    2. Formats a variable.
    3. Allows a class to inherit properties of other classes.
    4. It changes the length of time a PHP program can run without timing out.
    5. None of the above


39. What will thi scode output?
    <?php
    $Contact = "Jack"
    switch($Contact) {
        case "Sara":
            print $Contact . "'s phone number is 555-1234";
            break;
        case "Tim":
            print $Contact . "'s phone number is 555-9999";
            break;
        case "Fred":
            print $Contact . "'s phone number is 555-1244";
            break;
        default:
            print "Sorry, I don't know $Contact";
    }
?>
    1. Sara's phone number is 555-1234
    2. Tim's phone number is 555-9999
    3. Fred's phone number is 555-1244
    4. Sorry, I don't know Jack
    5. None of the above


40. How can you have a function remember the value of variable between calls if this variable should remain local for this function?
    1. By declaring this variable as Global
    2. By declaring this variable as Static
    3. By declaring this variable as Local
    4. By declaring this variable as Private
    5. None of the above


41. Which function is used to fetch all arguments sent to the function as array?
    1. func_get_args
    2. func_num_args
    3. func_get_arg
    4. func_num_arg
    5. None of the above


42. What happens with session identifier if user rejects cookies?
    1. The session identifier will be stored on the user's disk;
    2. The session identifier will be stored on the server;
    3. The session identifier will not be created;
    4. The session identifier will be sent in URL
    5. None of the above


43. Session ID numbers are randomly generated by the system's web server and can be stored by an application in a database. The session ID number sould not be used as a primary identifier because ____
    1. It is valid only for the current session.
    2. It is lost when the client machine is powered off.
    3. Non-embedded DBs can not reliably store and dynamically access generated numbers.
    4. On restarting a httpd, a nonunique randomly generated session ID number may be generated.
    5. None of the above


44. The continue statement is used inside of a loop to:
    1. continue to execute the statement even if an error occurs
    2. exit the loop and continue to execute the next code segments.
    3. stop execution within the loop at that point , and return to begin executing code at the beginning of the loop.
    4. In a for loop the continue statement increments the counter and continues executing code.
    5. None of the above


45. What will you get if you cast Array as string?
    1. empty string
    2. string containing all array elements
    3. word Array
    4. NULL
    5. None of the above


46. An alternative to using cookies to pass the session ID among different pages is:
    1. to declare the session ID variable as global so that it can be seen be all your pages.
    2. to store the session ID variable in your mySQL database so that it can always be accessed from any page.
    3. to pass the session ID through links or forms.
    4. there is no alternative. If cookies are not enabled then there is no way to track information about a user.
    5. None of the above


47. Which of the following statements are true?
    1. Functions are useful for encapsulating frequently used code. A library of functions can be kept in one or more 'include' files.
    2. It is easier to update a function used in many places than to modify similiar code in many places.
    3. A function delcared within a conditional statement is available only after successful execution of the code block which contains the function declaration.
    4. All of the above
    5. None of the above


48. If a variable in a function has the global operater preceeding
    
    it, which is the following is true.
    1. It has local scope to the function.
    2. It can modify a variable outside the function.
    3. It does nothing to a variable outside the function.
    4. The global operator is not valid within a function.
    5. None of the above


49. What does this code output?
    <?php
    $a = 5;
    $a += ++$a + $a++;
    print $a;
?>
    1. 16
    2. 18
    3. 19
    4. 17
    5. None of the above


50. To prevent endless loops and long running requests, by default, scripts are limited to how many seconds?
    1. 30
    2. 60
    3. 90
    4. unlimited , unless changed in the php.ini file
    5. None of the above


51. Where do you define the return type of a function?
    1. just before the function name
    2. before the return keyword
    3. The type is not defined because variable can hold any strings
    4. The type is not defined because variable can hold any type
    5. None of the above


52. Use dba_firstkey function returns the first key in the database. If the database is Empty. ------ will be returned.
    1. 0
    2. null
    3. False
    4. Error message
    5. None of the above


53. which of the followings is the output of the following php snippet?
    <?php
    $count = 5;
    $count *= 2;
    echo $count;
    $count += 1;
    echo ' ', $count;
?>
    1. 10 11
    2. 52
    3. 5 8
    4. 2 1
    5. None of the above


54. When creating an object, what is the statment that should be in place of <statement> in the line below?
    $myObject = <statement> anObject("abc", "123");
    1. new
    2. object
    3. create
    4. No statement is required.
    5. None of the above


55. Which of the following correctly defines a class with a constructor that takes a name and copies it's value to the class's name variable?
    1. class user {
    var $name;
    function user($name) { $name = $name; }
}
    2. class user {
    var $name;
    function user($name) { $name = $this->name; }
}
    3. class user {
    var $name;
    function user($name) { $this->name = $name; }
}
    4. class user {
    $name;
    function user($name) { $this = $name; }
}
    5. None of the above


56. When placing <?php print(date("1 F d, Y:)); ?> in a web page where will the code get the date from.
    1. From a time clock at the National Institute of Standards and Technology (NIST).
    2. Your time from the computer your browsing the web from.
    3. From your Internet Service Provider.
    4. The server in which the web page is stored on.
    5. None of the above


57. What is a recursion?
    1. This is when a function calls itself.
    2. The process of a function calling another function.
    3. The process of a function calling a class.
    4. The process that takes place when a function is called.
    5. None of the above


58. What is a recursion?
    1. This is when a function calls itself.
    2. The process of a function calling another function.
    3. The process of a function calling a class.
    4. The process that takes place when a function is called.
    5. None of the above


59. SQL statements and PHP functions are different for each type of database PHP connects to. MySQL vs. Oracle vs. Postgres vs. mSQL and so on. There are tradeoffs in performance when an interpreter attempts allow multi-database independence.
    What is the term for a database-independent interpeter?
    1. ODBC
    2. Database Abstraction Layer
    3. Persistence Layer
    4. 4GL
    5. None of the above


60. The following FOR statement is executed how many times?
    for(i = 0; i = 10; i++) {
    i++;
}
    1. Ten times
    2. Five times
    3. Once
    4. Infinite times
    5. None of the above


61. What does this code output?
    <?php
    $var_name="myGPA";
    $myGPA=3.65;
    print("$$var_name<br>\n");
?>
    1. $myGPA
    2. 3.65
    3. myGPA
    4. $var_name
    5. None of the above


62. What will this code output to the browser?
    <?php
    $Town[] = "Sonoma";
    $Town[] = "Santa Rosa";
    $Town[] = "San Francisco";
    print "I live in $Town[2] and sometimes $Town[0].";
?>
    1. I live in Santa Rosa and sometimes Sonoma.
    2. Nothing, the syntax is incorrect.
    3. I live in San Fransisco and sometimes Sonoma.
    4. Sonoma, Santa Rosa, San Francisco
    5. None of the above


63. How does a comment begins and ends in PHP?
    1. /* and */
    2. /? and ?/
    3. <" and ">
    4. /& and &/
    5. None of the above


64. Modules are organized into objects. The characteristics of these objects are made up of methods and properties. From a programming perspective what characteristic(s) do objects have.
    1. Functions
    2. Variables
    3. Arrays
    4. Both A & B
    5. None of the above


65. The database function mysql_pconnect is the recommended method for connecting to mysql databases. What does the pconnect clause in the function name signify?
    1. Primary conncection
    2. Principle connection
    3. Persistent connection
    4. Posix connection
    5. None of the above


66. Which of the following will not send text to the browser
    1. echo
    2. print
    3. printf
    4. printl
    5. None of the above


67. What will the function mysql_pconnect("localhost", "test", "") return if it's failed?
    1. Empty string: ""
    2. -1
    3. FALSE
    4. NULL
    5. None of the above


68. In PHP how do you determine if a variable has global scope?
    1. Any variables created outside a function.
    2. Any variables preceeded by the static keyword.
    3. Any variables within a function preceeded by the global
       keyword.
    4. All variables.
    5. None of the above


69. What does ^[^a-z]*[0-9]$ match?
    1. A0, A1... Z9, but not a0,a1 ... z9, 0,..9
    2. a0, a1... z9, A0,..., Z9 but not 0 ... 9
    3. A0,..., Z9, 0,..., 9 but not a0,...z9
    4. a0, a1... z9, 0,..., 9 but not A0 ... A9
    5. None of the above


70. What will this code output?
    <?php
    $alpha = array(" things ","can ","multi-");
    $beta = array("do with ","single","we ");
    $gamma = array("<BR />","separate","dimensional ");
    $delta = array("When ","What","arrays!","clarity");
    $epsilon = array(&$alpha, &$beta);
    $zeta = array(&$gamma, " convoluted", &$delta);
    $eta = array(&$epsilon, &$zeta);

    print $eta[1][2][1];
    print $eta[1][1];
    print $eta[0][0][0];
    print $eta[1][0][0];
    print $eta[0][1][2];
    print $eta[0][0][1];
    print $eta[0][1][0];
    print $eta[1][0][0];
    print $eta[0][0][2];
    print $eta[1][0][2];
    print $eta[1][2][2];
?>
    1. What convoluted things
    2. we can do with
    3. multi-dimensional arrays!
    4. All of the above
    5. None of the above


71. Which one of these uses a valid data assignment operator in PHP?
    1. $today == "Friday";
    2. $today := "Friday";
    3. $today = "Friday";
    4. $today <== "Friday";
    5. None of the above


72. In PHP script if you put words where the script expects numbers. What values PHP script assing thoes words?
    1. None
    2. Ignore
    3. Take it as a white space
    4. Zero
    5. None of the above


73. What is the difference between the break and continue statements?
    1. The break statment will stop a loop and jump outside of it, continue will stop the current execution of the loop and jump to the closing curly brace of that loop.
    2. The break statement will halt execution of the entire script, continue will halt the execution of the script but allow a message to be displayed.
    3. The continue statment will stop a loop and jump outside of it, break will stop the current execution of the loop and jump to the closing curly brace of that loop.
    4. The continue statement will halt execution of the entire script, break will halt the execution of the script but allow a message to be displayed.
    5. None of the above


74. In The following code, what is the first value of $numCount and the last value of $numCount printed to the Browser window?
    
    <?php
    $numCount = 1;
    print $numCount++ . "<br />\n";
    ++$numCount;
    print $numCount . "<br />\n";
    $numCount++;
    print $numCount . "<br />\n";
    ?>
    </body>
    </html>
    1. 1
       2
    2. 1
       3
    3. 2
       3
    4. 1
       4
    5. None of the above


75. What will this code output?
    <?php
    $val = 0;
    for($counter = 1; $counter <= 10; $counter++) {
        if($counter%2 == 0) $counter += 2;
        if($counter%2 == 1) $counter += 1;
        $val++;
    }
    print($val);
?>
    1. 10
    2. 5
    3. 9
    4. 6
    5. None of the above


76. What would the browser most likley display from the fallowing code if you entered your name as steve on the previouse form?
    <html>
    <title> Test Question </title> <body>
    Welcome to my test question
    <?PHP
    echo $name
    ?>
    , I hope your get it right.
    
    </html>
    1. Welcome to my test question name, I hope your get it right.
    2. Welcome to my test question $name, I hope your get it right.
    3. Welcome to my test question steve, I hope your get it right.
    4. Welcome to my test question <?PHP $name ?>, I hope your get it right.
    5. None of the above


77. What purpose does the constructor of a parent class serve from the child class?
    1. The parent constructor is inherited by the child class and overrides the child's constructor.
    2. The parent constructor is inherited along with, and is no different from, the other parent methods.
    3. The parent constructor is not inherited by the child class.
    4. The parent constructor is inherited by the child class and it is up to the programmer to specify which constructor is used.
    5. None of the above


78. Which of the interpretations is correct about the following PHP statement:
    $userInfo = new reccord("Ana", "41");
    1. This is how to create an instance of the class "userInfo".
    2. This instanciates an object of the class reccord and specifies initial values for some of the class variables.
    3. This statement ensures that each instance of the class being referred to only has two variables.
    4. This statement adds to new values to the array $userInfo.
    5. None of the above


79. When using the EXTENDS keyword to create one class based on a parent class, what is the effect on a parent class's constructor if the child class also has a constructor?
    1. There is no effect.
    2. The parent class's constructor takes precedence.
    3. The child class's constructor takes precedence.
    4. The child class's constructor takes precedence, but it is possible to specifically refer to and execute the parent class's constructor as well.
    5. None of the above


80. What will this code output?
    <?php
    $tomorrow=100;
    $anotherDay=200;
    if($tomorrow = $anotherDay) {
        print("Tomorrow is another day.");
    } else {
        print("Not Now, Not Never");
    }
?>
    1. Tomorrow is another day.
    2. Not Now, Not Never
    3. 300
    4. It's a beautiful day.
    5. None of the above


81. In chapter 5 we learned there is various types arrays, to collect values into lists. Which of the arrays listed below is NOT a valid array type for collecting values?
    1. Indexing Arrays
    2. Multidimensional Arrays
    3. Casting Arrays
    4. Functional Arrays
    5. None of the above


82. When performing an operation on two numbers, one of type integer, and the other of type double...
    1. the integer is first converted to a double and the operation is performed.
    2. the double is first converted to an integer and the operation is then performed.
    3. both numbers are first converted to strings and the operation is then performed.
    4. no conversion takes place. The operation is performed as is.
    5. None of the above


83. When dealing with a submitted form...
    1. PHP creates variables from each of the form fields. These variables can be treated just like any variable in PHP.
    2. PHP creates constant variables from each of the form fields. These variables cannot be changed in PHP.
    3. the programmer must parse the form in order to get at the form fields, which can then be set to variables by the programmer.
    4. the programmer must call the PHP function get_form_vars to access the form fields.
    5. None of the above


84. What will the code do?
    <?php
    phpinfo();
?>
    
    1. Displays user information.
    2. It will get user information from a form.
    3. Displays the php configuration information on the server.
    4. The code will eat your computer and ruin your motivation.
    5. None of the above


85. What is the output of the following code?
    <?php
    $var1 = 1;
    print(++$var1);
    print($var1++);
    print(--$var1);
?>
    1. 222
    2. 233
    3. 122
    4. 223
    5. None of the above


86. Which of the interpretations is correct about the following PHP statement:
    
$userInfo = new reccord("Ana", "41");

    1. This is how to create an instance of the class "userInfo".
    2. This instanciates an object of the class reccord and specifies initial values for some of the class variables.
    3. This statement ensures that each instance of the class being referred to only has two variables.
    4. This statement adds to new values to the array $userInfo.
    5. None of the above


87. What is alternative to if - elseif - else structure?
    1. select (root-epression) {
    case case-expression:
    default:
}
    2. switch (root-epression) {
    case case-expression:
    else:
}
    3. switch (root-epression) {
    case case-expression:
    default:
}
    4. select (root-epression) {
    case case-expression:
    else:
}
    5. None of the above


88. Which of the following is the correct answer about marking PHP code in a web page?
    1. <?
       ?>
    2. <SCRIPT LANGUAGE="PHP">
       </SCRIPT>
    3. <%
       %>
    4. All of the above
    5. None of the above


89. What is the benefit of a class over an array?
    1. You can include .exe files in a class.
    2. You can include functions in classes along with arrays.
    3. You can color them with sticky marshmallow code.
    4. There is no benefit, an array is move versatile.
    5. None of the above


90. When doing a file upload via an HTML form; you must set the 'type' attribute of the 'input' tag to:
    1. text
    2. image
    3. file
    4. either B or C
    5. None of the above