Question 68

• Returns all records when there's a match in either the left or right table. This is an INNER JOIN.
• Returns records from the first table and all matched records from the second table. This is a LEFT OUTER JOIN.
• Selects all rows from both tables, provided a match exists between columns. This is a FULL OUTER JOIN.
• Returns records from the second table and all matching records from the first table. This is a RIGHT OUTER JOIN.
• A table joined with itself. This is a SELF JOIN.

Question 69

• Aggregate functions (like GROUP BY) can be filtered using the HAVING clause.

Question 63

• The command to switch to database "F2023_COMP144_imd044" is not listed.

Question 64

• The command to show all database tables in the currently selected database is not listed.

Question 65

• The command to retrieve data from a database table is not listed (single word).

Question 66

• The command to log in to MySQL with the username "imd044_f2023" is not listed.

Question 67

• SUPER JOIN is a type of join that can result in very large data sets.

Question 59

• In a normalized relational database, repeated attributes are not allowed. This is TRUE.

Question 60

• An association between entities is a RELATIONSHIP.
• A person, place, thing, or event is an ENTITY.
• A property of a person, place, thing, or event is an ATTRIBUTE.
• A property of a person, place, thing or event (Example: for a "Student", this could include "name", "student number", or "address") is a COLUMN.
• A record or tuple is a ROW.

Question 61

• In relational databases, the order of records and attributes is not critically important. This is FALSE.

Question 62

• The command to view all available databases is not listed.

Question 63 (repeated)

• The command to switch to database "F2023_COMP144_imd044" is not listed.

Question 56

• Best for smaller databases and many web-based applications. Does not work well under heavy loads. Usually free to use. MySQL.
• For medium-sized databases, well-suited for GIS data. Often free to use. MariaDB.
• Enterprise-level relational database management system. Direct competitor to Oracle. Different versions for various application types. Oracle.
• Top-tier relational database management system frequently used in large enterprise environments. Very expensive. Microsoft SQL Server.

Question 57

• Assertions that protect the integrity of relations in a relational model. The answers that were intended to appear were: Unique Key and Primary Key

Question 58

• SQL stands for Structured Query Language.

Question 53

• The bootstrap class for rounded corners in a text input field is form-control.

Question 54

• The correct math to make up a full column in Bootstrap grids is
  .

Question 55

• The following HTML,
  Hello World

  </div

  , results in a column that is 100% wide for mobile devices , will be 50% for tablets and 25% wide for desktops.

Question 48

• A widget is a block of content you can add to a site's header, footer, sidebar, or post content.

Question 49

• Posts are organized using categories and tags and are in reverse chronological order.
• Pages are used for static content, are not associated with blogs, and are not displayed in the menu.

Question 50

• A WordPress theme is a collection of files that work together to create websites with a unified design.

Question 51

• A container has maximum pixel width, while a container fluid is 100% width.

Question 52

• The selector to target premade CSS code in Bootstrap is Classes.

Question 44

• The syntax for defining an animation in CSS is (correct answer not given)

Question 45

• You can specify a finite or infinite number of times an animation will loop/play using the animation-iteration-count property. This is TRUE.

Question 46

• The most popular Content Management System (CMS) is WordPress.

Question 47

• A WordPress plugin is something that adds new functionality to WordPress sites.

Question 39

• Hick's Law states that the more options you have, the longer it takes to make a selection.

Question 40

• The 7 +/- 2 rule suggests providing 5 to 9 items for selection.

Question 41

• The animation property that specifies the style for an element when the animation is not playing is animation-fill-mode.

Question 42

• Animation duration can be a time unit (e.g., 1s) or a percentage of time (10%). This is TRUE.

Question 43

• The animation-timing-function that displays at the same speed from start to finish is linear.

Question 34

• WebP images are best used when you need the smallest file size possible, but don't need to worry about use outside of the webpage.

Question 35

• Use PNG images for on-page graphics with transparency.

Question 36

• Non-anthropomorphic design is used because error messages should be clear, and data should be sequenced and grouped effectively.

Question 37

• Error messages should be general in their response and provide enough information to set things right.

Question 38

• Internal Locus of Control is when the user feels in control of the system.

Question 30

• The CSS property for corner shapes is border-radius.

Question 31

• #STUFF with position: relative; left: 20px; top: 20px moves relative to the browser window.

Question 32

• With @media only screen and (max-width: 600px) the body will be lightblue for screens less than 600 pixels wide. With@media only screen and (max-width: 400px) the background will be green for screens less than 400px wide.

Question 33

• To obtain a 90% reduction in file size for JPEG images, a compression quality between 20% and 40% is frequently used and depends on the specific image.

Question 25

• There are three ways to apply CSS to a webpage: inline, embedded, and external stylesheet. This is TRUE.

Question 26

• body (color: black; is the correct syntax to change text color. This is FALSE.

Question 27

• CSS stands for Cascading Style Sheets.

Question 28

• margin: 7px 2px 10px 5px; (top, right, bottom, left) is the correct syntax for specifying all margins.

Question 29

• The property that sets the distance between the right border and the rightmost content is padding-right.

Question 21

• The GET method appends form data to the beginning of the URL, and the POST method does not display that data directly in the URL.

Question 22

• The
  tag is not an input type.

Question 23

• h1 {background-color:#FFFFFF;} is the correct CSS to set the background color of all

  elements to white.

Question 24

• font-size: 14px; is a valid CSS statement.

Question 15

• Every web page should begin with the <!DOCTYPE html> declaration. This is TRUE.

Question 16

• The tag in HTML displays content in the beginning of the section. This is FALSE.

Question 17

• The
  tag can be contained within an

  tag. This is FALSE.

Question 18

• When you click a tag, the element that has an id attribute matching the label's for attribute becomes selected.

Question 19

• The form's action attribute specifies the location of a script that processes form submission data.

Question 20

• The element for a multi-line text input is <textarea></textarea>.

Test your knowledge of SQL joins and basic database commands with this quiz. It covers topics such as INNER JOINS, OUTER JOINS, aggregation functions, and commands related to MySQL. Perfect for beginners and intermediate learners looking to reinforce their SQL skills.