Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Database Management
Exam1 Study Guide
| Question | Answer |
|---|---|
| Data accuracy begins with verifying the source of the data | True |
| Which of the following best describes and organization's primary processes? | The processes performed to support and fulfill the core business |
| When interviewing employees to collect data, you should limit yourself to executive staff, supervisors, and managers only | False |
| Which of the following is an example of data that provides a competitive advantage? | Sales records over time that let you identify potential related sales to the same customers |
| Modern databases are often referred to as SQL databases | True |
| What are the two primary categories of data security? | Access security and physical security |
| Front-line managers are typically the best source for what type of information? | Day-to-day business activities |
| Which statement best describes the role of data in business? | Data can provide a competitive advantage in hotly contested industrie |
| For what reason would you implement RAID technologies as part of your design? | To provide fault-tolerant data storage |
| For what purpose are authentication methods implemented? | To verify users before allowing access to data |
| Which of the following is typically NOT a goal in data management? | making all data available to all employees |
| Hardware and file management are the responsibility of which of the following? | operating system |
| Which database model is most commonly used in modern database design? | Relational model |
| Which of the following would typically be supported by automatic periodic procedures? | all of the above (data backup,database tuning,routine maintenance) |
| If a business has both a production database and a decision support database, what is the usual relationship between the two? | The production database is the data source for the decision support database |
| What is the role of the query processor in a DBMS? | The query processor parses, optimizes, and compiles the query for execution |
| What is a potential drawback to the relational model? | A table does not always completely symbolize a real-world entity |
| Which of the following statements correctly describes a transaction? | All statements in a transaction must be completed or rolled back as a group |
| Which component would you find included by default in Microsoft Access, but not Microsoft SQL Server? | forms generato |
| Which database model organizes data into sets containing owners and members? | network model |
| All of the following are a characteristic of a mass deployment database EXCEPT? | Generally read-only |
| Secondary storage refers to which of the following? | Local hard disk |
| Entities and attributes are identified during logical design. | True |
| A transactional database must support which of the following activities? | All of the above (adding new data, changing existing data, deleting data) |
| Your design must ensure that any customer purchases at least $20.00 in merchandise. This is an example of which of the following? | Business rule |
| Which statement best describes an identifier? | An identifier must uniquely identify an entity |
| Each table in your database typically represents which of the following? | An entity |
| Which term refers to the maximum number of entities that can be involved in a relationship? | Cardinality |
| What attributes should be included in a data model? | Only attributes that are applicable to business requirements |
| What is the role of an associative entity? | It is designed to associate key values from two entities in a many-to-many relationshi |
| The primary index in a database is usually a clustered index. True or false? | True |
| All of the following are tasks performed during the physical design stage of the database and application design process EXCEPT: | Identify data services required |
| Each supervisor is also an employee. Each employee has a supervisor. Each supervisor is responsible for one or more employees. What kind of a relationship does this describe? | Unary |
| The data normalization process is also known as non-loss decomposition. True or false? | True |
| If a group of tables is in third normal form, it is also in first normal form and second normal form. True or false | True |
| You are converting a zero-or-one-to-zero-or-one relationship to relational tables. How can you determine the best placement of the foreign key? | The foreign key goes with the entity that would result in the least wasted space |
| When is a foreign key NOT needed in a relational table design? | When converting a single, non-related entity |
| Each employee has a manager. Each manager is also an employee. A manager is responsible for one or more employees. Employees are identified by employee number. How would you design this relationship? | Create one EMPLOYEE table with the employee number as primary key. Add a manager number column for each row as a foreign key related to employee number. |
| The Vendor entity includes the following attributes: Name, vendor number, address, phone number, fax number, contact name, and vendor customer number. You want to identify an alternate vendor for each primary vendor. What is the best way to do this? | Create a VENDOR table that includes an alternate vendor foreign key |
| How must you change the structure when converting a many-to-many unary relationship in an ER diagram to relational tables?? | Add an associative table |
| How can a change in modality in a one-to-one relationship impact table design?? | A change in modality can change foreign key placement |
| You create a relational table design based on a business ER diagram. What is the first step you should take to normalize the design? | Apply the first normal form to each table. |
| A relational table includes the following columns: Customer number, Region number, Customer name, Region Name, Regional manager, Customer phone, Customer fax. How would normalizing to the second normal form change the table structure? | You would break the table into two tables, CUSTOMER and REGION. |
| A table includes the following columns: Purchase order number, Vendor, Vendor customer number, Order date, Line item number, Vendor SKU, and Order quantity. The combination of Purchase order number and Line item number is the primary key. current state | The data is normalized to the first normal form. |
Created by:
svue22