Quiz
Chapter 3 (True/False)
Crie uma conta grátis para terminar este quiz
Salve seu progresso e veja sua nota final.
Já tem uma conta? Inicie sessão
Perguntas do quiz (30)
11) 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.
- AVerdadeiro
- BFalso
22) You can think of a table as a persistent representation of a logical relation.
- AVerdadeiro
- BFalso
33) 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.
- AVerdadeiro
- BFalso
44) The order of the rows and columns is important to the DBMS.
- AVerdadeiro
- BFalso
55) Numeric data are data on which you can perform meaningful arithmetic procedures.
- AVerdadeiro
- BFalso
66) Character data can contain any character or symbol intended for mathematical manipulation.
- AVerdadeiro
- BFalso
77) Each table in a relational database must have a primary key.
- AVerdadeiro
- BFalso
88) The idea of determination is unique to the database environment.
- AVerdadeiro
- BFalso
99) In a relational model, if A determines B, C, and D, you write A = B, C, D.
- AVerdadeiro
- BFalso
1010) Only a single attribute, not multiple attributes, can define functional dependence.
- AVerdadeiro
- BFalso
1111) 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).
- AVerdadeiro
- BFalso
1212) 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.
- AVerdadeiro
- BFalso
1313) There is never a good reason to use null values in a database.
- AVerdadeiro
- BFalso
1414) Depending on the sophistication of the application development software, nulls can create problems when functions such as COUNT, AVERAGE, and SUM are used.
- AVerdadeiro
- BFalso
1515) Tables within a database share common attributes that enable the tables to be linked together.
- AVerdadeiro
- BFalso
1616) A foreign key must exist in both tables that have a relationship
- AVerdadeiro
- BFalso
1717) RDBMSs enforce integrity rules automatically.
- AVerdadeiro
- BFalso
1818) Referential and entity integrity are two names for the same thing.
- AVerdadeiro
- BFalso
1919) The SELECT operator yields a vertical subset of a table.
- AVerdadeiro
- BFalso
2020) Tables must have the same attribute characteristics (the columns and domains must be compatible) to be used in a UNION.
- AVerdadeiro
- BFalso
2121) The DIFFERENCE operator subtracts one table from the other.
- AVerdadeiro
- BFalso
2222) In a natural join, the column on which the join was made occurs twice in the new table.
- AVerdadeiro
- BFalso
2323) 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.
- AVerdadeiro
- BFalso
2424) 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.
- AVerdadeiro
- BFalso
2525) A data dictionary contains metadata-data about data.
- AVerdadeiro
- BFalso
2626) A data dictionary is sometimes described as :the database designer's database" because it records the design decisions about tables and their structures.
- AVerdadeiro
- BFalso
2727) Current relational database software generally provides only a system catalog (and not a data dictionary).
- AVerdadeiro
- BFalso
2828) 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.
- AVerdadeiro
- BFalso
2929) As rare as 1:! relationships should be, certain conditions absolutely require their use.
- AVerdadeiro
- BFalso
3030) DBMSs use indexes for many different purposes.
- AVerdadeiro
- BFalso
Informações
- Descrição
- asdf Quiz sobre Chapter 3 (True/False), criado por . . em 31-08-2016.
- Autor
- . .
- Idioma
- English
- Visualizações
- 529
- Etiquetas
- Avaliação
- 5,0 de 5 · 1 avaliação Avalie este quiz