MIS EXAM 2 CHAPTER 5

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

Which of the following is a nonrelational data store developed by Google?

A) Bigtable

A(n) ________ is a program used to create, process, and administer a database.

A) DBMS

________ are used by users to read, insert, modify, and delete data in a database.

A) Forms

________ is the process of converting a poorly-structured table into two or more well-structured tables.

A) Normalization

Which of the following is an international standard language for processing a database?

A) SQL

Which of the following is true about the database development process?

A) The easiest time to change the database structure is during the data modeling stage.

Which of the following is true of N:M relationships?

A) They can have more than one entity on each side of the relationship.

________ are the final judges as to what data the database should contain and how the records in that database should be related to one another.

A) Users

The forked lines on the right side of a line on an E-R diagram that indicate a 1:N relationship between two entities are referred to as ________.

A) crow's feet

A data integrity problem will occur only if ________.

A) data are duplicated in a database

In a database, when data items disagree with one another, it leads to a(n) ________.

A) data integrity problem

In a data model, a(n) ________ is something that a user wants to track.

A) entity

Which of the following is used to process and display browser database application forms, reports, and queries?

A) html

A data model is a ________.

A) logical representation of database data

Which of the following refers to the problem that exists in database applications when two users modify the same data item, but only one of those changes is recorded?

A) lost-update problem

Browser applications are thin-client applications that ________.

A) need not be pre-installed on the users' computers

A(n) ________ is a request for data from a database.

A) query

The rows in a database are called ________.

A) records

In an E-R diagram, a line between two entities represents a(n) ________.

A) relationship

Browser-based applications ________.

A) support querying using graphics

In an E-R diagram, a(n) ________ on a line means that at least one entity of that type is required.

A) vertical bar

Which of the following is an example of a database management system?

B) Access

Which of the following is a nonrelational data store developed by Amazon?

B) Dynamo

Which of the following is true of single-user databases?

B) The application, the DBMS, and the database all reside on the user's computer.

Which of the following is the smallest data element in a database?

B) byte

In a database, ________ are grouped into columns.

B) bytes

A primary key used in a database is a ________.

B) column or group of columns that identifies a unique row in a table

An administrator should create a ________ before developing a database design.

B) data model

A ________ is a collection of forms, reports, queries, and programs that serves as an intermediary between users and database data.

B) database application

Brad, a project manager, wants to build a database to integrate information about employees and tasks that they handle. Brad wants to track information such as task name, percentage completed, and employee name. These aspects that Brad wants to track are called ________.

B) entities

The columns in a database are called ________.

B) fields

Which of the following data elements is placed higher than records in the database hierarchy?

B) file

Which of the following database administration tasks is related to adaptation?

B) managing configuration changes in systems

Every table in a normalized database has a ________.

B) single theme

________ is the process of converting a data model into tables, relationships, and data constraints.

C) Database design

A student management system allows students to have multiple majors, and advisers are assigned to handle multiple students and courses. This is an example of a(n) ________ relationship.

C) N:M

Which of the following is true of traditional database application programs?

C) They are written in object-oriented languages such as C++ and VisualBasic.

When using the relational model to represent two tables, one must ________.

C) add a foreign key to one of the tables

Which of the following is a developmental task of database administration?

C) creating and staffing the DBA function

Metadata are ________.

C) data that describe data

Identify the type of task that a database administrator is performing when validating the data model to be used in a database management system.

C) development

The tables that appear in a database are known as ________.

C) files

Columns that are keys to different tables than the ones in which they reside are called ________.

C) foreign keys

The database administrator of an organization constantly manages the processing rights and responsibilities of employees. This is an example of a(n) ________ task.

C) operational

________ is the term used to describe data collections that are characterized by huge volume, rapid velocity, and great variety.

D) BigData

Which of the following is true of MySQL?

D) It is license-free for most applications.

________ in an E-R diagram refer to the least number of entities required in a relationship.

D) Minimum cardinalities

Identify the open source DBMS product among the following.

D) MySQL

Browser-based applications ________.

D) are more vulnerable to security threats than are traditional applications

Entities in a data model have ________ that describe the characteristics of the entity.

D) attributes

Identify the first step in transforming a data model into a relational database design.

D) creating a table for each entity

A ________ describes the data and relationships that will be stored in a database.

D) data model

Relational databases represent relationships using ________.

D) foreign keys

Each entity in a database has a unique attribute called a(n) ________.

D) identifier

A database is required instead of a spreadsheet when ________.

D) lists involve data with multiple themes

Constraints on the number of entities in a relationship are called ________ cardinalities.

D) minimum

Albert creates a relational database to store employee performance statistics. He stores each employee's data in independent rows and creates a column named "Employee Number" to assign unique numbers to each employee. This column is referred to as a(n) ________.

D) primary key

When you modify or delete data present in a database, you are ________.

D) processing the database

Brenda, the sales manager of a firm, wants to generate a particular report containing sales analyses of the second and third quarter of the year. She should use a ________ to obtain the information that she wants from the database.

D) query

Which of the following formations on a line in an E-R diagram means that the relationship need not have an entity of that type?

D) small oval

Traditional database applications programs are ________.

D) thick applications that need to be installed on users' computers


Set pelajaran terkait

NC's - Marine Diesel Engines - Chapter 3 - Routine Maintenance

View Set

Chapter 19/6: FLORIDA REVIEW HEALTH

View Set

What is Life? Guided reading questions

View Set

intro to and history of astronomy

View Set

Ticket to Test/Prep U-Module 5,6,7

View Set