C175 Ucertify Quiz 2

A(n) ______ represents a particular type of object in the real world. a. entity b. attribute c. node d. relationship

M:N relationships are not appropriate in a relational model.

From a database point of view, the collection of data becomes meaningful only when it reflects properly defined ______. a. business plans b. business rules c. business norms d. business goals

Which of the following types of HDFS nodes acts as the interface between the user application and the HFS? a. Map node b. Data node c. Client node d. Name node

Each column in a relation represents a(n) _______.

MySQL is an example of the ______. a. XML data model b. hierarchical model c. file system data model d. relational data model

In Chen notation, entities and relationships have to be oriented horizontally; not vertically True or False

An implementation-ready data model should contain a description of the data structure that will store the end-user data. True or False

In the context of data models, an entity is a person, place, thing, or event about which data will be collected and stored. True or False

A(n) ______ defines the environment in which data can be managed and is used to work with the data in the database.

A(n) ______ is a brief, precise, and unambiguous description of a policy, procedure, or principle within a specific organization

_____ are important because they help to ensure data integrity. a. relationships b. constraints c. attributes d. entities

Which of the following is true of business rules? a. they can serve as a communication tool between the users and designers. b. they provide a framework for the company's self actualization c. they allow the designer to set a company policies with regard to data d. they allow the designer to develop business processes.

NoSQL databases: a. are geared toward transaction consistency; not performance b. provide fault tolerance c. are based on the relational model d. support only small amounts of sparse data

Even when a good database blueprint is available, an applications programmer's view of the data should match that of the manager and the end user. True or False

A(n) ______ is bidirectional a. entity b. relationship c. constraint d. attribute

The network model has structural level dependence True or False

Students and classes have a ____ relationship a. many-to-many b. many-to-one c. one-to-many d. one-to-one

A(n) ______, is a collection of similar objects with a shared structure and behavior.

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

The object-oriented data model was developed in the _____. a. 1960s b. 1970s c. 1980s d. 1990s

A(n) _____ is the conceptual organization of an entire database as viewed by a database administrator

The relational data model was developed in the _____. a. 1990s b. 1980s c. 1970s d. 1960s

The hierarchical data model was developed in the ____. a. 1970s b. 1960s c. 1980s d. 1990s

Each row in a relation is called a(n) _____.

A(n) _____ is a restriction placed on the data. a. entity b. attribute c. constraint d. relationship

In the _____ model, the basic logical structure is represented as an upside-down tree a. hierarchical b. network c. relational d. entity relationship

In an SQL-based relational database, rows in different tables are related based on common values in common attributes. True or False

One of the limitations of the ______ model is that there is a lack of standards. a. network b. relational c. entity relationship d. hierarchical

Which of the following types of HDFS nodes stores all the metadata about a file system? a. Name node b. Map node c. Data node d. Client node

In _____, a three pronged symbol represents the "many" side of the relationship.

A(n) ____ in a hierarchical model is the equivalent of a record in a file system.

A data model is usually graphical True or False

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

Within the database environment, a data model represents data structures with the purpose of supporting a specific problem domain. True or False

Each row in the relational table is known as a(n) _____.

Business rules must be rendered in writing. True or False

Each row in the relational table is known as an entity instance or entity occurrence in the ER model. True or False

Oracle 11g is an example of the ______. a. hierarchical model b. XML/Hybrid data model c. relational data model d. file system data model

______ are normally expressed in the form of rules. a. entities b. relationships c. constraints d. attributes

The _____ data model is said to be a semantic data model a. entity relationship b. relational c. network d. object-oriented

A(n)_____ is a relatively simple representation of more complex real-world data structures.

The ______ model uses the term connectivity to label the relationship types. a. entity relationship b. object-oriented c. network d. relational

A(n)______ is the equivalent of a field in a file system. a. entity b. attribute c. constraint d. relationship

In object oriented terms, a(n) _____ defines an object's behavior.

Which of the following is a disadvantage of the hierarchical data model? a. it does not promote data integrity. b. it is not efficient with 1:M relationships c. it does not promote data sharing d. it does not have standards

Today, most relational database products can be classified as object/relational. True or False

In an SQL-based relational database, each table is dependent on every other table. True or False

An implementation-ready data model needn't necessarily contain enforceable rules to guarantee the integrity of the data. True or False

The ______ data model uses the concept of inheritance a. object-oriented b. entity relationship c. relational d. network

A(n) _____'s main function is to help one understand the complexities of the real world environment. a. database b. model c. entity d. node

The Hierarchical model is software-independent. True or False

A noun in a business rule translates to a(n)_____ in the data model. a. attribute b. relationship c. constraint d. entity

In the ____ model, each parent can have many children, but each child has only one parent a. network b. relational c. entity relationship d. hierarchical

the relational model's foundation is a mathematical concept known as a _______.

A(n) _____ is anything about which data are to be collected and stored. a. entity b. relationship c. constraint d. attribute

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

Business rules apply to businesses and government groups, but not to other types of organizations such as religious groups or research laboratories. True or False

A disadvantage of the relational database management system (RDBMS) is its inability to hide the complexities of the relational model from the user. True or False

Database designers determine the data and information that yield the required understanding of the entire business. True or False

A(n) _____ enables a database administrator to describe schema components. a. query language b. unified modeling language (UML) c. data definition language (DDL) d. extensible markup language (XML)

The relational model is hardware-dependent and software-independent. True or False

A verb associating two nouns in a business rule translates to a(n) ______ in the data model a. attribute b. relationship c. constraint d. entity

VMS/VSAM is an example of the _____. a. XML data model b. relational data model c. file system data model d. hierarchical model