Chapter 7 test

Patricia, a database system manager for a large hotel chain, is setting up a relational database to track customer hotel registrations for each hotel. The table in the database currently includes fields (columns) for First Name, Last Name, Phone, Email, License Plate #, and Check-in Date. What can Patricia do to make sure that each record (row) in the database is unique? Designate the Phone field as the primary key. Designate the License Plate # field as the primary key. Combine the Email field and the Phone field to use as the primary key. Create an additional Check-in ID field.

Create an additional Check-in ID field.

The vast amount of data collected from Internet searches, social media posts, customer transactions, military surveillance, medical tests, weather sensors, and other data sources are collectively referred to as ________________. Omni Data Big Data Business Data Metadata

Big data

Vast amounts of data are collected and stored online based on internet searches, social media posts, customer transactions, military surveillance, medical tests, and weather sensors. What is this known as? Data analytics Data extraction Big Data Data mining

Big data

Which data model focuses on high-level concepts? Logical Physical Operational Conceptual

Conceptual

A NOT NULL __________ is a rule that prevents certain fields in a database from being left blank. scalability schema constraint query builder

Consraint

Which of the following are the four general tasks a user needs to perform for a database to function properly? Configure, Read, Update, Deny Create, Read, Unleash, Deny Create, Reuse, Unleash, Delete Create, Read, Update, Delete

Create, Read, Update, Delete

What is the general term for software that creates and manages databases? Microsoft Access Tables DBMS MySQL

DBMS

April is a database manager who wants to insert some new records (rows) into the company's customer contact database. Instead of using a database client to insert the records, she wants to use a command. Which of the following languages provides a command for inserting records into a database? DDL (Data Definition Language) DCL (Data Control Language) HTML (HyperText Markup Language) DML (Data Manipulation Language)

DML

Which type of analytical data can help you make investment decisions? Transactional Market Machine Sensor

Market

Which of the following DBMS programs is open source? Oracle Database MySQL Microsoft Access SQL Server

MySQL

What are non-relational databases that deal with Big Data often referred to as? NoSQL CRUD RDBMS SQL

NoSQL

A database administrator is setting up a new table that will contain customer information. The fields include name, address, company, phone, email, and customer ID. The administrator is using the customer ID to uniquely identify each customer record. Which of the following BEST describes the customer ID field? Private key Public key Foreign key Primary key

Primary Key

Which of the following is found in one or more columns of data and contains a unique identifier for the row? Primary key Foreign key Relationship Attribute

Primary key

Which of the following acronyms describes the traditional way to make sure data stays consistent across the entire database? SQL DBA ACID CRUD

ACID

Which command is used to add, change, or remove fields on an existing table? CREATE TABLE DROP TABLE INSERT INTO ALTER TABLE

Alter table

Which data type uses historical data to make decisions in the present? Logical Analytical Conceptual Operational

Analytical

Which of the following careers often requires that one works with sales and marketing teams to analyze and interpret performance data, create reports, and recommend ways to improve company processes? Database administrator Data analyst Database developer Data scientist

Data analyst

What is asking specific questions to interpret Big Data called? Data extraction Data analytics Data ethics Data mining

Data analytics

Which of the following careers is responsible for backing up and securing an organization's database? A. Data base developer B. Data base administrator C. Data scientist D. Data analyst

Data base administrator

The concern that Big Data is often obtained without the knowledge or consent of users falls under which Big Data concept? Data analytics Data extraction Data mining Data ethics

Data ethics

Which of the following needs to be done before Big Data can be analyzed and interpreted? Securing data Data extraction Data analytics Data mining

Data extraction

Which of the following is a way for programmers and others to make sense of complex business flows? Data modeling Database management system Primary keys Microsoft Access

Data modeling

What is the technology that aggregates structured data from one or more sources called? Relational Non-relational Big Data Data warehousing

Data warehousing

Which of the following careers typically requires programming expertise in languages such as java and python, in addition to skills in optimizing database systems? A. Data base developer B. Data base administrator C. Data scientist D. Data analyst

Database Developer

Which process exports a database into a format that can be read by another program like a spreadsheet? CSV Database backup Database dump CRUD

Database dump

In a relational database table, columns are better known as ________________. Categories Instances Records Fields

Fields

Which of the following should not be used as a primary key in a table? Username Social Security number First name Employee ID

First name

Marty, a database administrator, has added a foreign key to a table in a database. Which of the following describes the purpose of a foreign key? To allow the storage of unstructured data. To provide a way to distinguish records within a table. For one table to reference records in another table. For one database to reference another database.

For one table to reference records in another table.

A value that's used to identify a record from a linked table is called a ________________. Foreign Key Primary Key Linked Key Borrowed Key

Foreign Key

Which of the following makes it easier for users to enter data into their tables? Tables Forms Queries Reports

Forms

Which SQL command is used to give a user permission to a specific database object? UPDATE GRANT VALUES REVOKE

Grant

A developer is working on an application that needs to be able to read, write, update, and delete database records. Which of the following database access methods should the developer use? Query builder Programmatic access User interface access Direct access

Programmatic access

Which database object is essentially questions that we can ask the database? Forms Queries Reports Tables

Queries

Edward, a database user, would like to gather some specific information from a database and then manipulate the data in a spreadsheet. Edward then wants to save that information in a file format that will be used by another application. Which of the following database features would work BEST to accomplish this? Form Report Query Table

Query

Gina is a database user and her supervisor has asked her to generate a report from the structured database. Gina does not know how to write SQL commands and no forms have been created. Which of the following would be her BEST option to generate the report? User interface access Programmatic access Direct access Query builder

Query builder

Which of the following database features would provide a formatted, easy-to-read listing of the results of a query? Form Record Report SQL command

Report

Which of the following database objects provides a summary of data? Reports Forms Queries Tables

Reports

Mary needs to view the records from the Clients table that pertain to Travis. Which command should she use? UPDATE * FROM Clients WHERE name = Travis SELECT Travis FROM Clients SELECT * FROM Clients WHERE name = Travis SELECT ^ FROM Clients WHERE name = Travis

SELECT * FROM Clients WHERE name = Travis

What is the computer language that makes relational databases work? Java Python C++ SQL

SQL

Mary needs to view all records from the Clients table. Which command should she use? SELECT ^ FROM Clients WHERE * FROM Clients WHERE ^ FROM Clients SELECT * FROM Clients

Select*From clients

Which type of data have elements in common but do not fit into rigid rows and columns in a table? Semi-structured Non-relational Non-structured Structured

Semi-structured

An application developer needs to store configuration data that can be retrieved each time the application is launched. The data must be in a format that could be easily viewed outside of the application and edited using any editor. Which of the following would be the BEST choice? Database Management System Text-based flat file Relational database Binary flat file

Test based flat file

A business wants to set up a database to store customer and order information. They have decided to use a relational database. Which of the following is the main benefit of using a relational database? The data can be stored as unstructured data. The data is stored as a single file for quick retrieval. The data can be organized into separate tables that are related to each other. The data can be saved as a flat file.

The data can be organized into separate tables that are related to each other.

Which of the following careers requires advanced programming and analytical skills related to data mining and big data analytics? Database administrator Data analyst Database developer Data scientist

data scientist

Which of the following careers often requires expertise in mathematics and statistics to find relevant trends and patterns in data? A. Data base developer B. Data base administrator C. Data scientist D. Data analyst

database analyst

Report form table quary

select boxes.