Unit 6 Flashcards
Emily is working on the company database of employees. She has been asked to create a birthday list. What information would she need?
Employee name and date of hire.
Employee name and date of birth.
Employee number and date of hire.
Employee number and date of birth.
Employee name and date of birth.
Alberto needs to determine the number of items his company has shipped to Detroit in the last three months. What information would he need?
Zip codes for Detroit, number of items shipped, and the range of dates covering the last three months.
Number of items shipped, product code of items shipped, and the range of dates covering the last three months.
Zip codes for Detroit, product codes of items shipped, and the range of dates covering the last three months.
Zip codes for Detroit, product codes of items shipped, and the number of items shipped.
Zip codes for Detroit, number of items shipped, and the range of dates covering the last three months.
Which of the following best describes a hierarchical database format?
Data are modeled using parent-child relationships.
The database format is one of the most commonly used today.
Database records that do not have relationships with other tables.
Data are modeled using parent-child relationships.
A ____ database has records that are separated by a delimiter.
flat file
is another form of query that returns all of the records from the relation, but only select attributes or fields
Projection
Queries can be used to do all of the following EXCEPT which of the following?
Determine whether data in relations is accurate.
Retrieve data from relations with specific characteristics.
Modify multiple records based on a given set of criteria.
Delete records of given characteristics.
Determine whether data in relations is accurate.
Which type of query is used to withdraw information from multiple relations?
Join
Modify
Sort
Search
Join
The term ___ is another form of query that returns all of the records from the relation, but only select attributes or fields.
projection
A _____ is a search of data in the relation that fit specific parameters.
query
Which type of administrator would not deal directly with the installation and maintenance of database applications, performance tuning parameters, account creation, and procedures associated with DBMS?
Web administrators and IT administrators
System administrators and database administrators
System administrators and web administrators
System administrators and web administrators
Evolv captures large quantities of data with over 488 million data points. What is the most likely type of database structure that is used for this data?
Relational
Flat file
Hierarchical
Relational
Why is it essential to know what information will be needed from the database from the outset of development? Select three that apply.
By knowing the purpose, the developer can determine how many fields are needed in the database.
The developer can determine which data types would help fulfill the purpose.
The purpose determines the structure of the database.
The number of fields in the database determines the cost of that database.
By knowing the purpose, the developer can determine how many fields are needed in the database.
The developer can determine which data types would help fulfill the purpose.
The purpose determines the structure of the database.
Indicate which of the following statements about databases and data types are accurate. Select three that apply.
Once the database is designed, the user doesn’t need to worry about determining data types.
Uniform data types can be searched and sorted.
Numbers can be entered as text or as numeric values
A customer’s first name and last name must be entered as two separate fields.
Once the database is designed, the user doesn’t need to worry about determining data types.
Uniform data types can be searched and sorted.
Numbers can be entered as text or as numeric values
Which of the following would be a field in a database? Select two that apply.
63.2%
Sales
19943-5568
Gender
63.2%
19943-5568
Which of the following statements about data organization are correct? Select three that apply.
The information in each record must refer to a person.
A relationship may exist between each individual record.
You cannot perform mathematical functions on string data.
Not all records need to contain data about every attribute.
A relationship may exist between each individual record.
You cannot perform mathematical functions on string data.
Not all records need to contain data about every attribute.
