Which of the following best describes the use of a database by the application?

focusNode

Inhaltsverzeichnis Show

Exam1 Study Guide
What is a database application used for?
What is the best description of an application program for databases?
Which of the following best describes a database?
Which of following is database application?

Didn't know it?
click below

Knew it?
click below

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

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.

What is a database application used for?

The main purpose of database applications is to provide a way for data to be consumed either by end users (via UI) or other higher-level applications (via APIs). A database application can be used for storing or retrieving data, processing transactions, or various machine learning calculations.

What is the best description of an application program for databases?

A database application is a computer program whose primary purpose is retrieving information from a computerized database. From here, information can be inserted, modified or deleted which is subsequently conveyed back into the database.

Which of the following best describes a database?

Which of the following best describes a database? It refers to a collection of data organized to serve many applications efficiently by centralizing the data and controlling redundant data.

Which of following is database application?

Detailed Solution. MICROSOFT ACCESS is a Database Management System offered by Microsoft. It uses the Microsoft Jet Database Engine and comes as a part of the Microsoft Office suite of application.

Which of the following best describes the use of a database by the application?

Exam1 Study Guide

What is a database application used for?

What is the best description of an application program for databases?

Which of the following best describes a database?

Which of following is database application?

zusammenhängende Posts

Which of the following best describes the process of natural selection quizlet?

Each of the following describes the national assessment of education progress (naep) except?

Which term describes an emotional response to frustration of desires or a challenge Quizlet

Quizlet which statement describes the impact of experience on clinical judgment?

Which trend describes industrial wages during world war i?

Which statement describes a result after multiple cisco lan switches are interconnected?

Which of the following best describes characteristics of assessment for learning?

Which of the following best describes why firms choose to create codes of ethics

Which of the following statements accurately describes traditional bureaucracies

Which of the following describes the first step in conducting a quantitative study

Werbung

NEUESTEN NACHRICHTEN

Kann man nur schwanger werden wenn man den eisprung hat

Was kostet windows 10 nach einem jahr

Was passiert wenn ein Elektron aus der Hülle entfernt wird?

What is the relationship between unethical politicking and impression management quizlet?

For a person to be recognized as having a high degree of political skill, he or she must have the

Was bedeuted o7

Wie erstelle ich einen Broadcast WhatsApp?

Führerschein C1 171 Was darf ich fahren

Rezept rote beete carpaccio mit ziegenkäse

When delivering a speech you should display visual aids only when discussing them?

Werbung

Populer

Werbung

Um

Legal

Hilfe

Sozial