Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

ITC114 MCQ > Topic 2 > Flashcards

Topic 2 Flashcards

1
Q

A (n) _____’s main function is to help one understand the complexities of the real-world environment

a. node
b. entity
c. model
d. database

A

model

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

A (n) _____ is anything about which data are to be collected and stored

a. attribute
b. entity
c. relationship
d. constraint

A

entity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

A (n) _____ represents a particular type of object in the real world

a. attribute
b. entity
c. relationship
d. node

A

entity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

A (n) _____ is the equivalent of a field in a file system

a. attribute
b. entity
c. relationship
d. constraint

A

attribute

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

A (n) _____ is bidirectional

a. attribute
b. entity
c. relationship
d. constraint

A

relationship

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

A (n) _____ is a restriction placed on the data

a. attribute
b. entity
c. relationship
d. constraint

A

constraint

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

_____ are important because they help to ensure data integrity

a. Attributes
b. Entities
c. Relationships
d. Constraints

A

Constraints

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

_____ are normally expressed in the form of rules

a. Attributes
b. Entities
c. Relationships
d. Constraints

A

Constraints

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Students and classes have a _____ relationship

a. one-to-one
b. one-to-many
c. many-to-one
d. many-to-many

A

many-to-many

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Which of the following is true of business rules?

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.

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

A noun in a business rule translates to a (n) _____ in the data model

a. entity
b. attribute
c. relationship
d. constraint

A

entity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

a. entity
b. attribute
c. relationship
d. constraint

A

relationship

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

In the _____ model, the basic logical structure is represented as an upside-down tree

a. hierarchical
b. network
c. relational
d. entity relationship

A

hierarchical

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

a. hierarchical
b. network
c. relational
d. entity relationship

A

hierarchical

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

The hierarchical data model was developed in the _____

a. 1960s
b. 1970s
c. 1980s
d. 1990s

A

1960s

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

a. hierarchical
b. network
c. object-oriented
d. entity relationship

A

network

17
Q

The object-oriented data model was developed in the _____

a. 1960s
b. 1970s
c. 1980s
d. 1990s

A

1980s

18
Q

VMS/VSAM is an example of the _____

a. hierarchical model
b. file system data model
c. relational data model
d. XML data model

A

file system data model

19
Q

Oracle 12c, MS SQL Server, and Tamino are examples of _____ data models

a. hierarchical
b. file system
c. relational
d. XML Hybrid

A

XML Hybrid

20
Q

MySQL is an example of the _____

a. hierarchical model
b. file system data model
c. relational data model
d. XML data model

A

relational data model

21
Q

A (n) _____ enables a database administrator to describe schema components

a. extensible markup language (XML)
b. data definition language (DDL)
c. unified modeling language (UML)
d. query language

A

data definition language (DDL)

22
Q

The relational data model was developed in the _____

a. 1960s
b. 1970s
c. 1980s
d. 1990s

A

1970s

23
Q

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

a. hierarchical
b. network
c. object-oriented
d. entity relationship

A

entity relationship

24
Q

A (n) _______ enables a database administrator to describe schema components

a. extensible markup language (XML)
b. data definition language (DDL)
c. unified modeling language (UML)
d. query language

A

data definition language (DDL)

25
Q

The _____ model uses the term connectivity to label the relationship types

a. relational
b. network
c. object-oriented
d. entity relationship

A

entity relationship

26
Q

The _____ data model is said to be a semantic data model

a. relational
b. network
c. object-oriented
d. entity relationship

A

object-oriented

27
Q

The _____ data model uses the concept of inheritance

a. relational
b. network
c. object-oriented
d. entity relationship

A

object-oriented

28
Q

Which of the following types of HDFS nodes stores all the metadata about a file system?

a. Data node
b. Client node
c. Name node
d. Map node

A

Name node

29
Q

Which of the following is true of NoSQL databases?

a. They do not support distributed database architectures.
b. They are not based on the relational model.
c. They are geared toward transaction consistency rather than performance.
d. They do not support very large amounts of sparse data.

A

They are not based on the relational model

30
Q

Which of the following types of HDFS nodes acts as the interface between the user application and the HDFS?

a. Data node
b. Client node
c. Name node
d. Map node

A

Client node

ITC114 MCQ (7 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions