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