. .
Quiz by , created more than 1 year ago

asdf Quiz on Chapter 2 (Multiple Choice) CIS 3365, created by . . on 30/08/2016.

522
2
0
. .
Created by . . over 8 years ago
Close

Chapter 2 (Multiple Choice) CIS 3365

Question 1 of 30

1

21. A(n) _________’s main function is to help one understand the complexities of the real­world environment.

Select one of the following:

  • A. node

  • b. entity

  • c. model

  • d. database

Explanation

Question 2 of 30

1

22. A(n) ____________ represents a particular type of object in the real world.

Select one of the following:

  • a. attribute

  • b. entity

  • c. relationship

  • d. node

Explanation

Question 3 of 30

1

23. A(n) __________ is anything about which data are to be collected and stored.

Select one of the following:

  • a. attribute

  • b. entity

  • c. relationship

  • d. constraint

Explanation

Question 4 of 30

1

24. A(n) ___________ is the equivalent of a field in a file system.

Select one of the following:

  • a. attribute

  • b. entity

  • c. relationship

  • d. constraint

Explanation

Question 5 of 30

1

25. A(n) _________ is bidirectional.

Select one of the following:

  • a. attribute

  • b. entity

  • c. relationship

  • d. constraint

Explanation

Question 6 of 30

1

26. A(n) _________ is a restriction placed on the data.

Select one of the following:

  • a. attribute

  • b. entity

  • c. relationship

  • d. constraint

Explanation

Question 7 of 30

1

27. ________ are important because they help to ensure data integrity.

Select one of the following:

  • a. Attributes

  • b. Entities

  • c. Relationships

  • d. Constraints

Explanation

Question 8 of 30

1

28. ________ are normally expressed in the form of rules.

Select one of the following:

  • a. Attribtues

  • b. Entities

  • c. Relationships

  • d. Constraints

Explanation

Question 9 of 30

1

29. Students and classes have a ____________ relationship.

Select one of the following:

  • a. one-to-one

  • b. one-to-many

  • c. many-to-one

  • d. many-to-many

Explanation

Question 10 of 30

1

Business rules are derived from ____.

Select one of the following:

  • a.a detailed description of an organization’s operations

  • b.standards and practices developed over the years

  • c.managers’ recommendations

  • d.governmental oversight organization standards

Explanation

Question 11 of 30

1

31. Which of the following is true of business rules?

Select one of the following:

  • a. They allow the designer to set company policies with regard to data.

  • b. They allow the designer to develop business processes.

  • c. They can serve as a communication tool between the users and designers.

  • d. They provide a framework for the company’s self-actualization.

Explanation

Question 12 of 30

1

32. A noun in a business rule translates to a(n) __________ in the data model.

Select one of the following:

  • a. entity

  • b. attribute

  • c. relationship

  • d. constraint

Explanation

Question 13 of 30

1

33. A verb associating two nouns in a business rule translates to a(n) __________ in the data model.

Select one of the following:

  • a. entity

  • b. attribute

  • c. relationship

  • d. constraint

Explanation

Question 14 of 30

1

34. The hierarchical data model was developed in the __________.

Select one of the following:

  • a. 1960s

  • b. 1970s

  • c. 1980s

  • d. 1990s

Explanation

Question 15 of 30

1

35. The object-oriented data model was developed in the ____________.

Select one of the following:

  • a. 1960s

  • b. 1970s

  • c. 1980s

  • d. 1990s

Explanation

Question 16 of 30

1

36. VMS/VSAM is an example of the ___________.

Select one of the following:

  • a. hierarchical model

  • b. file system data model

  • c. relational data model

  • d. XML data model

Explanation

Question 17 of 30

1

37. Oracle 11g is an example of the ___________.

Select one of the following:

  • a. hierarchical model

  • b. file system data model

  • c. relational data model

  • d. XML/Hybrid data model

Explanation

Question 18 of 30

1

38. MySQL is an example of the ________.

Select one of the following:

  • a. hierarchical model

  • b. file system data model

  • c. relational data model

  • d. XML data model

Explanation

Question 19 of 30

1

39. In the ________ model, the basic logical structure is represented as an upside-down tree.

Select one of the following:

  • a. hierarchical

  • b. network

  • c. relational

  • d. entity relationship

Explanation

Question 20 of 30

1

40. In the __________ model, each parent can have many children, but each child has only one parent.

Select one of the following:

  • a. hierarchical

  • b. network

  • c. relational

  • d. entity relationship

Explanation

Question 21 of 30

1

41. The relational data model was developed in the _________.

Select one of the following:

  • a. 1960s

  • b. 1970s

  • c. 1980s

  • d. 1990s

Explanation

Question 22 of 30

1

42. In the _______ model, the user perceives the database as a collection of records in 1:M relationships, where each record can have more than one parent.

Select one of the following:

  • a. hierarchical

  • b. network

  • c. object-orientated

  • d. entity relationship

Explanation

Question 23 of 30

1

44. A(n) ________ enables a database administrator to describe schema components.

Select one of the following:

  • a. extensible markup language (XML)

  • b. data definition language (DDL)

  • c. unified modeling language (UML)

  • d. query langauge

Explanation

Question 24 of 30

1

24.The ____ model was developed to allow designers to use a graphical tool to
examine structures rather than describing them with text.

Select one of the following:

  • a. hierarchial

  • b. network

  • c. object-oriented

  • d. entity relationship

Explanation

Question 25 of 30

1

49. The ________ model uses the term connectivity to label the relationship types.

Select one of the following:

  • a. relational

  • b. network

  • c. object-oriented

  • d. entity relationship

Explanation

Question 26 of 30

1

51. The _________ data model is said to be a semantic data model.

Select one of the following:

  • a. relational

  • b. network

  • c. object-oriented

  • d. entity relationship

Explanation

Question 27 of 30

1

52. The ________ data model uses the concept of inheritance.

Select one of the following:

  • a. relational

  • b. network

  • c. object-oriented

  • d. entity relationship

Explanation

Question 28 of 30

1

53. One of the limitations of the ________ model is that there is a lack of standards.

Select one of the following:

  • a. hierarchical

  • b. network

  • c. relational

  • d. entity relationship

Explanation

Question 29 of 30

1

54. The ________ model is the end users’ view of the data environment.

Select one of the following:

  • a. abstract

  • b. external

  • c. conceptual

  • d. internal

Explanation

Question 30 of 30

1

30.A(n) ____ model represents a global view of the database as viewed by the entire
organization.

Select one of the following:

  • a. external

  • b. conceptual

  • c. internal

  • d. physical

Explanation

Previous
Check answer
Next