CCC 206 — Finals (Question Bank)

  1. In the context of databases, which term refers to a request for specific information from a database, typically using a programming language such as SQL?
  2. Which of the following terms best describes a request for information or data, typically made through a search engine or database?
  3. What programming language is commonly used to manage relational database?
  4. What does the acronym SQL stand for?
  5. Which of the following statements is true about SQL?
  6. Which of the following SQL statements is used to retrieve data from a database?
  7. What is the structured implemented the language originally called sequel
  8. including database management systems is a called sequel, as part of the system R projects in early what?
  9. Which of the following statements best describe Data Definition Language (DDL) in SQL?
  10. Which of the following SQL commands is used to create a new table in a database?
  11. It is a subset of SQL that is used to manage and manipulate data written in a database?
  12. Which of the following statements best describes interactive Data Manipulation Language (DML) in SQL?
  13. Which of the following SQL statements is used to modify data in a database?
  14. Which of the following SQL statements is used to delete data in a database?
  15. Which of the following SQL statements is used to insert new data in a database?
  16. Which of the following SQL statements is used to create a view in a database?
  17. Which of the following SQL statements is used to modify the definition of a view in a database?
  18. A web application consists of HTML, CSS, and JavaScript files that are stored on a web server.
  19. This web pages are fixed and do not change unless they are manually updated by a developer.
  20. This websites are usually simple and have limited functionality.
  21. This web application generates content on the fly depending on the user's request and input.
  22. The content is generated by server-side scripts that can retrieve data from databases.
  23. This websites are more complex and can offer a wide range of functionality such as e-commerce, user registration, and content management.
  24. Which of the following SQL statements is used to select data in a database?
  25. Which of the following SQL statements is used to specify the columns to be selected in a query?
  26. Which of the following SQL statements is used to select all columns from a table?
  27. Which of the following SQL statements is used to group the results of a query by one or more columns?
  28. Which of the following SQL statements is used to delete data in a database?
  29. Which of the following SQL statements is used to filter the results of a query based on a specific condition?
  30. Which of the following SQL clauses is used to limit the number of results returned by a query?
  31. Which of the following SQL clauses is used to join data from two or more tables in a query?
  32. Which of the following SQL clauses is used to specify the sorting order of the results of a query?
  33. Which of the following SQL keywords is used to sort the results of a query in descending order?
  34. Which of the following SQL data types is used to store alphanumeric characters of variable length?
  35. The DECIMAL data type in SQL in used to store integers.
  36. The width of an SQL column is determined by the data type of the column.
  37. The width of an SQL field is always determined by the maximum length of the data being stored in that field.
  38. The SELECT statement is used in SQL to modify the data in a table.
  39. XAMPP is a web server software package that includes Apache, MySQL, PHP, and Perl.
  40. XAMPP is a licensed cross platform web server solution stack package.
  41. The Apache HTTP server is a popular open-source web server software.
  42. MySQL is a popular open-source relational database management system.
  43. MySQL supports both transactional and non-transactional storage engines.
  44. PHP stands for Personal Home Page
  45. PHP is a server-side scripting language.
  46. PHP can only run on Windows operating systems.
  47. PHP files have a .php extension.
  48. PHP is a compiled language.
  49. PHP can be used to create website applications.
  50. ____ is a term generally used to describe a new technology, but it may also refer to the continuing development of existing technology.
  51. ____ in what year discourse or treaties the technology?
  52. ____ what is the Greek word of technology?
  53. ____ is systematic treatment of an art, craft, or technique.
  54. ____ in what year the mechanical and industrial art was recorded?
  55. ____ means the process of developing by gradual changes.
  56. ____ The Industrial Revolution was a period of major industrialization and innovation that took place during the late what?
  57. ____ The Industrial Revolution was a period of major industrialization and innovation that took place during the early what?
  58. An ____ at its core occurs when a society shifts from using tools to make products to use new sources of energy, such as petroleum machines in factories.
  59. The revolution started in ____, with a series of innovations to make labor more efficient and productive.
  60. The ____ industrial revolution commonly referred to as the second industrial revolution.
  61. ____ in what year the second industrial revolution started?
  62. ____ give one most important invention of the industrial revolution in transportation.
  63. ____ give one most important invention of the industrial revolution in communication.
  64. ____ give one most important invention of the industrial revolution in industry.
  65. ____ the first of the four types of industries involves getting raw materials, mining, farming and fishing.
  66. ____ the second of the four types of industries involves manufacturing making cars and steel.
  67. ____ the 3rd of the four types of industries provide a service, teaching, and nursing.
  68. ____ the 4th of the four types of industries involves research and development industries and IT.
  69. IR was first coined in the ____ during the time where this revolution began.