Database Management Systems Set 3

---

Which command quickly locates the data is Access table?

  

    (A) Find

    (B) Locate

    (C) Search

    (D) Edit

Find

---

Which technique prevents invalid data being saved in Access table?

  

    (A) Index

    (B) Filter

    (C) Validation rule

    (D) Input mark

Validation rule

---

Which validation rule accepts only a - z letters for fields in Access?

  

    (A) Is null or NOT like ?*[! a - z]*?

    (B) Is null or NOT like ?*[a - z ]*?

    (C) Is null or NOT like ?*![a - z]*?

    (D) Is null or NOT like ?[! a - z]?

Is null or NOT like ?*[! a - z]*?

---

Which validation rule allows only 0 - 9 for fields in Access?

  

    (A) Is Null or Not Like ?*[ ! 0 - 9 ]*?

    (B) Is Null or Not Like ?[! 0 - 9]?

    (C) Is Null or Not Like ?*[0 - 9]*?

    (D) Is Null or Not Like ?*[!0-9]*?

Is Null or Not Like ?*[!0-9]*?

---

Which validation rule allows only positive numbers for fields in?

  

    (A) Is Null or > = 0

    (B) Is Null or Positive

    (C) Is Null or < 0

    (D) Is Null or = ?+?

Is Null or > = 0

---