Test
AIS 7
Crea una cuenta gratis para terminar este test
Guarda tu progreso y consulta tu resultado final.
¿Ya tienes cuenta? Inicia sesión
Preguntas del test (21)
1The best choice for the primary key in an “Employees” table would be his or her:
- ALast name
- BFirst name
- CPhone number
- DEmployee number
2From the following choices, the best example of a primary key for an employee table would be his or her:
- ASocial Security number
- BPhone number
- CLast name
- DOffice number
3The foreign key in one database table will always be a _______ key in a linked table.
- ASecondary key
- BDomestic key
- CPrimary key
- Dall of these are always true
4The terms "parent record," "child record," and "sibling record" describe the records in a:
- AHierarchical database
- BNetwork database
- CRelational database
- DFlat file
5A major advantage of relational databases is:
- AAll records are stored together
- BNo pointers are used
- CThe ability to add tables and relationships after the database becomes operational
- DIt closely resembles a flat file
6Which of these would be an example of an “agent” in the REA framework?
- ASalesperson
- BCustomer
- CManager
- Dall of these are possibilities
7Which of these would be an example of a “resource” in the REA framework?
- AEquipment
- BInventory
- CCash
- Dall of these are possible examples of resources
8In the REA framework, which of these would be recorded as an “event?”
- AHiring a new president of the company
- BTaking an initial sales order from a customer
- CBuying a piece of equipment for cash
- Dall of these would be recorded as events
9In the REA framework, an account receivable would be classified as a(n):
- AAsset
- BEvent
- CResource
- Dnone of these
10In the REA framework, a database designer should create a ____ for each entity.
- ARecord
- BTable
- CSecondary key
- DAll of these
11Assume that an accounts receivable application contains database tables for customer orders, inventory items, customers, and salespersons. All of these would be likely data fields in a customer order table except:
- ACustomer name
- BCustomer number
- CDate of order
- DOrder number
12The purpose of the E-R model is to help database designers:
- AIdentify data redundancies
- BCreate databases in third normal form
- CDesign databases and depict data relationships
- DAnswer structured queries about the data in accounting databases
13Within a database context, the relationship between “natural parent” and “child” would most likely be:
- AOne-to-one
- BOne-to-many
- CMany-to-one
- DMany-to-many
14Within a database context, the relationship between “military officer” and “private” would most likely be:
- AOne-to-one
- BOne-to-many
- CMany-to-one
- DMany-to-many
15Within be:
a database context, the relationship between “students” and “classes” would most likely- AOne-to-one
- BOne-to-many
- CMany-to-one
- DMany-to-many
16As described in the chapter, all of these are normalization “forms” except:
- AFirst normal form
- BSecond normal form
- CThird normal form
- Dall of these are normal forms
17The reason why database designers normalize data is:
- ATo eliminate data errors
- BTo scale data properly
- CTo create backup copies of data
- DTo create efficient database tables
18In the context of databases, the term data redundancy refers to:
- AStoring the same information in several records
- BRepeating data on multiple reports
- CUsing foreign keys which duplicate the values of primary keys
- Dall of these are possible examples of data redundancy
19A database is in third normal form if it is second normal form and:
- AIt contains no data redundancies
- BIt contains no foreign keys
- CIt contains no transitive dependencies
- Dall of these
20An example of a transitive dependency in a database is:
- AStudent > grade
- BTelephone area code > phone number
- CAirline > flight number
- DParking Code > parking fine amount
21An example of a transitive dependency in a database is:
- AStudent > university course number
- BParking ticket code > total of student parking fines
- CProduct number > product price
- DAge > social security number
Información
- Descripción
- 1 AIS Test sobre AIS 7, creado por Rebecca Escobar el 11/12/2016.
- Autor
- Rebecca Escobar
- Idioma
- English
- Visitas
- 5
- Etiquetas
- Valoración
- Aún sin valoraciones Valora este test