Reference no: EM131062353
Data Infrastructure Quiz
1. Why is it essential to know what information will be needed from the database from the outset of development?
The number of fields in the database determines the cost of that database, so if careful planning doesn't occur, money can be wasted.
By knowing the purpose, the developer can determine how many fields are needed in the database.
The purpose determines the structure of the database.
The developer can determine which data types would help fulfill the purpose.
2. Indicate which of the following statements about databases and data types are accurate.
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
3. Which of the following would be a field in a database?
Gender
63.2%
Sales
19943-5568
4. Which of the following statements about data organization are correct?
You cannot perform mathematical functions on string data.
The information in each record must refer to a person.
Not all records need to contain data about every attribute.
A relationship may exist between each individual record.
5. Which of the following are forms of queries?
projection
database
join
insert
6. Which of the following are operations used to alter the data within a relation of a database?
delete
join
insert
update
7. In order for a database to work, at least one of the fields has to contain unique values. What is the name of this field?
Unique projection
Unique identifier
Unique database
Unique relation
8. Which of the following are the three main categories of databases?
Isolated
Relational
Flat File
Hierarchical
9. Which of the following database categories is the most similar to a spreadsheet or MS Excel document?
Flat File
Relational
Isolated
Hierarchical
10. Which of the following examples best describes hierarchical databases?
A spreadsheet
Amazon's customer database
Parent-child relationships
A tree-like structure
11. Which of the following skills are needed to assist with application design and development?
data integration
schema development
maintenance
performance tuning
12. Database administrators might be involved with the integration of data from where?
Local area networks to other networks
Older systems to new
Newer to older systems
DBMS to new systems
13. Indicate which of the following statements about databases and data types are accurate. Select all that apply
performance tuning and design development
DBMS support and proper security measures
design development and DBMS support
proper security measures and design development
|
What are your top five skills and what kinds of skills are
: Content or Knowledge specific to a field and Functional skills that may be applied in various fields - What are your "top five" skills and what kinds of skills are they?
|
|
Course of marketing management
: In regards with course of Marketing Management, highly appreciate your help on below question
|
|
Search out the latest uk information
: Search out the latest UK information (secondary data) on: (a) The per capita gross domestic product over the last ten years;
|
|
Find the maximum stresses ss and sw in the steel
: If the beam is rotated 90° to bend about its y axis (see figure part b), and uniform load q=250 lb/ft is applied, find the maximum stresses σs and σw in the steel and wood, respectively. Include the weight of the beam. (Assume weight densities of ..
|
|
What information will be needed from the database
: Why is it essential to know what information will be needed from the database from the outset of development? Which of the following statements about data organization are correct?
|
|
Create a better process for getting work accomplished
: How does this specific problem effect the entire organization? How would clarity around BART create a better process for getting work accomplished in the organization? How would BART be applied
|
|
Tracking system to track customer
: 1. Cover Sheet with Name, Proposed Market Plan, Date, Company Name 2. List of products/services you currently provide and new ones you plan to introduce 3. Design of a response tracking system to track customer responses to the new service or product..
|
|
Clearly the population when undertaking research
: Why is it essential to define clearly the population when undertaking research? Illustrate your answer with reference to a survey on raising the UK statutory age for retirement.
|
|
Which is the final step in creating a bcp plan
: Which of the following is the final step in creating a BCP plan? Which of the following statements accurately describes off-site storage?
|