final

Ace your homework & exams now with Quizwiz!

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


Related study sets

Portuguese and Spanish Explorations

View Set

CALIFORNIA REAL ESTATE: CHAPTER 3: THE PRIMARY AND SECONDARY MARKETS. TERMS AND QUIZ.

View Set

Chapter 6 Managing People and Work

View Set

Strong & Weak Acids and Bases, Chemistry 111- Chapter 4

View Set