Chapter 3 (True/False)

. .
Quiz by , created about 3 years ago

asdf Quiz on Chapter 3 (True/False), created by . . on 08/31/2016.

35
1
0
Tags No tags specified
. .
Created by . . about 3 years ago
S C I E X
guohao.lam
asdfas
bevan7
Effective Citizens
Lauren Petrouleas
Chemistry C1
Chloe Winn
Animal Farm Chapter Overview
10jgorman
El Perdón
Alonso Linares
Irene
i.biza
Investiga las transformaciones de la cultura y de la vida cotidiana a lo largo del tiempo.
Sherlyn Muñoz
Funciones Polinomiales
Julieta Maya
Sean doce balines (a,b,c,d,e,f,g,h,i,j,k,l)
andres parra

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