Concepts of Database Management Final exam ITD130
_________________________ describes the large volume of data produced by every digital process, system, sensor, mobile device, and even social media exchange.
big data
A(n) _____ is a piece of data they cannot be meaningfully divided.
Atomic value
What type of rules specify user privilege to select, insert, update, and delete data for different tables and views?
Authorization
Which of the following operators allows you to specify a range and is often use with date criteria?
Between
Which authentication to identifies users by physical characteristics, such as fingerprints, voiceprint, handwritten, signatures, and facial characteristics?
Biometrics
Third normal form is often referred to as ______.
Boyce-Codd normal form
In the pit, fitness database, which table relates classes, and instructors?
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 checkbox
In Database Design Language (DBDL), which items do you underline?
Columns that make up the primary key
In the Access QBE, where do you specify criteria for a query?
Criteria row of the query design grid.
What type of constraints help to ensure the accuracy inconsistency a field values?
Data integrity constraints
Which of the following is a drawback of flat files?
Data partitioned into several separate files can be difficult to summarize.
Which of the following database professionals uses programming algorithm and applies statistics to analyze large sets of data?
Data scientist
________ refers to the hardware and software and organization needs to address the analytical requirements of users without detracting from traditional operations.
Data warehouse architecture
Which of the following database professionals most likely uses SQL to summarize and analyze data to extract trends, insights, and knowledge?
Database analyst
In Access a (n) _____ query permanently, removed all the records from the selected table(s) that satisfies the criteria entered in the query.
Delete
Which of the following pairs has the clearest field name in Atomic value?
DistanceInMiles, 20
Which of the following clauses sets the ProductID field as the foreign key to the Orders table?
FOREIGN KEY (ProductID) REFERENCES Orders
A good name for an access table might be tbl!Student. True or false
False
An E-R diagram uses diamonds to illustrate relationships between tables. True or false
False
In a database, a view is a copy of table data. True or false
False
According to the bureau of labor, statistics, what is the job growth outlook for database administrator's?
Faster than average
_____ means that when, using a distributed database users feel that the data they work with comes from a single central database.
Fragmentation transparency
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;
Data visualization is not a feature of which software product?
Hadoop
In an access, query, a "group" of records ______.
Has the same value in a particular field
Which of the following laws does not govern data access retention, and destruction?
Hatch Act
What do you call an arrangement of location data with three levels. Such as cities within states within countries?
Hierarchy
In the Pit 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
Which Access function returns the position of the space character in a field?
InStr
During which process do you typically create an entity-relationship (E-R) diagram?
Information-level design
Which access feature restricts a field to a special format for entering data?
Input mask
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 use when data is sent from a server to a webpage.
JavaScript object notation (JSON)
Which of the following features does an enterprise-level DBMS used to avoid the costly and time consuming task of having users redo their work?
Journaling
Which of the following is considered a very popular open source back in software stack?
LAMP (Linux, Apache, MySQL, PHP)
Which of the following access features provides a drop-down list of values for a field?
Look up field
What type of Access query creates a new table using the query results?
Make-table
What type of Excel chart compares values across geographical locations?
Map chart
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
When you display the system tables in Access, where do they appear?
Navigation pane
In the following Projects table, which field is functionally dependent on the ClientID field? Projects (ProjectID, ProjectType, ProjectName, ProjectManager, Budget, ClientID)
None of the fields in the project table is functionally dependent on the client ID field
_____ follows a series of steps to break columns into smaller tables to identify entities and facts about each entity.
Normalization
In in OODBMS, a (n) _____ is a set of related attributes along with the actions that are associated with the set of attributes.
Object
In a database from a health care clinic, a medical specialty is listed only once in the Specialties table, but each specialty may be linked to many doctors in the Doctors table. What type of relationship do the Specialties and Doctors table have?
One to many
What must you do before setting a database password in Access?
Open the database in exclusive mode.
According to an article reference by the bureau of labor, statistics, which of the following is a fundamental competency for a job in Database administration?
Oracle
Based on the SQL shown which query fines, 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 SQL shown, which query list the name and balance of all customers with balance is 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 Customer WHERE Balance BETWEEN 2000 AND 5000;
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 the Pit Fitness database, what can you learn by examining the ClassInstructors data?
Some classes use more than one instructor
When you add or delete a table or change the structure of a table, where does the DBMS record these changes?
System catalog
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. True or false
True
Microsoft Access allows concurrent updates to different records of the same table. True or false
True
Redundancy makes changing data, more cumbersome and time consuming. True or false
True
What do you call a table that contains multiple field entries in a single column?
Unnormalized relation
ProductType is a foreign key field in the Orders table and is constrained to a list of valid entry is stored in the ProductTypes table. What problem does this design prevent?
Update anomalies
For which of the following tasks is data independence not a consideration?
Updating a record
In Access, if you want to be able to enter different criteria, each time you run, a query, create a(n) ______ query.
parameter
What do key integrity constraints consist of?
primary and foreign key constraints
What does the INNER JOIN command select from related tables?
records that have matching values in both tables
A database that enforces _____ prevents users from creating orphan records.
referential integrity
Which of the following is not a typical qualification for a data analyst?
strong graphic design skills
Which aggregate function do you use to total the values in a numeric field in a group of records?
sum
A user view of data is ______.
the specific data needed by a person or process for a particular task
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 do you call a data inconsistency that results from data redundancy or the use of inappropriate nulls?
update anomaly
Which of the following is information that Access system catalogs do not maintain?
users, user groups, and privileges
What SQL command can you use to join two tables?
where
How does Access handle concurrent updates?
with record-level locking
You can create compound criteria (conditions) in a query by using which of the following two key words?
AND,OR
Data scientist look for patterns and trends in data to discover new opportunities and solutions. True or false
True
In Access SQL, you use the asterisk (*) as a wild card character to represent any number of characters. True or false
True
If you use __________________ criteria, each criterion must be true for a record to be selected.
and
In an entity-relationship model (ERM) what information appears in ovals?
attributes
A ______ is a single logical database that is physically divided, among computers at several sites on a network.
distributed database
How are entities represented in a relational database?
each entity is stored as a table
Which fields should you index in a table?
fields that are commonly used for sorting
A ______ is a set of standards, development, tools, and software libraries that help programmers develop software solutions faster and with more consistency
framework
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
Which of the following is a problem that data redundancy causes?
increased data errors and inconsistencies
What SQL command do you use to add new data to a table?
insert
Which type of rule prevents the creation of orphan records?
integrity constraint
Which normal form has an additional condition that excludes transitive dependencies?
3NF
Which of the following is not true about one-to-many relationships?
The linking field must have the same name in the primary and related tables.
Which of the following statements is not true about primary fields?
The primary field must participate in a one-to-many relationship
What does the bureau of labor statistics project for database administration jobs?
They will grow 11 percent through the year 2026.
A primary key field should never allow for values. True or false
True
What is the primary focus of the latest emerging careers in the database industry?
analysis of internal, external, and big data
What helps separate atomic values from a single column if the values follow a pattern?
algorithm
What do you call each key that meets the criteria for a primary key?
candidate key
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 is the term for a general set of skills that involves defining dissecting, communicating and solving problems using data and information?
data analysis
Although Access does not have stored procedures, you can achieve some of the same benefits with _____.
data macros
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 is a relatively new career in the database industry?
data scientist
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
During which phase does a database developer create the entities, attributes, and relationships between the tables of data?
database design
