Web Data Management

45 Questions

Settings
Please wait...
Data Management Quizzes & Trivia

Chapters 1-3


Questions and Answers
  • 1. 
    1. In a web application, the client uses a ___ to interact with a web server.
  • 2. 
    A __ makes web sites available to other computers over a network.
  • 3. 
    A web application starts when a client sends a/an __ to a server.
  • 4. 
    A __ web page is one that has .html or .htm as its extension.
  • 5. 
  • 6. 
    Firefox is a __.
  • 7. 
    __ is the web server that is commonly used for web applications that are written in PHP.
  • 8. 
    8. To deploy a PHP application on your own server, you copy or move its __ to    the document root directory of the Apache server.
  • 9. 
    9. In an HTTP URL, the __ is coded immediately after the protocol but before the    path.
  • 10. 
    10. If you omit the filename from a URL, the Apache web server displays a list of files and    directories if the specified directory doesn’t contain a __ such as index.php.
  • 11. 
    11. A web application is a type of
    • A. 

      Client/server application

    • B. 

      Client-side application

    • C. 

      Database application

    • D. 

      Server-side application

  • 12. 
    12. When the web server recieves an HTTP request for a PHP page, the web server calls the
    • A. 

      Database server

    • B. 

      Static web page

    • C. 

      Web browser

    • D. 

      PHP interpreter

  • 13. 
    The HTTP response for a dynamic web page is passed
    • A. 

      From PHP to the browser

    • B. 

      From the web server to the browser

    • C. 

      From the database server to the web server

    • D. 

      From the web server to PHP

  • 14. 
    14. Which of the following software components generates the HTML that is returned in an HTTP    response?
    • A. 

      Apache

    • B. 

      MySQL

    • C. 

      Firefox

    • D. 

      PHP

  • 15. 
    15. To deploy a PHP application on your own computer, you copy the application root directory to
    • A. 

      The htdocs directory of the Apache server

    • B. 

      The htdocs directory of the MySQL server

    • C. 

      The xampp directory of the Apache server

    • D. 

      The xampp directory of the MySQL server

  • 16. 
    1. To embed PHP within a file, you start a tag with __, you code the embedded PHP    statements, and you end the tag with ?>.
  • 17. 
    The __ in a block of PHP code are ignored.
  • 18. 
    The __ data type is used to store a true or false value.
  • 19. 
    The variables in PHP are easy to spot because they always start with __.
  • 20. 
    5. A variable name in PHP can only contain letters, numbers, and __.
  • 21. 
    In a simple assignment statement, you code the variable name followed by the __   operator.
  • 22. 
    7. To get the data that is submitted with an HTTP GET request, you use PHP to get the data from    the built-in __ array.
  • 23. 
    To use PHP to send data to the browser, you use the __ statement.
  • 24. 
    9. In an arithmetic expression, division is done before multiplication, but you can override that by    using __.
  • 25. 
    10. When you call a function like the number_format function that returns a value, you usually    __ the result of the function to a variable.
  • 26. 
    11. In a conditional expression that includes logical operators, the AND operator has a lower order of    precedence than the __ operator.
  • 27. 
    12. In an if statement, the statements in the else clause are executed if none of the conditions in the if    or __ clauses are true.
  • 28. 
    13. The condition for a while loop is tested __ the statements in the loop are executed.
  • 29. 
    What will the variable $name contain after the code that follows is executed?   $first_name = 'Bob'; $last_name = 'Roberts'; $name = "Name: $first_name";
  • 30. 
    15. What value will the variable $net_price contain after the code that follows is executed?__   $list_price = 100.00; $discount_percent = 20; $discount_amount = $list_price * $discount_percent * .01; $net_price = $list_price - $discount_amount;
  • 31. 
    A table in a relational database consists of columns and
  • 32. 
    The ______________________ key of a table uniquely identifies each record in the table.
  • 33. 
    You can’t add a record to a table with a foreign key unless that foreign key ___________________ the value of a primary key in the related table.
  • 34. 
    The most common type of relationship between tables in a relational database is a _____________________ relationship.
  • 35. 
    The ___________________ of a column in a database table determines what type of data can be stored in the column.
  • 36. 
    You use a SQL _________________ statement to retrieve data from a SQL database.
  • 37. 
    An inner join combines data from two or more tables in which the related fields _________________________________.
  • 38. 
    To add a row to a table in a database, you use the SQL _______________ statement.
  • 39. 
    To control what users can do with a database, SQL can be used to create users and assign _______________________ to them.
  • 40. 
    phpMyAdmin can be used to import and run a SQL _______________________ that creates one or more databases.
  • 41. 
    What does a relational database use to uniquely identify each row in a table?
    • A. 

      Indexes

    • B. 

      Foreign keys

    • C. 

      Non-primary keys

    • D. 

      Primary keys

  • 42. 
    What does a relational database use to relate the tables in a database to other tables?
    • A. 

      Indexes

    • B. 

      Foreign keys

    • C. 

      Non-primary keys

    • D. 

      Primary keys

  • 43. 
    If a row in one table is related to just one row in another table, the tables are said to have a
    • A. 

      One-to-many relationship

    • B. 

      One-to-one relationship

    • C. 

      Many-to-many relationship

  • 44. 
    The column definition for a MySQL table can be used to determine all but one of the following. Which one is it?
    • A. 

      What type of data the column can contain

    • B. 

      Whether the column can contain a null value

    • C. 

      Whether the column has a default value

    • D. 

      What range of values the column can contain

  • 45. 
    Which of the following can a SELECT statement not do to the data in a table?
    • A. 

      Get selected rows

    • B. 

      Get selected columns

    • C. 

      Sort the rows

    • D. 

      Delete the rows