Preview

CHAPTER10

Good Essays
Open Document
Open Document
1439 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
CHAPTER10
Chapter 10 Databases
Section 10.1 An Introduction to Databases
1.

A rectangular array of data is called a
(A)
(B)
(C)
(D)

2.

Each row in a table is also called a(n)
(A)
(B)
(C)
(D)

3.

record. array. field. selection. A

Which one of the following statements is NOT true about tables?
(A)
(B)
(C)
(D)

4.

field. record. table. database management system.
C

Each column of a table represents a field.
Each row of a table represents a record.
Each record in a table contains unrelated collections of fields.
A table is a rectangular array of data.
C

Which of the following is a collection of one or more (usually related) rectangular arrays of data? (A)
(B)
(C)
(D)

a table a field a record a database
D

5.

Each entry of a field of a table must contain some information. (T/F)
F

6.

The management of databases is one of the major uses of computers today. (T/F)
T

7.

DataBase Explorer can be used to browse through all parts of a connected database. (T/F)
T

8.

What is a primary key?
(A)
(B)
(C)
(D)

9.

A field that uniquely identifies each record.
The first field in every record..
The largest field in every record..
The first field specified when a table is created.
A

The requirement that no record may have a null primary key and that entries for primary keys be unique is called the
(A)
(B)
(C)
(D)

Rule of Referential Integrity.
Rule of Primary Keys.
Rule of Entity Integrity.
Rule of Null Values.
C

10. Which one of the following statements is true about primary keys?
(A)
(B)
(C)
(D)

A column of names is usually a good choice for use as a primary key.
Only a single record can be used as a primary key.
Social Security numbers are never used as a primary key.
A primary key is used to uniquely identify records in a table.
D

11. Which of the following is used to uniquely identify records in a table?
(A)
(B)
(C)
(D)

a Rule of Referential Integrity a foreign key a primary key a relational database
C

12. Which of the following is used to insure that each value for

You May Also Find These Documents Helpful

  • Powerful Essays

    Chapter 10

    • 1332 Words
    • 6 Pages

    Chuck is currently in the 25 percent tax rate bracket. His marginal tax rate on increases in income up to $8,600 and deductions from income up to $40,500 is 25 percent.…

    • 1332 Words
    • 6 Pages
    Powerful Essays
  • Satisfactory Essays

    PT2520 Unit7Labs Tramil

    • 330 Words
    • 1 Page

    2. What is a primary key? Each table usually has one column designated as a primary key . This key uniquely identifies each row in the table.…

    • 330 Words
    • 1 Page
    Satisfactory Essays
  • Satisfactory Essays

    It203 Homework 5

    • 319 Words
    • 2 Pages

    A primary key is specified by the selecting the column, right-clicking, then selecting Set Primary Key.…

    • 319 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Pt2520 Final Answers 1/3

    • 329 Words
    • 2 Pages

    which of the following best describes an attribute that can be primary key? candidate key…

    • 329 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Chapter 10

    • 536 Words
    • 3 Pages

    4. Find the area of the triangle with ∠A = 86, b = 4 ft, and c = 3 ft. Round your answer to two decimal places.…

    • 536 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    chapter 10

    • 4684 Words
    • 19 Pages

    The maker of Keebler Sandies cookies has added fudge drop Sandies to its cookie product line. Is this a new product?…

    • 4684 Words
    • 19 Pages
    Good Essays
  • Satisfactory Essays

    Chapter 9

    • 541 Words
    • 2 Pages

    Innovations such as defense wall and architecture is one of the Byzantine legacy. Their religions: Orthodox Christians and Roman Catholic were deprived during the Byzantine time, which continue to spread until the present day. The culture, they kept Greek’s literature from dying out and made copies of them. Since the city of Constantinople developed as one of the largest city in Europe, so therefore, some of the Byzantine’s legacies has contributed to the development of Europe.…

    • 541 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Assingment 1

    • 663 Words
    • 3 Pages

    Applications and utility software are used to access and use data in the DBMS and to manage the computer environment. Application programs developed in programming languages such as C++, Visual Basic that are used to access database in database management system. Utilities are the tools that helps to to manage the computer components such as anti-virus programs.…

    • 663 Words
    • 3 Pages
    Good Essays
  • Good Essays

    07

    • 4772 Words
    • 25 Pages

    3) The SQL keyword PRIMARY KEY is used to designate the column(s) that are the primary key for the table.…

    • 4772 Words
    • 25 Pages
    Good Essays
  • Good Essays

    Chapter20

    • 16888 Words
    • 85 Pages

    impressed the court of King Maximilian II of Bohemia with their sable coats and caps.…

    • 16888 Words
    • 85 Pages
    Good Essays
  • Powerful Essays

    Music

    • 1176 Words
    • 5 Pages

    | Primary Key – may contain alpha and numeric. You create this, do not use autonumber.…

    • 1176 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    Chapter 10

    • 484 Words
    • 2 Pages

    1. How do your nervous and endocrine systems work together as a physical response to stress?…

    • 484 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Questions Unit 2 Pt2520

    • 389 Words
    • 2 Pages

    * A Candidate Key can be any column or a combination of columns that can qualify as unique key in database. There can be multiple Candidate Keys in one table. Each Candidate Key can qualify as Primary Key.…

    • 389 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    Chapter 12

    • 20153 Words
    • 81 Pages

    ating is a behavior that is of interest to virtually everyone. We all do it, and most of us derive great pleasure from it. But for many of us, it becomes a source of serious personal and health problems. Most eating-related health problems in industrialized nations are associated with eating too much—the average American consumes 3,800 calories per day, about twice the average daily requirement (see Kopelman, 2000). For example, it is estimated that Watch 65% of the adult U.S. popuYou Are What You Eat lation is either overweight or www.mypsychlab.com clinically obese, qualifying this problem for epidemic status (see Abelson & Kennedy, 2004; Arnold, 2009). The resulting financial and personal costs are huge. Each year in the United States, about $100 billion is spent treating obesity-related disorders (see Olshansky et al., 2005). Moreover, each year, an estimated 300,000 U.S. citizens die from disorders caused by their excessive eating (e.g., diabetes, hypertension, cardiovascular diseases, and some cancers). Although the United States is the trend-setter when it comes to overeating and obesity, many other countries are not far behind (Sofsian, 2007). Ironically, as overeating and obesity have reached epidemic proportions, there has been a related increase in disorders…

    • 20153 Words
    • 81 Pages
    Powerful Essays
  • Good Essays

    Chapter 20

    • 334 Words
    • 2 Pages

    There are some reasons for legalizing marijuana by state laws. Some states argue that marijuana may be very helpful in some circumstances. Some researchers use the gambling to make a useful reason to discuss about legalizing marijuana. The researchers show that” legalized gambling has not reduced illegal gambling in the United States: rather, it has increased it. This is particularly evident in sports gambling, most of which is illegal. Legal gambling is taxed and regulated and illegal gambling is not. Legal gambling sets the stage for illegal gambling just the way legal marijuana would set the stage for illegal marijuana trafficking” (CNBC,2012). The author from Christian Science Monitor also points out that the government says” legalixing marijuana will end the drug war in Mexico” (Monitor’s Editorial Board,2009). This is not true or methamphetamine which can help the black market earns millions of dollars. The only way to eliminate its illegal trade or ending the drug war is selling untaxed and unregulated marijuana to any willing buyer. The United States will not do any businesses that do not bring them the benefit. Therefore, there is no way to destroy the illegal trade or drug war.…

    • 334 Words
    • 2 Pages
    Good Essays