Copy and Edit

Chapter 3 (True/False)

Description

asdf Quiz on Chapter 3 (True/False), created by . . on 31/08/2016.
. .
Quiz by . ., updated more than 1 year ago
. .
Created by . . over 8 years ago
463
2
0

Resource summary

Question 1

Question
1) The practical significance of taking the logical view of a database is that is serves as reminder of the simple file concept of data storage.
Answer
  • True
  • False

Question 2

Question
2) You can think of a table as a persistent representation of a logical relation.
Answer
  • True
  • False

Question 3

Question
3) Because the relational model uses attribute values to establish relationships among tables, many data-base susers correctly assume that the term relation refers to such relationships.
Answer
  • True
  • False

Question 4

Question
4) The order of the rows and columns is important to the DBMS.
Answer
  • True
  • False

Question 5

Question
5) Numeric data are data on which you can perform meaningful arithmetic procedures.
Answer
  • True
  • False

Question 6

Question
6) Character data can contain any character or symbol intended for mathematical manipulation.
Answer
  • True
  • False

Question 7

Question
7) Each table in a relational database must have a primary key.
Answer
  • True
  • False

Question 8

Question
8) The idea of determination is unique to the database environment.
Answer
  • True
  • False

Question 9

Question
9) In a relational model, if A determines B, C, and D, you write A = B, C, D.
Answer
  • True
  • False

Question 10

Question
10) Only a single attribute, not multiple attributes, can define functional dependence.
Answer
  • True
  • False

Question 11

Question
11) If the attribute (B) is functionally dependent on a composite key (A) but not on any subset of that composite key, the attribute (B) is fully functionally dependent on (A).
Answer
  • True
  • False

Question 12

Question
12) A null is created when you press the Enter key or the Tab key to move to the next entry without making a prior entry of any kind.
Answer
  • True
  • False

Question 13

Question
13) There is never a good reason to use null values in a database.
Answer
  • True
  • False

Question 14

Question
14) Depending on the sophistication of the application development software, nulls can create problems when functions such as COUNT, AVERAGE, and SUM are used.
Answer
  • True
  • False

Question 15

Question
15) Tables within a database share common attributes that enable the tables to be linked together.
Answer
  • True
  • False

Question 16

Question
16) A foreign key must exist in both tables that have a relationship
Answer
  • True
  • False

Question 17

Question
17) RDBMSs enforce integrity rules automatically.
Answer
  • True
  • False

Question 18

Question
18) Referential and entity integrity are two names for the same thing.
Answer
  • True
  • False

Question 19

Question
19) The SELECT operator yields a vertical subset of a table.
Answer
  • True
  • False

Question 20

Question
20) Tables must have the same attribute characteristics (the columns and domains must be compatible) to be used in a UNION.
Answer
  • True
  • False

Question 21

Question
21) The DIFFERENCE operator subtracts one table from the other.
Answer
  • True
  • False

Question 22

Question
22) In a natural join, the column on which the join was made occurs twice in the new table.
Answer
  • True
  • False

Question 23

Question
23) A left outer join on tables CUSTOMER and AGENT yields all of the rows in the CUSTOMER table, including those that do not have a matching value in the AGENT table.
Answer
  • True
  • False

Question 24

Question
24) The DIVIDE operation uses one single-column table (e.g., column "a") as the divsor and one two-column table (e.g., columns "a" and "b") as the dividend.
Answer
  • True
  • False

Question 25

Question
25) A data dictionary contains metadata-data about data.
Answer
  • True
  • False

Question 26

Question
26) A data dictionary is sometimes described as :the database designer's database" because it records the design decisions about tables and their structures.
Answer
  • True
  • False

Question 27

Question
27) Current relational database software generally provides only a system catalog (and not a data dictionary).
Answer
  • True
  • False

Question 28

Question
28) The one-to-many (1:M) relationship is easily implemented in the relational mode by putting the foreign key of the "1" side in the table of the "many" side as a primary key.
Answer
  • True
  • False

Question 29

Question
29) As rare as 1:! relationships should be, certain conditions absolutely require their use.
Answer
  • True
  • False

Question 30

Question
30) DBMSs use indexes for many different purposes.
Answer
  • True
  • False
Show full summary Hide full summary

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

El Perdón
Alonso Linares
Investiga las transformaciones de la cultura y de la vida cotidiana a lo largo del tiempo.
Sherlyn Muñoz
Irene
i.biza
Sean doce balines (a,b,c,d,e,f,g,h,i,j,k,l)
andres parra
Funciones Polinomiales
Julieta Maya
10.THE VALUATION PROCESS AND PRICING PROPERTIES
Brigita Safyra
Effective Citizens
Lauren Petrouleas
asdfas
bevan7
S C I E X
guohao.lam
Perspectives of learning
nilemon
Mind Idea
rodrigo.cespedes
Browse Library