Database Management Quiz - SQL Joins & Commands
53 Questions
0 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What does TCP/IP stand for?

  • Transmission Control Protocol/Information Protocol
  • Transfer Continuity Protocol/Internet Protocol
  • Transmission Control Protocol/Internet Protocol (correct)
  • Transmit Control Protocol/Information Protocol

    • Hypertext...

  • is a fast way of sending textual data across the internet
  • enables user to click a two-way "link"
  • refers to web resources restricted by user authentication
  • can be a word, phrase, or sentence (correct)

    • DNS helps...

  • to translate IMAP connections into POP data
  • to translate human friendly domain names into IP addresses (correct)
  • to translate distinct number systems for faster internet
  • to translate dynamic domain names into geo-locations

    • HTML...

    <p>is short for Hypertext Markup Language and defines the structure of a web page</p> Signup and view all the answers

    According to HTML5 Standards, which choice describes how to use tables correctly on a web page?

    <p>Tables should be used to format content but not to structure a page.</p> Signup and view all the answers

    What does HTML stand for?

    <p>Hyper Text Markup Language</p> Signup and view all the answers

    Absolute URLs are used to point to web pages...

    <p>on either the same, or other web servers.</p> Signup and view all the answers

    Relative URLs point to web pages...

    <p>on the same web server.</p> Signup and view all the answers

    You can use image/video/code from other sources on your web page...

    <p>Only if they are not copyrighted. Always cite your source page if the author requires it.</p> Signup and view all the answers

    There are three ways to apply CSS to a webpage - inline, embedded, and as an external style sheet.

    <p>True</p> Signup and view all the answers

    Body (colour: black;) is the correct CSS Syntax for changing text colour.

    <p>False</p> Signup and view all the answers

    Which CSS code gives us: margin-right: 5px; margin-left: 10px; margin-top: 7px; margin-bottom: 2px;

    <p>margin: 7px 5px 2px 10px;</p> Signup and view all the answers

    Which of the following property sets the distance between an element's right border and the rightmost edge of its content?

    <p>padding-right</p> Signup and view all the answers

    Select the correct answer. In a form:

    <p>The POST method can not be seen in the URL</p> Signup and view all the answers

    Which of the following is not a form <input> type:

    <p>div</p> Signup and view all the answers

    With CSS, how do you add a background color for all

    elements?

    <p>h1{background-color:#FFFFFF;}</p> Signup and view all the answers

    Choose the following CSS which is valid:

    <p>body { font-size: 3em background-position: top left; table { color: green; font-size: 14px; #some-element ( ] bg-color: #ff0000; bg-size: cover; bg-image: url(&quot;some-image.jpg&quot;); a-class-name, div. { text-decorations: underline; font-style: bold; }</p> Signup and view all the answers

    Every web page should begin with the definition

    <p>True</p> Signup and view all the answers

    The tag is what we use to display content to be displayed at the start of a section.

    <p>False</p> Signup and view all the answers

    The

    tag cannot be contained within an
    tag.

    <p>False</p> Signup and view all the answers

    When a

    <p>the element, that has an &quot;id&quot; attribute that matches the label's, &quot;for&quot; attribute is selected</p> Signup and view all the answers

    The form's action attribute specifies:

    <p>the location of the script that processes the form submission data.</p> Signup and view all the answers

    The element to use for a multi-line text input is:

    &lt;textarea>&lt;/textarea> Signup and view all the answers

    Choose the correct statement.

    <p>A named anchor can be added to an absolute or relative link.</p> Signup and view all the answers

    The tag represents a:

    <p>A table cell</p> Signup and view all the answers

    Given the following HTML, what would be displayed in the web browser:

    Hello World

    My name is George

    <p>My name is George</p> Signup and view all the answers

    HTML tags:

    <p>are enclosed by angle brackets.</p> Signup and view all the answers

    Returns all records when there is a match in either the left or right table records.

    <p>(INNER) JOIN</p> Signup and view all the answers

    Returns all records from the first table, and all matched records from the second table.

    <p>LEFT (OUTER) JOIN</p> Signup and view all the answers

    Selects all rows from both tables, provider that there is match between the columns.

    <p>(INNER) JOIN</p> Signup and view all the answers

    Returns all records from the second table, and all matched records from the first table.

    <p>RIGHT (OUTER) JOIN</p> Signup and view all the answers

    Is when a table is joined with itself.

    <p>SELF JOIN</p> Signup and view all the answers

    Aggregate functions (such as GROUP BY) can be filtered using the

    <p>HAVING clause</p> Signup and view all the answers

    What would be the command to switch to or use the database "F2023_COMP144_imd044"

    <p>USE F2023_COMP144_imd044</p> Signup and view all the answers

    What is the command to show all of the database tables in the currently selected database?

    <p>SHOW TABLES</p> Signup and view all the answers

    What command (single word) is used to retrieve data from a database table?

    <p>SELECT</p> Signup and view all the answers

    What is the command to log in to mysql with the username "imd044_f2023"

    <p>mysql -u imd044_f2023</p> Signup and view all the answers

    Which type of join can potentially return very large data sets

    <p>FULL JOIN</p> Signup and view all the answers

    In a normalized relational database, repeated (redundant) attributes is not permitted

    <p>True</p> Signup and view all the answers

    Match the terms to the corresponding description

    <p>An association between entities Example: A Student registers for a Class and a Class contains Student registrations = Relationship A person, place, thing, or event. Example: Student, Class, Book, Schedule = Entity Field or Attribute = Attribute Record or Tuple = Row A property of a person, place, thing or event. Example: for a &quot;Student&quot;, this could include &quot;name&quot;, &quot;student number&quot;, or &quot;address&quot; = Column</p> Signup and view all the answers

    In relational databases, the order of records and attributes is critically important:

    <p>False</p> Signup and view all the answers

    What is the command to view all available databases?

    <p>SHOW DATABASES</p> Signup and view all the answers

    Best for small database and many web-based applications. Does not work well under heavy loads or complex queries. Usually free to use.

    <p>MySQL</p> Signup and view all the answers

    Enterprise level relational database management system. Is a direct competitor to Oracle. Different versions aimed from small to large applications.

    <p>PostGRES</p> Signup and view all the answers

    Is a free version of MySQL. Good choice for medium-size databases. Works well with GIS data, so is common solution for mapping data. Usually free to use.

    <p>MariaDB</p> Signup and view all the answers

    Top tier relational database management system. Is considered for large enterprise environments for large databases under load. Super expensive.

    <p>Oracle</p> Signup and view all the answers

    What are the two assertions that protect the integrity of a set of relations, in a relational model?

    <p>Primary Key</p> Signup and view all the answers

    SQL is short for

    <p>Structured Query Language</p> Signup and view all the answers

    What bootstrap class is used to style a form <input type="text"> so that it has rounded corners.

    <p>form-control</p> Signup and view all the answers

    Bootstrap grids: What is the correct math to make up a full column?

    <div class="col-sm-4"> Signup and view all the answers

    The following HTML with bootstrap classes will result in what?

    <p>A column that is 25% wide for large devices (Ig), and 50% wide for mobile devices (md).</p> Signup and view all the answers

    What is a widget?

    <p>Blocks of content that you can add to your site's header, footer, sidebar, and right below your blog post content.</p> Signup and view all the answers

    Posts are _____. Pages are _____.

    Signup and view all the answers

    Study Notes

    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

    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>.

    Studying That Suits You

    Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

    Quiz Team

    Related Documents

    W3 HTML Forms Questions and Answers PDF

    Description

    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.

    More Like This

    SQL Joins Quiz
    3 questions

    SQL Joins Quiz

    ArtisticPenguin avatar
    ArtisticPenguin
    SQL Joins with ON Clause Quiz
    10 questions

    SQL Joins with ON Clause Quiz

    AstonishingMinneapolis avatar
    AstonishingMinneapolis
    SQL Joins and Select Statements Quiz
    14 questions

    SQL Joins Quiz: Test Your Knowledge with SQL Join Queries

    AmazedNirvana avatar
    AmazedNirvana
    Interoperability and DBD: SQL Joins
    80 questions

    Interoperability and DBD: SQL Joins

    VisionaryVerisimilitude avatar
    VisionaryVerisimilitude
    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser