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. (A)</p> Signup and view all the answers

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

<p>data macros (C)</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 (D)</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 (C)</p> Signup and view all the answers

What best describes a null value?

<p>an intentional nothing (D)</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. (B)</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. (D)</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 (C)</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. (C)</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
Use Quizgecko on...
Browser
Browser