final
If you use an aggregate function in a query to determine the average values in a Bonus field, what default field name does Access use for the column with the calculations?
AvgOfBonus
Based on the table description and SQL shown, which query increases the FeeAmount by 2 percent? Fees ( FeeID, FeeType, FeeAmount )
UPDATE Fees SET FeeAmount = FeeAmount * 1.02;
Which SQL commands do you use to update the values of an existing field?
UPDATE and SET
Which of the following is a language for querying web-based documents and similarly structured data repositories?
XQuery
If you are creating a computed field that adds 10 percent to the UnitPrice field, how do you enter the UnitPrice field name in the expression?
[UnitPrice]
Which of the following is information that Google Analytics does not provide?
accessibility
What type of functions are Count, Sum, Avg, Max, and Min?
aggregate
What would you most likely use in SQL to perform calculations on groups of records?
aggregate functions
A(n) ________________ key is a candidate key not chosen ad the primary key.
alternate
If there is more than one possible choice for the primary key, and one of the possibilities is chosen to be the primary key. What are the others called?
alternate keys
In object-oriented technologies, what is a class?
an object that functions as a blueprint for more objects
What is the primary focus of the latest emerging careers in the database industry?
analysis of internal, external, and big data
Which of the following is not a database policy area that database administrators typically are responsible for?
analyzing sales and expenses
Which of the following tasks is a data analyst likely to perform?
apply an algorithm to find sales trends
What is a column that you create for an entity to serve solely as the primary key and that is visible to users?
artificial key
What technique is used to identify the person who is attempting to access the DBMS?
authentication
What type of rules specify user privileges to select, insert, update, and delete data for different tables and views?
authorization
The normalization process is a series of steps that will automatically restructure your database to resolve design flaws. T/F
b. false
Because _____ read and write files as well as communicate with a centralized database, they run on a server.
back-end technologies
Which of the following is not a common security feature used by database management systems?
backward recovery
A(n) _____ is a special data type for complex data such graphics, drawings, photographs, video, and sound.
binary large object (BLOB)
Which authentication tool identifies users by physical characteristics such as fingerprints, voiceprints, handwritten signatures, and facial characteristics?
biometrics
Which of the following does a data analyst typically work with?
business transactions
If a many-to-many-to-many relationship is created when it is not appropriate to do so, how can the problem be corrected?
by converting to 4NF
With the table Orders (OrderNum, OrderDate, (ItemNum, NumOrdered) ) where OrderNum is the primary key, how would you convert the table to first normal form?
by making the primary key a combination of OrderNum and ItemNum
When a DBMS cannot enforce data and access restrictions, how should they be enforced?
by peripheral programs written to access the database
What is each key that meets the criteria for a primary key called?
candidate key
Which of the following is a column or collection of columns on which all columns in the table are functionally dependent?
candidate key
In IDEF1X terminology, what is a subtype called?
category
Google searches and social media postings that direct traffic to a website are known as _____.
channels
In the Pitt Fitness database, which attribute uniquely identifies each class?
classID
What do you call a setup where Microsoft Access is stored on a file server and three trusted users access the database from their local computers?
client/server architecture
Which of the following could be described as a contemporary implementation of centralized architecture?
cloud computing
What is an alternate key?
column that could be a primary key but was not chosen
As you design the user view, which aspect of the table are the properties of the entities you choose?
columns
What is an entity that can serve as the relationship between other entities called?
composite entity
A ____________________ in a record is the result of a calculation using data from the rest of the record .
computed field
When you can determine the value of a field using information from existing fields in a record in a query, you should create a(n) _____.
computed field
What type of database update occurs when multiple users make updates to the same database at the same time?
concurrent
An interrelation ____________________ is a condition that involves two or more relations.
constraint
The acronym CRUD stands for _____.
create, read, update, and delete
In relational algebra, which command retrieves rows from a table based on specified criteria?
SELECT
When you create a query using SQL View to display fields and records, Access automatically places the _______________ keyword in the query window.
SELECT
Which query will return the number of rows from the Customers table where the State field is 'AZ'?
SELECT COUNT(*) FROM Customers WHERE State='AZ';
What SQL command do you use to make changes to existing data in a table?
UPDATE
Which of the following features does an enterprise-level DBMS use to avoid the costly and time-consuming task of having users redo their work?
journaling
JSON data is shared in _____.
key/value pairs
If you want to constrain a Bonus field to the values 250, 500, and 750, what type of constraint should you apply?
legal values
In an OODBMS, a( n) _____ is a set of related attributes along with the actions that are associated with the set of attributes.
object
Which Microsoft Access tool helps you identify all objects dependent on a particular table, query, form, or report?
object dependencies
If each employee works in a single department and each department has several employees, what is the relationship between departments and employees?
one-to-many
Which database technology optimizes data for querying, analyzing, and reporting?
online analytical processing (OLAP)
A _____ is a duplicate instance of a single, shared database to balance the workload among CPUs.
parallel database system
In Access, if you want to be able to enter different criteria each time you run a query, create a(n) _____ query.
parameter
Second normal form can be defined as a table that is in first normal form but that contains no ____.
partial dependencies
What do data scientists typically look for as they analyze data?
patterns and trends
Which of the following database professionals is most likely to manage indexes?
performance analyst
A column is a nonkey column if it is not a part of the ____________________.
primary key
In Access, what uniquely identifies a row in a table?
primary key
When the ____________________ of a table is a single column, the table is automatically in second normal form.
primary key
Which of the following can be defined as a column (or collection of columns) A such that all other columns are functionally dependent on A and no subcollection of the columns in A has this property?
primary key
Which term's definition also defines a candidate key?
primary key
What do key integrity constraints consist of?
primary key and foreign key constraints
If you are sorting records by more than one field, which field is the first field that is evaluated for sorting purposes?
primary sort key
The hardware, software, and database that users and regular applications of the company use is called the _____.
production system
A _____ is a question about the data structured in a way that the DBMS can recognize and process.
query
Which term can be described as the duplication of data and storing data in multiple locations?
redundancy
A database that enforces _____ prevents users from creating orphan records.
referential integrity
A(n) _____ can store information about multiple types of entities and the relationships among the entities.
relational database
Which of the following is not one of Codd's 12 rules for distributed databases?
reliance on a central site
What do you call the log of all database maintenance, with information such as dates, license keys, and issues or updates?
run-book
Which of the following is generally not considered a source of big data?
sales transactions
When implementing the physical-level design, for secondary keys, you must ensure that it is possible to retrieve data rapidly based on a value of which key?
secondary
Which of the following is an authentication tool in which information used to identify a user is stored on a physical card?
smart card
Git and GitHub operate on what type of distributed database model?
snapshot
A(n) _____ contains software components that are well documented and have a proven track record of working well together.
solution stack
The field you use to sort records is called the _____.
sort key
What do organizations install to detect and stop cyberattack threats at the point of attack?
spyware/malware detection software
Which of the following is not a technology that a data warehouse administrator typically manages?
spyware/malware detection software (SMDS)
Which of the following positions is a typical prerequisite for a data scientist?
statistician
Which of the following is not a typical qualification for a data analyst?
strong graphic design skills
When a SQL statement consists of two queries and you place one query inside another, the inner query becomes a(n) _____.
subquery
When you place one query inside another, the inner query is called a(n) ___________________ and is evaluated first.
subquery
Which type of key is usually an automatic numbering data type, such as the Access AutoNumber data type?
surrogate
What type of primary key is system-generated and is usually hidden from users?
surrogate key
What do you call applying and reconciling updates from various copies of a database with the master copy?
synchronization
Which database professional primarily focuses on system administration such as installation, performance, and maintenance ?
system DBA
If you convert a collection of tables to an equivalent third normal form collection of tables, what problems do you remove?
those arising from functional dependencies
In an enterprise-level DBMS, e ach task that a user completes, such as selecting a product for an order, is called a _____.
transaction
A foreign key is a column or collection of columns in one table that is required to match the value of the primary key for some row in another table, or be null. T/F
true
A table is in fourth normal form (4NF) when it is in third normal form and there are no multivalued dependencies. T/F
true
A table that is in first normal form may contain problems that will require you to restructure it. T/F
true
A weak entity is an entity that depends on another entity for its own existence. T/F
true
An interrelation constraint is a condition that involves two or more relations. T/F
true
If you find that more than one table in your cumulative design has the same primary key, you should combine the tables to form a new table. T/F
true
Tables that are in second normal form can still contain redundancy problems. T/F
true
Tables without repeating groups are said to be in first normal form. T/F
true
The basic relationships among entities are: one-to-many, many-to-many, and one-to-one. T/F
true
The information-level design methodology is completed independently of any particular DBMS that the organization will ultimately use. T/F
true
The simplest way to implement a one-to-one relationship is to treat it as a one-to-many relationship. T/F
true
Third normal form is sometimes referred to as the Boyce-Codd normal form. T/F
true
When combining third normal form tables, the resulting table will not be in third normal form when a column A in one user view determines a column B in a second user view, yet column A is not a column in the second user view. T/F
true
When determining the primary key of a table you must decide what properties are required to uniquely identify an entity. T/F
true
When the user views are not clearly defined, you should consider each stated requirement as a separate user view. T/F
true
You create a many-to-many relationship by creating a new table whose primary key is the combination of the primary keys of the original tables. T/F
true
Which database term refers to a row in a table?
tuple
In what type of SQL operation must two tables have the same field structure?
union
What is a table that contains a repeating group called?
unnormalized relation
What type of Access query changes data?
update
What do you call a data inconsistency that results from data redundancy or the use of inappropriate nulls?
update anomaly
For which of the following tasks is data independence not a consideration?
updating a record
Which of the following does a DBMS log typically not include for each transaction?
user responsible for the transaction
Which of the following is a set of requirements that is necessary to support the operations of a particular database user?
user view
Which of the following is information that Access system catalogs do not maintain?
users, user groups, and privileges
Which of the following is not a defining characteristic of big data?
virtual
In cloud computing, although many clients share the same resources, a company's systems operate as if they were running on their own dedicated system because of _____.
virtualization
When are nulls used?
when a value is inapplicable
When is a 1NF table automatically a 2NF table?
when the primary key contains only a single column
While not always required, how should you end an SQL command?
with a semicolon (;)
How does Access handle concurrent updates?
with record-level locking
A _____ is a one-page grouping of key performance indicators (KPIs) that allow decision makers to evaluate and act on important data.
dashboard
A _____ completes the statistical and graphical analysis of internal data such as sales figures and operational expenses to help an organization make faster and better decisions.
data analyst
In a large business, who mines a database for information, trends, and insights?
data analyst
Which of the following is one of the most identifiable entry-level database industry job titles?
data analyst
Some enterprise-level systems refer to the catalog as the _____.
data dictionary
Which of the following is information that the Access Database Documenter does not provide?
data in each field
Which concept of a DBMS means that you change the database structure without requiring you to change the programs that access the database?
data independence
What type of constraints help to ensure the accuracy and consistency of field values?
data integrity constraints
A(n) _____ analyzes massive sets of internal, external, and big data to help an organization make faster and better decisions.
data scientist
Which of the following database professionals uses programming algorithms and applies statistics to analyze large sets of data?
data scientist
Which of the following database professionals would focus on how large-scale research produces better products?
data scientist
Which of the following is a relatively new career in the database industry?
data scientist
Which type of data integrity constraint states that the value entered for any field should be consistent with the data type for that field?
data type
Which of the following database professionals most likely helps others understand patterns in data in formats other than lists, summarized reports, and other statistical presentations?
data visualization expert
Which of the following is not a typical qualification for a data scientist?
data visualization skills
You use OLAP software to access a(n) _____.
data warehouse
Which of the following is generally not considered a traditional business operation for all sizes of businesses?
data warehousing
Which of the following is not a major category of responsibility for typical database administrators?
data-entry management
What is the term for a collection of data organized in a manner that allows access, retrieval, and use of the data?
database
In an organization, who is usually responsible for improving databases to provide efficient and effective access to their information?
database administrator (DBA)
Which of the following database professionals most likely uses SQL to s ummarize and analyze data to extract trends, insights, and knowledge?
database analyst
During which phase does a database developer create the entities, attributes, and relationships between the tables of data?
database design
Which of the following is not a typical area that a database operations manager focuses on?
database performance
When you normalize a table by breaking down the relations into progressively finer levels of detail, it is called_____________________.
decomposition
In Access a (n) _____ query permanently removes all the records from the selected table(s) that satisfy the criteria entered in the query.
delete
What type of query could you run to remove records with a product ID of 702 from the Products table?
delete query
What type of diagram uses arrows to indicate all the functional dependencies present in a table?
dependency diagram
A table that contains a ________________ that is not a candidate key indicates the table is not in third normal form.
determinant
Any column or collection of columns that determines another column is called a(n) ___________________.
determinant
Which of the following is typically not a requirement for a successful career as a database administrator?
direct contact with customers
In a one-to-many relationship, the primary key of the "many" table becomes the foreign key of the "one" table. T/F
false
In an entity-relationship diagram, rectangles represent foreign keys. T/F
false
The first step in creating a user view is to normalize the collection of tables. T/F
false
When converting a non-first normal form table to first normal form, the foreign key will usually include the original foreign key concatenated with the key to the repeating group. T/F
false
When you combine third normal form tables, the result will always be in third normal form. T/F
false
According to the Bureau of Labor Statistics, what is the job growth outlook for database administrators?
faster than average
In a _________ environment, data is partitioned into several disjointed systems, lists, and files.
flat-file
What do you call t he field used to join two tables on the "many" side of a one-to-many relationship?
foreign key field
In DBDL documentation, what element of a table is followed by an arrow pointing to the table identified by the element?
foreign keys
Which of the following is a screen object used to maintain and view data from a database?
form
Which of the following are screen objects used to maintain, view, and print data from a database?
forms
When you run a recovery program that applies the after images of committed transactions from the log to bring a database up to date, what method of recovery are you using?
forward recovery
A _____ is a set of standards, development tools, and software libraries that help programmers develop software solutions faster and with more consistency.
framework
A column B is ____________________ on another column A if each value for A in the database is associated with exactly one value of B.
functionally dependent
Which of the following types of NoSQL database systems are commonly used for artificial intelligence (AI) applications?
graph database
In an Access query, a "group" of records _____.
has the same value in a particular field
What do you call an arrangement of location data with three levels, such as cities within states within countries?
hierarchy
What is a relationship that is necessary for identification?
identifying relationship
Which of the following is a responsibility of a database administrator?
improving the efficiency of a database
In the Access QBE, where do you specify criteria for a query?
in the Criteria row of the query design grid
If an entity represented in a supertype table is not represented in the subtype table, what is this called in IDEF1X terminology?
incomplete category
Which of the following is a problem that data redundancy causes?
increased data errors and inconsistencies
The crucial issue in making the determination between a single many-to-many-to-many relationship and two (or three) many-to-many relationships is the ____.
independence
What is an entity that does not require a relationship to another entity for identification?
independent entity
Which type of rule prevents the creation of orphan records?
integrity constraint
What type of key is also called a logical key?
intelligent
The database architect focuses on database design. T/F
True
The first substep in representing the user view as a collection of tables is to determine entities and create a table for each. T/F
True
The primary task of a database administrator (DBA) is to ensure that a database is available as needed and is protected and secured from unauthorized users and activities. T/F
True
To correct anomalies in a database, tables must be converted into various types of normal forms. T/F
True
_____ the design of a database includes creating and deleting indexes, minimizing the complexity of each view, and changing the table design.
Tuning
Which of the following is NOT true about a relation, otherwise known as a two-dimensional table?
Two or more columns can share the same name.
Big data typically keeps track of common business transactions, such as accounts receivable and payroll. T/F
False
Database security can be defined as prevention of changes to the structure of a database. T/F
False
Fields appear in alphabetical order based on fieldname in the query results of a SELECT clause. T/F
False
One of the key services of a DBMS is to analyze overall hard drive usage. T/F
False
SQL uses an on-screen form to create tables, update tables, and retrieve data from tables. T/F
False
The data in a data warehouse is often made available to users through the direct use of SQL SELECT statements. T/F
False
To select data from more than one table at the same time, you need to perform a make-table query. T/F
False
When you connect query conditions using the AND operator, only one of the conditions must be true for a particular record to be selected. T/F
False
If you want to select records containing the text Consulting in the ProjectType field, how does Access save the criterion in the query grid of Query Design View?
"Consulting"
Which of the following is a database-as-a-service product?
Amazon Relational Database Service
What Access tool can you use to find and fix corrupt data within a database?
Compact and Repair
How are compound SQL criteria conditions formed?
Compound SQL criteria conditions are formed using the AND and OR operators.
What is the correct order of steps in the information-level design method?1. Normalize the tables.2. Represent the user view as a collection of tables.3. Merge the result into the cumulative design.4. Represent all keys.
2, 1, 4, 3
The Clients table contains 12 records with three different values in the PostalCode field. If you create a query that groups the records based on the PostalCode field, how many records do the results contain?
3
Which of the following criteria selects all records containing a value greater than 250?
>250
What is the difference between a third normal form and fourth normal form table?
A 4NF table has no multivalued dependencies.
What is a nonkey column?
A column that is not part of the primary key.
Microsoft Access is well-suited to which of the following cases?
A few trusted users work with the database at the same time.
If B is functionally dependent on A, what can you also say?
A functionally determines B
An alternative to the primary key of a table is listed with which abbreviation in DBDL?
AK
If you use ____________________ criteria, each criterion must be true for a record to be selected .
AND
You can create compound criteria (conditions) in a query by using which of the following two keywords?
AND, OR
What happens when you run a select query in Access?
Access selects current data from underlying tables.
Which of the following is not software that is primarily used for data visualization?
Adobe Dreamweaver
How are aggregate functions different from other types of functions?
Aggregate functions make calculations on groups of records.
A(n) _________________________ is a set of rules, calculations, and assumptions used to solve a problem.
Algorithm
For a one-to-many relationship in the Access Relationships window, how can you tell which table is the "many" table?
An infinity symbol identifies the "many" table.
Which of the following is not a high-level programming language?
Assembler
Which function calculates the number of records in a table?
COUNT
Which of the following operators allows you to specify a range and is often used with date criteria?
BETWEEN
_____ is a large set of nontraditional data that may be used to gain meaningful business insights or predict significant business events.
Big data
_________________________ describes the large volume of data produced by every digital process, system, sensor, mobile device, and even social media exchange.
Big data
In the Pitt Fitness database, which of the following attributes belongs in the Customers table?
BirthDate
_____ is a popular website for hosting projects that use the Git language for version control.
BitBucket
Convert the following table to first normal form:Branch (BranchNum, BranchName, (BookCode, Title, OnHand) ) where BranchNum is the primary key
Branch (BranchNum, BranchName, BookCode, Title, OnHand ) where BranchNum and BookCode make the primary key
Which statement creates a table named PostalCodes with a five-character PostalCode text field and a two-character Abbrev text field?
CREATE TABLE PostalCodes (PostalCode TEXT (5), Abbrev TEXT (2));
In the Pitt Fitness database, which table relates classes and instructors?
ClassInstructors
In the Pitt Fitness database, you can determine which instructor is assigned a particular class by looking in the ____________________ table.
ClassInstructors
The Access query design grid contains the ProductID, ProductName, and Rating fields. How can you omit the Rating field from the query results but use it to set a criterion for the query?
Clear the checkmark from the Rating field's Show check box.
In Access Query Design View, how do you add the Total row to the query design grid?
Click the Totals button on the Query Tools Design tab.
Which of the following will be an entity in the JC Consulting database?
Clients
_____ occurs when multiple users make updates to the same database at the same time.
Concurrent update
Which of the following Access functions can you use to return the number of records in a group of records?
Count
Which of the following is a metalanguage designed for the exchange of data on the web?
XML
Which part of a SQL query specifies the table names that contain the data you want to display in the query results?
FROM clause
A data analyst is generally responsible for improving the performance of a database T/F
False
What type of software programs are Access, Oracle, DB2, MySQL, and SQL Server?
DBMSs
A database administrator (DBA) usually reports directly to the chief financial officer (CFO). T/F
False
A good name for an Access table might be tbl!Student. T/F
False
Which of the following is a drawback of flat files?
Data partitioned into several separate files can be difficult to summarize.
_____ represents information in the form of a chart, diagram, or picture.
Data visualization
_____ refers to the hardware and software an organization needs to address the analytical requirements of users without detracting from traditional operations.
Data warehouse architecture
_____ means that a copy of a database is distributed to other computers or locations.
Database replication
In Access Query Design View, which of the following expressions calculates the number of days between today's date and a field named DueDate?
Date() - [DueDate]
Which of the following is a technique for increasing the speed of Access queries?
Delete field lists that are not needed for the query.
Consider the following two tables where EmployeeNum is primary key in both tables. What is the result of combining the two tables?Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum)Employee (EmployeeNum, LastName, FirstName, Street, City, State, PostalCode)
Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum, Street, City, State, PostalCode)
Which of the following fields would be the best candidate for a primary key field in a table of employee data?
EmployeeID
When you use a name containing a space in Access SQL, what must you do to specify the table or column name?
Enclose it in [square brackets]
Which of the following is not a common service provided by a database management system?
Format user views, forms, and reports.
_____ means that when using a distributed database, users feel that the data they work with comes from a single central database.
Fragmentation transparency
What acronym refers to the traditional business operations of general ledger, accounts payable, and payroll ?
GLAPPR
Which of the following SQL statements allows a user named mgarcia to select, insert, update, delete, and create a constraint in the Products table?
GRANT ALL ON Products TO mgarcia;
Which of the following demonstrates the concept of a distributed database?
Git
In a query that uses an aggregate function, which SQL clause do you use to include criteria that limits the number of records selected for the query?
HAVING
_____ are actions that are performed on resources or files at the server.
HTTP methods
Data visualization is not a feature of which software product ?
Hadoop
Which of the following is a technology that data scientists use to store and analyze big data?
Hadoop
Which of the following is not a programming language commonly used by data scientists?
Hadoop
_____ is an open source distributed processing framework for managing and processing very large sets of data.
Hadoop
Which of the following laws does not govern data access, retention, and destruction?
Hatch Act
In Access SQL, which operator could you use to list all fields from a Customers table where the City field is Madison, Middleton, or Belleville?
IN
What SQL command do you use to add new data to a table?
INSERT
What SQL keyword do you use in a query that saves the results of the query as a table?
INTO
In the Pitt Fitness database, how can you determine the number of classes offered on Tuesday?
In the Classes table, count the occurrences of Tuesday in the Day column.
In the Sports Physical Therapy database, how can you determine which therapist provided the longest amount of time to complete a particular service?
In the Session table, find the highest value in the LengthOfSession column.
In the Sports Physical Therapy database, how can you determine the number of sessions completed by therapist Steven Wilder?
In the Therapist table, find the TherapistID for Steven Wilder, and then count the number of times his TherapistID appears in the Session table.
In the Pitt Fitness database, which of the following is an attribute in the Instructors entity?
InstructorCity
Compare traditional database careers with new emerging database careers.
In traditional database careers you were involved in designing the database, now in new emerging careers the databases are likely already designed.
Which Access feature restricts a field to a special format for entering data?
Input Mask
Which of the following is a characteristic of a table that is in first normal form?
It doesn't contain repeating groups.
What is a goal of a distributed database?
It should feel and work like a single database to users.
_____ is a format for storing and transporting data often used when data is sent from a server to a webpage.
JavaScript Object Notation (JSON)
Which of the following is a popular software stack?
LAMP
Which of the following is considered a very popular, open source, back-end software stack?
LAMP (Linux, Apache, MySQL, PHP)
In Access SQL, which operator do you use in the WHERE clause when you want to include a wildcard in the criterion?
LIKE
Which of the following statements is true about selecting a DBMS?
Large businesses are unlikely to switch from one DBMS to another because they have already made significant investments in their systems.
What type of Excel chart compares values across geographical locations?
Map Chart
Which of the following contains a repeating group where the primary key is OrderNum?
Orders (OrderNum, OrderDate, (ItemNum, NumOrdered) )
Discuss the steps that organizations take to protect their data against hard drive failures and electrical power interruptions or outages.
Organizations set up a disaster recovery plan and archive the data so their are back ups.
Which of the following expressions in Access Query Design View creates a computed field named MonthlySalary using a value from the Salary field?
MonthlySalary: [Salary] / 12
What do you call the prediction that the number of transistors on a chip is likely to double every two years?
Moore's Law
Which of the following is not one of the top five database certifications?
MySQL Certified Database Analyst
Which of the following is not a type of NoSQL database system?
OLAP database
Which of the following SQL commands sorts records by ProductName within ProductType?
ORDER BY ProductType, ProductName
Explain the requirements of two sets of records involved in a union.
One requirement for two sets of records involving a union is that they have the same primary key.
In relational algebra, what command is used to identify certain columns?
PROJECT
Based on the following table, which relational algebra command creates a new table named CustState containing the fields CustomerNum and State?Customer (CustomerNum, CustomerName, Street, City, State, PostalCode)
PROJECT Customer OVER (CustomerNum, State) GIVING CustState
In Access, if you want a query to list the ProductID, Category, and Description field values and sort the records by description within each category, how should you arrange the fields from left to right in the query design grid?
ProductID, Category, Description
Which of the following is a data visualization tool that typically summarizes data from three or more fields?
PivotChart
Which of the following is not true about the database industry?
Positions as a data analyst or data scientist continue to grow, but not other database fields.
Which of the following is not a common data file format that database management systems use to export data?
PowerPoint presentation (PPTX)
How can you improve your SQL skills?
Practice using online SQL tutorials.
Which of the following SQL statements rescinds privileges for user kchen05 to create constraints and delete data in the Customers table?
REVOKE REFERENCES, DELETE ON Customers TO kchen05;
_____ is the process of returning a database that has encountered a problem to a state known to be correct.
Recovery
Which of the following Access tools shows the database schema?
Relationship report
Based on the SQL shown, which query finds how many items are in the TOY category? Items (ItemNum, Description, OnHand, Category, Storehouse, Price )
SELECT COUNT(*) FROM Items WHERE Category='TOY' ;
Based on the following notation, which relational algebra command would list all information from the table concerning the customer with numeric CustomerNum 260? Customer (CustomerNum, CustomerName, Street, City, State, PostalCode)
SELECT Customer WHERE CustomerNum=260 GIVING Answer
Based on the SQL shown, which query lists the name and balance of all customers with balances greater than or equal to $2,000 and less than or equal to $5,000? Customers ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )
SELECT CustomerName, Balance FROM Customers WHERE Balance BETWEEN 2000 AND 5000;
Based on the SQL shown, which query lists the name and available credit for all customers with credit limits that exceed their balances? Customers ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )
SELECT CustomerName, CreditLimit - Balance AS AvailableCredit FROM Customers WHERE CreditLimit > Balance;
Based on the table description and SQL shown, which query finds the description and price of the items that have a Price field value greater than Wireless charger, ItemNum W208? Items (ItemNum, Description, OnHand, Category, Storehouse, Price )
SELECT Description, Price FROM Items WHERE Price > (SELECT Price FROM Items WHERE ItemNum = 'W208');
Based on the table description and SQL shown, which query lists the first name and last name of all students, separated by a space? Students (StudentID, FirstName, LastName, Street, City, State, PostalCode)
SELECT FirstName & ' ' & LastName AS FullName FROM Students;;
Based on the SQL shown, which query lists the last names and bonuses of employees who have a Bonus field value greater than Juliana Suarez, EmployeeID 14? Employees ( EmployeeID, LastName, FirstName, HireDate, JobTitle, Bonus )
SELECT LastName, Bonus FROM Employees WHERE Bonus > (SELECT Bonus FROM Employees WHERE EmployeeID = '14') ;
Based on the SQL shown, which query selects the LastName, JobTitle, and increased bonus for all employees with a job title of SalesRep? The increased bonus is calculated as $100 more than the current bonus. Employees ( EmployeeID, LastName, FirstName, HireDate, JobTitle, Bonus )
SELECT LastName, JobTitle, Bonus + 100 AS IncreasedBonus FROM Employees WHERE JobTitle = 'SalesRep';
Which of the following SQL statements selects ProductDescription and Price fields for every record in the Products table with a Price value greater than $50.00?
SELECT ProductDescription, Price FROM Products WHERE Price > 50;
Based on the SQL shown, for each sales rep, which query lists the rep number, the number of customers assigned to the rep, and the average balance of the rep's customers? Group and order the records by rep number. Customers ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )
SELECT RepNum, COUNT(*), AVG(Balance) FROM Customers GROUP BY RepNum ORDER BY RepNum;
Based on the table description and SQL shown, which query lists the states in the Students table and displays the number of students from each state? Students (StudentID, FirstName, LastName, Street, City, State, PostalCode)
SELECT State, COUNT(*) AS CountOfState FROM Students GROUP BY State;
Which of the following is currently considered the most sought-after language for programmers?
SQL
Which of the following is a popular relational database management system?
SQL Server
Why is SQL a highly sought-after language for programmers?
SQL is a universal language for selecting and maintaining data in a relational database.
In an Access query, how can you list records in A-Z order by last name?
Set an ascending sort order on the LastName field.
Explain how to use three SQL clauses to select fields and join tables using the WHERE keyword in SQL.
Select * From table Inner join table where id=id
In the Sports Physical Therapy database, which table determines which therapist provided a service to a patient?
Session
In the Sports Physical Therapy database, which table stores the date of an interaction between a patient and a therapist?
Session
In the Sports Physical Therapy database, which attribute uniquely identifies each therapy session?
SessionNum
List five access data types
Short text, long text, number, data/ time, currency, yes/no, autonumber
In the Pitt Fitness database, what can you learn by examining the ClassInstructors data?
Some classes use more than one instructor.
Which of the following is a reason to store business data in a database rather than a spreadsheet?
Spreadsheets have limited data sharing and security features.
Which aggregate function do you use to total the values in a numeric field in a group of records?
Sum
What type of Excel chart would you create to compare the relative amount of sales between different categories of products within different regions as proportionally sized rings?
Sunburst chart
What is the DBA's role with regard to access privileges?
The DBA decides who to give access privileges to using GRANT
Suppose you have the following two tables where EmployeeNum is the primary key in both tables. What can you say about the EmployeeBuilding table?Employee (EmployeeNum, LastName, FirstName)EmployeeBuilding (EmployeeNum, BuildingName)FK EmployeeNum -> Employee
The EmployeeBuilding table is a subtype of the Employee table.
What does it mean when an entity has a minimum cardinality of zero?
The entity is not required in the relationship.
What does it mean when an entity has a minimum cardinality of one?
The entity is required in the relationship.
Describe the role of the data scientist in an organization, including technology businesses.
The role of data scientists in an organization is to analyze large sets of data.
After the information-level design is completed, what is the next step?
The physical-level design
In general, what should be in place before you select fields from more than one table in Access Query Design View?
The tables should be related in a proper one-to-many relationships.
What is a potential problem, if any, if you design a database in which the last name of a consultant functionally determines the consultant's address?
There could be more than one consultant with the same last name.
Describe what a data visualization expert does to support an organization's efforts.
They are able to create charts and graphs so people can better understand and visualize the data.
Which normal form has an additional condition that the only determinants the table contains are candidate keys?
Third
In Microsoft Access, you can identify all the objects that depend on a particular query, as well as all the objects that the query depends on. T/F
True
In a centralized database architecture, a single, centrally located computer system processes all data. T/F
True
Many database management systems maintain catalogs of information as special, hidden tables. T/F
True
Microsoft Access allows concurrent updates to different records of the same table. T/F
True
Microsoft Access uses Query Design View as a QBE. T/F
True
NoSQL database system refers to "not only SQL." T/F
True
Redundancy makes changing data more cumbersome and time-consuming. T/F
True
Redundancy refers to the duplication of data, or the storing of the same data in more than one place. T/F
True
Some organizations use legacy programs for years to avoid the time and effort of converting to a new system. T/F
True
An entity is a person, place, event, item, or other transaction for which you want to store and process data. T/F
True
Data scientists look for patterns and trends in data to discover new opportunities and solutions. T/F
True
In Access SQL, you use the asterisk (*) as a wildcard character to represent any number of characters. T/F
True
In Access, you can display the results of a select query using the Run button or the View button. T/F
True
The attributes of an entity become the fields or columns in a table. T/F
True
Which Microsoft Access feature do you use to set legal value constraints?
Validation Text property
What SQL command can you use to join two tables?
WHERE
Which SQL keyword can you use to join two tables that have a one-to-many relationship?
WHERE
Which command joins the related Customers and Orders tables based on the common CustomerID field?
WHERE Customers.CustomerID = Orders.CustomerID
What do two tables use to link related records from each table?
a common field
In Microsoft Access, what do you need to decrypt an encrypted database?
a password
A _____specifies the ongoing and emergency actions and procedures required to ensure data remains available if an event such as a cyberattack or hurricane occurs.
disaster recovery plan
A _____ is a single logical database that is physically divided among computers at several sites on a network.
distributed database
Which of the following does not describe the data in a data warehouse?
dynamic
How are entities represented in a relational database?
each entity is stored as a table
Which of the following is an example of an enforcing restriction?
ensuring values in foreign keys are legitimate
Which of the following is a visual way to represent and analyze a database?
entity-relationship (E-R) diagram
To support data independence, you should _____ in an SQL SELECT command.
explicitly list all the required fields
A column is a nonkey column when it is part of the primary key. T/F
false
A design that supports all user views is called a constructive design. T/F
false
A relational database handles entities, attributes, and relationships by storing each entity in its own row. T/F
false
A surrogate key is a primary key that consists of a column that uniquely identifies an entity. T/F
false
After you have completed the first two steps for a given user view, you can merge the results into the cumulative design. T/F
false
An attribute is known as a row in most databases. T/F
false
Any row that determines another row is called a determinant. T/F
false
Converting to third normal form always avoids the problems related to dependencies. T/F
false
Functional dependencies can always be determined by looking at sample data. T/F
false
If column B is functionally dependent on column A, you can also say that column B functionally determines column A. T/F
false
If each employee works in a single department, and each department has only one employee, the relationship between employees and departments is a one-to-many relationship. T/F
false
If no unique identifier is available for an entity, you can go without one. T/F
false
If the primary key of a table contains only a single column, the table is automatically in third normal form. T/F
false
In the Sports Physical Therapy database, you determine the description of the therapy a patient is receiving by finding the TherapyCode for the patient in the Session table, and then _____.
looking up the TherapyCode in the Therapies table
What type of Access query creates a new table using the query results?
make-table
What is the term used in an E-R diagram that specifies the maximum number of entities that can participate in a relationship?
maximum cardinality
In a database catalog, _____ includes information about table relationships, views, indexes, and properties.
metadata
On an E-R diagram, what does the number closest to the relationship represent?
minimum cardinality
A table is in fourth normal form when it is in third normal form and there are no ________________ dependencies.
multivalued
What are five restrictions placed on table and field names in Access?
no spaces, no special characters, no numbers
Which of the following is used to improve performance in frequently used columns by maintaining a sort order but does not enforce constraints?
nonunique index
The ____________________ process enables you to identify the existence of potential problems in the design of a database.
normalization
When referring to big data, volume means _____.
the amount of data from many sources
In _____, clients perform the presentation functions, a database server performs the database functions, and application servers perform the business functions.
three-tier architecture
When do you use the & operator in an expression in Access Query Design View?
to combine values in character fields
What type of database replication relies on centralized control that determines when replicas may be created and how they are synchronized with the master copy?
traditional database replication
