Inform-midterm: The Perfect Reviewer Edition
  • 1. Perfect na ba? ( ˵ •̀ ᴗ •́˵)
A) YES SIR
B) PRAISE SIR BUDS
C) EEYYY
D) (¬ᴗ ´¬ )
E) SALAMAT SHOPEE
  • 2. What does HTML stand for?
A) Hyperlinks and Text Markup Language
B) HyperText Markup Language
C) High Technical Modern Language
D) Home Tool Markup Language
  • 3. What is the latest version of HTML?
A) HTML6
B) HTML5
C) HTML2023
D) HTML4
  • 4. Which tag is used to define a hyperlink?
A) <href>
B) <link>
C) <url>
D) <a>
  • 5. What is the correct way to create a line break in HTML?
A) <br>
B) <lb>
C) \n
D) <break>
  • 6. Which HTML tag is used for inserting an image?
A) <src>
B) <img>
C) <image>
D) <picture>
  • 7. How do you create a numbered list in HTML?
A) <ol>
B) <ul type="numbered">
C) <list type="number">
D) <nl>
  • 8. What attribute specifies the URL of an image in HTML?
A) link
B) url
C) src
D) href
  • 9. What tag is used to create a table in HTML?
A) <tabular>
B) <tb>
C) <grid>
D) <table>
  • 10. What does the <th> tag define in an HTML table?
A) Table horizontal
B) Table height
C) Table hyperlink
D) Table header
  • 11. What is the correct HTML tag for the largest heading?
A) <heading>
B) <h>
C) <h1>
D) <head>
  • 12. How do you create a checkbox in HTML?
A) <input type='checkbox'>
B) <checkbox>
C) <option type='check'>
D) <check>
  • 13. What is the correct way to create an email input field?
A) <input email>
B) <field type='email'>
C) <input type='email'>
D) <email>
  • 14. Which HTML tag is used to create a form?
A) <form>
B) <input>
C) <fieldset>
D) <formfield>
  • 15. What is the correct way to link an external CSS file?
A) <stylesheet>style.css</stylesheet>
B) <css import='style.css'>
C) <style src='style.css'>
D) <link rel='stylesheet' href='style.css'>
  • 16. What is the correct HTML tag for inserting a line?
A) <break>
B) <line>
C) <hr>
D) <ln>
  • 17. Which of the following elements is not a block-level element?
A) <p>
B) <section>
C) <div>
D) <span>
  • 18. What does the 'alt' attribute in <img> tag specify?
A) Alignment text
B) Alternative text
C) Alert type
D) Altitude
  • 19. What does <meta charset='UTF-8'> define?
A) Character setting
B) Character type
C) Character size
D) Character encoding
  • 20. Which tag is used to define a list item?
A) <bullet>
B) <item>
C) <list>
D) <li>
  • 21. How do you define a radio button in HTML?
A) <circle>
B) <input type='radio'>
C) <button type='radio'>
D) <radio>
  • 22. Which tag is used to create a dropdown list?
A) <dropdown>
B) <list>
C) <option>
D) <select>
  • 23. What attribute is used to make a text input field required?
A) required
B) needed
C) mandatory
D) must
  • 24. Which tag is used to embed a video in HTML5?
A) <movie>
B) <media>
C) <video>
D) <play>
  • 25. Which HTML tag is used to define important text?
A) <strong>
B) <bold>
C) <important>
D) <em>
  • 26. What does the 'action' attribute in a form specify?
A) What type of form it is
B) When to submit the form
C) How to validate the form
D) Where to send form data
  • 27. Which HTML tag defines the document's body?
A) <doc>
B) <body>
C) <main>
D) <content>
  • 28. Which tag is used for inserting an inline frame?
A) <frame>
B) <inframe>
C) <iframe>
D) <embed>
  • 29. What is the default file extension for HTML files?
A) .web
B) .htm
C) .html
D) .doc
  • 30. Which tag is used to create a tooltip?
A) hint
B) title
C) tooltip
D) hover
  • 31. Which attribute specifies the relationship between the current document and an external resource?
A) rel
B) link
C) relationship
D) ref
  • 32. Which HTML attribute is used to define inline styles?
A) design
B) css
C) style
D) format
  • 33. Which HTML element is used for the footer of a document?
A) <bottom>
B) <footer>
C) <end>
D) <base>
  • 34. What does the 'placeholder' attribute do?
A) Displays hint text inside an input field
B) Reserves space for an image
C) Sets input field positioning
D) Creates a default value
  • 35. Which HTML tag is used to display a progress bar?
A) <progress>
B) <loading>
C) <meter>
D) <bar>
  • 36. Which tag represents a self-contained piece of content?
A) <container>
B) <section>
C) <div>
D) <article>
  • 37. Which HTML element defines navigation links?
A) <menu>
B) <links>
C) <navigation>
D) <nav>
  • 38. Which tag is used to mark emphasized text?
A) <important>
B) <em>
C) <highlight>
D) <i>
  • 39. Which HTML element is used to create a responsive image?
A) <responsive>
B) <adaptive>
C) <flex-img>
D) <picture>
  • 40. What is the purpose of the <datalist> element?
A) Creates a data table
B) Stores structured data
C) Formats list items
D) Provides a list of predefined options for an input
  • 41. What does CRUD stand for?
A) Create Read Update Delete
B) Current Record User Data
C) Create Restore Update Delete
D) Connect Read Upload Download
  • 42. What SQL statement is used to retrieve data?
A) GET
B) RETRIEVE
C) FETCH
D) SELECT
  • 43. How do you insert data into a table?
A) INSERT
B) CREATE ROW
C) ADD
D) PUT
  • 44. How do you update data in a table?
A) ALTER ROW
B) MODIFY
C) UPDATE
D) CHANGE
  • 45. How do you remove a record from a table?
A) ERASE
B) DELETE
C) DROP ROW
D) REMOVE
  • 46. Which command creates a new database?
A) NEW DATABASE
B) ADD DATABASE
C) MAKE DATABASE
D) CREATE DATABASE
  • 47. What is the primary key used for?
A) Uniquely identifying records
B) Creating indexes
C) Joining tables
D) Encrypting data
  • 48. Which SQL clause filters records?
A) WHERE
B) FILTER
C) CONDITION
D) HAVING
  • 49. What keyword is used to change existing records?
A) UPDATE
B) MODIFY
C) ALTER
D) CHANGE
  • 50. Which clause is used to sort query results?
A) ORDER BY
B) GROUP BY
C) ARRANGE BY
D) SORT BY
  • 51. What does the DELETE statement do?
A) Removes records
B) Drops tables
C) Clears databases
D) Removes columns
  • 52. Which SQL statement is used to add a new column to a table?
A) MODIFY TABLE
B) ALTER TABLE
C) CHANGE TABLE
D) ADD COLUMN
  • 53. What is the purpose of the LIMIT clause?
A) Sets maximum table size
B) Limits query execution time
C) Restricts user access
D) Restricts the number of rows returned
  • 54. How do you remove all records from a table but keep its structure?
A) REMOVE RECORDS
B) CLEAR TABLE
C) DELETE ALL
D) TRUNCATE TABLE
  • 55. What is the purpose of the HAVING clause?
A) Conditionally joins tables
B) Filters grouped records
C) Specifies column aliases
D) Limits returned rows
  • 56. Which SQL keyword is used to add constraints to a table?
A) RULE
B) LIMIT
C) CONSTRAINT
D) RESTRICT
  • 57. How do you check if a column allows NULL values?
A) Check column definition
B) VERIFY COLUMN
C) RUN NULLABLE()
D) CHECK NULL
  • 58. Which statement deletes a table completely?
A) REMOVE TABLE
B) ERASE TABLE
C) DELETE TABLE
D) DROP TABLE
  • 59. What is a foreign key used for?
A) Creating relationships
B) Speeding up queries
C) Validating input
D) Sorting data
  • 60. Which SQL keyword is used to group results?
A) COLLECT
B) GROUP BY
C) ORGANIZE BY
D) CLUSTER
  • 61. Which SQL command is used to remove a specific record?
A) ERASE
B) DROP RECORD
C) DELETE
D) REMOVE
  • 62. Which command is used to remove all records but keep the table structure?
A) FLUSH
B) TRUNCATE
C) RESET
D) CLEAR
  • 63. Which SQL command is used to change the name of a table?
A) RENAME TABLE
B) ALTER NAME
C) CHANGE TABLE
D) MODIFY TABLE
  • 64. What is the default sorting order in SQL?
A) Chronological
B) Descending
C) Ascending
D) Alphabetical
  • 65. Which SQL keyword is used to specify a condition?
A) WHEN
B) IF
C) CONDITION
D) WHERE
  • 66. Which SQL statement is used to find the highest value in a column?
A) TOP()
B) MAXIMUM()
C) HIGHEST()
D) MAX()
  • 67. Which SQL command creates a backup of a table?
A) COPY TABLE
B) CREATE TABLE AS SELECT
C) DUPLICATE TABLE
D) BACKUP TABLE
  • 68. What SQL clause is used to join tables based on a common column?
A) JOIN
B) MERGE
C) COMBINE
D) RELATE
  • 69. What does the COUNT() function do in SQL?
A) Counts the number of rows
B) Tallies column totals
C) Measures table size
D) Counts distinct values
  • 70. Which SQL statement removes a column from a table?
A) ALTER TABLE DROP COLUMN
B) DELETE COLUMN
C) DROP COLUMN
D) REMOVE COLUMN
  • 71. Which SQL function returns the total sum of a numeric column?
A) SUM()
B) ADD()
C) TOTAL()
D) CALCULATE()
  • 72. Which SQL clause is used to filter grouped results?
A) FILTER GROUP
B) HAVING
C) GROUP FILTER
D) WHERE GROUP
  • 73. Which SQL keyword is used to prevent duplicate values in a query result?
A) UNIQUE
B) DIFFERENT
C) NODUPE
D) DISTINCT
  • 74. What is the main purpose of an index in SQL?
A) Organizing data storage
B) Preventing duplicate records
C) Validating data integrity
D) Improving query performance
  • 75. Which type of JOIN returns all records from both tables when a match exists?
A) COMPLETE JOIN
B) OUTER JOIN
C) INNER JOIN
D) FULL JOIN
  • 76. Which SQL command creates a stored procedure?
A) MAKE PROCEDURE
B) NEW PROCEDURE
C) ADD PROCEDURE
D) CREATE PROCEDURE
  • 77. Which SQL statement is used to create a backup copy of an entire database?
A) BACKUP DATABASE
B) DUPLICATE DATABASE
C) SAVE DATABASE
D) COPY DATABASE
  • 78. Which SQL keyword is used to limit the number of records returned by a query?
A) TOP
B) ROWS
C) MAX
D) LIMIT
  • 79. Which SQL clause is used to group data based on a common column?
A) ORDER INTO
B) CLUSTER BY
C) GROUP BY
D) COLLECT BY
  • 80. Which SQL function is used to get the current date and time?
A) TODAY()
B) DATETIME()
C) NOW()
D) CURRENT()
Students who took this test also took :

Created with That Quiz — where test making and test taking are made easy for math and other subject areas.