ch 4
12 Questions
6 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

RIGHT JOINS in SQL are helpful to find _____.

  • orphan records (correct)
  • parent records with no matching child records
  • records with AND criteria in the WHERE clause
  • records with OR criteria in the WHERE clause

    • When two tables are joined in an Access query, the default join type is _____.

  • LEFT
  • INNER (correct)
  • OUTER
  • RIGHT

    • Which feature of Access is used to create a report on the metadata about tables and queries?

  • cascade options
  • Database Documenter (correct)
  • referential integrity
  • data macros

    • Stored procedures differ from triggers in what essential way?

    <p>Stored procedures are usually run intentionally by users, whereas triggers are generally run automatically by processes.</p> Signup and view all the answers

    Which feature of Access mimics that of relational database management system triggers?

    <p>data macros</p> Signup and view all the answers

    Which Access field property might you use to set data integrity rules on a single field?

    <p>Validation Rule</p> Signup and view all the answers

    What is the primary purpose of creating an index?

    <p>improving the speed by which data is searched and presented</p> Signup and view all the answers

    What best describes a null value?

    <p>an intentional nothing</p> Signup and view all the answers

    Which of the following is not true about a view?

    <p>It consists of a duplicate copy of the selected data.</p> Signup and view all the answers

    Why doesn’t Access SQL provide for the SQL CREATE VIEW statement?

    <p>In Access, queries function as views.</p> Signup and view all the answers

    Which of the following is not prevented by enforcing referential integrity on a one-to-many relationship?

    <p>incorrect entry into a primary key field</p> Signup and view all the answers

    Which of the following is not true about a one-to-many relationship?

    <p>The table on the “many” side may have orphan records, especially if referential integrity is not enforced.</p> Signup and view all the answers

    Study Notes

    Views

    • A view provides access to a subset of fields and records in one or more tables.
    • A view provides a light blanket of security by limiting access to specific data.
    • A view automatically shows up-to-date information when it is executed.
    • Access does not support the SQL CREATE VIEW statement because queries function as views.

    Indexes

    • The primary purpose of creating an index is to improve the speed by which data is searched and presented.

    Null Values

    • A null value represents an intentional nothing.
    • A null value is not the same as a zero-length string (“”) or a space or tab character.

    Referential Integrity

    • Enforcing referential integrity on a one-to-many relationship prevents deleting a record in the parent table that has a matching record in a child table.
    • Enforcing referential integrity on a one-to-many relationship does not prevent incorrect entry into a primary key field or value entry into a foreign key field that doesn’t have a match in the table that contains the primary key field.

    Relationships

    • In a one-to-many relationship, the table on the “one” side is also called the parent or left table.
    • In a one-to-many relationship, the table on the “many” side may have orphan records, especially if referential integrity is not enforced.

    Joins and Queries

    • RIGHT JOINS in SQL are helpful to find orphan records.
    • When two tables are joined in an Access query, the default join type is INNER.

    Database Documenter

    • The Database Documenter is a feature of Access used to create a report on the metadata about tables and queries.

    Stored Procedures and Triggers

    • Stored procedures differ from triggers in that stored procedures are usually run intentionally by users, whereas triggers are generally run automatically by processes.
    • Data macros mimic the feature of relational database management system triggers.

    Field Properties

    • The Validation Rule field property is used to set data integrity rules on a single field.

    Studying That Suits You

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

    Quiz Team

    More Like This

    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser