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.