Chap 7 - IT Fund

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

A

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

A

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? A. Query B. Report C. Form D. Table

A

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? A. Query builder B. Direct access C. User interface access D. Programmatic access

A

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

A

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

A

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

A

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? A. Big Data B. Data extraction C. Data mining D. Data analytics

A

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

A

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

A

Which data type uses historical data to make decisions in the present? A. Analytical B. Conceptual C. Operational D. Logical

A

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

A

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

A

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

A

Which type of analytical data can help you make investment decisions? A. Market B. Machine C. Transactional D. Sensor

A

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? A. Direct access B. Programmatic access C. Query builder D. User interface access

B

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 ________________. A. Omni Data B. Big Data C. Metadata D. Business Data

B

What is asking specific questions to interpret Big Data called? A. Data mining B. Data analytics C. Data extraction D. Data ethics

B

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

B

What is the general term for software that creates and manages databases? A. MySQL B. DBMS C. Microsoft Access D. Tables

B

Which database object is essentially questions that we can ask the database? A. Forms B. Queries C. Tables D. Reports

B

Which of the following DBMS programs is open source? A. Microsoft Access B. MySQL C. SQL Server D. Oracle Database

B

Which of the following can be used to ask a database questions and receive the data we're looking for? A. Tables B. Queries C. Forms D. Reports

B

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. Database administrator B. Database developer C. Data scientist D. Data analyst

B

Which of the following database objects provides a summary of data? A. Forms B. Reports C. Queries D. Tables

B

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

B

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

B

Which type of data have elements in common but do not fit into rigid rows and columns in a table? A. Non-structured B. SEmi-structured C. Structured D. Non-relational

B

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? A. The data can be saved as a flat file. B. The data can be stored as unstructured data. C. The data can be organized into separate tables that are related to each other. D. The data is stored as a single file for quick retrieval

C

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? A. Public key B. Foreign key C. Primary key D. Private key

C

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? A. For one database to reference another database. B. To allow the storage of unstructured data. C. For one table to reference records in another table. D. To provide a way to distinguish records within a table.

C

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

C

Which data model focuses on high-level concepts? A. Operational B. Logical C. Conceptual D. Physical

C

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

C

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

C

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? A. Data scientist B. Database administrator C. Data analyst D. Database developer

C

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

C

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

C

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? A. Relational database B. Database Management System C. Binary flat file D. Text-based flat file

D

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

D

Which SQL command is used to give a user permission to a specific database object? A. REVOKE B. UPDATE C. VALUES D. GRANT

D

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

D

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

D

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

D

User-friendly interface for adding to or retrieving information from a database.

Form

Retrieves specific information from a database. Can also be used to update, edit, and delete information.

Query

Formatted summary of information from a database.

Report

Stores raw data in a relational database.

table