Database and Page Ref
Chapter 9: Managing Multiuser Databases
1) Database administration tasks have to be performed for single-user, personal databases.
Answer: TRUE
Diff: 3 Page Ref: 396
2) Database administration is more important but less difficult in multiuser database systems than in single-user database systems.
Answer: FALSE
Diff: 2 Page Ref: 396
3) In general, the overall responsibility of the DBA is to facilitate the development and use of the database system.
Answer: TRUE
Diff: 1 Page Ref: 396
4) The DBA has to find a balance between the conflicting goals of maximizing availability of the database to users and protecting the database.
Answer: TRUE
Diff: 2 Page Ref: 396
5) The DBA …show more content…
Diff: 3 Page Ref: 403-404
31) The transaction boundaries are the essential information that the DBMS needs from the application programs to enforce different locking strategies.
Answer: TRUE
Diff: 3 Page Ref: 404-405
32) A durable transaction is one for which all committed changes are permanent.
Answer: TRUE
Diff: 3 Page Ref: 406
33) Transaction level consistency means that all rows impacted by any actions in a transaction are protected from change during the entire transaction.
Answer: TRUE
Diff: 2 Page Ref: 406-407
34) A dirty read happens when one transaction reads a changed record that has not been committed to the database.
Answer: TRUE
Diff: 3 Page Ref: 407-408 Fig 9-11
35) Nonrepeatable reads occur when a transaction rereads data it has previously read and finds modifications or deletions caused by a committed transaction.
Answer: TRUE
Diff: 3 Page Ref: 407-408 Fig 9-11
36) Repeatable Read isolation is the most restrictive level of isolation.
Answer: FALSE
Diff: 2 Page Ref: 408 Fig 9-12
37) According to ANSI SQL, the serializable isolation level will not allow phantom reads, dirty reads, and nonrepeatable reads.
Answer: TRUE
Diff: 3 Page Ref: 408 Fig 9-12
38) A static cursor processes a snapshot of the relation that was taken when the cursor was opened.
Answer: TRUE
Diff: 2 Page Ref:
-
Marketing and Page Ref
9872 Words | 40 Pagesintegrated marketing C) the promotion mix D) competitive marketing E) target marketing Answer: C Diff: 1 Page Ref: 402 AACSB: Communication Skill: Concept Objective: 14-1 2) The use of short-term incentives to encourage the purchase or sale of a product or service is called ________. A) direct marketing B) sales promotions C) personal selling D) public relations E) publicity Answer: B Diff: 2 Page Ref: 402 AACSB: Communication Skill: Concept Objective: 14-1 3) Any paid form of nonpersonal presentation…
-
Computer Security and Page Ref
6114 Words | 25 Pagesand networks. Answer: TRUE Diff: 1 Page Ref: 294 AACSB: Use of IT CASE: Comprehension Objective: 8.1 2) Computers using cable modems to connect to the Internet are more open to penetration than those connecting via dial-up. Answer: TRUE Diff: 2 Page Ref: 294 AACSB: Use of IT CASE: Comprehension Objective: 8.1 3) Wireless networks are vulnerable to penetration because radio frequency bands are easy to scan. Answer: TRUE Diff: 2 Page Ref: 295 AACSB: Use of IT CASE: Comprehension…
-
database
4793 Words | 20 Pagescommand? Selected Answer: SELECT HireDate, COUNT(*) FROM EMPLOYEE WHERE Salary < 30000; Question 9 5 of 5 points Because SQL stored procedures allow and encourage code sharing among developers, stored procedures give database application developers the advantages of less work, standardized processing, and specialization among developers. Selected Answer: True Question 10 5 of 5 points The SQL command used to create a virtual table is ________.…
-
Database: Data Management and Ref
2448 Words | 10 PagesChapter 1: Database Systems TRUE/FALSE 1. Data and information are essentially the same thing. ANS: F PTS: 1 REF: 5 2. Data processing can be as simple as organizing data to reveal patterns. ANS: T PTS: 1 REF: 6 3. We are now said to be entering the “knowledge age.” ANS: T PTS: 1 REF: 6 4. Information implies familiarity, awareness, and understanding knowledge as it applies to an environment. ANS: F PTS: 1 REF: 6 5. Data constitute the building blocks of information…
-
Management and Page Ref
11976 Words | 48 Pageswork and lower turnover. Finally, companies with reputations as good places to work have been found to generate superior financial performance. Expanding a company's consulting needs is not a positive reason to teach organizational behavior. Diff: 2 Page Ref: 4 Topic: Importance of Interpersonal Skills Skill: AACSB: Analytic Skills Objective: Interpersonal Skills Quest. Category: Application LO: 1 2) Which of the following is most likely to be a belief held by a successful manager? A) Technical…
-
Electronic Commerce and Page Ref Essay
4966 Words | 20 PagesTRUE Diff: 2 Page Ref: 8 AACSB: Reflective Thinking 2) Approximately 80% of adults in the United States use a social network on a daily basis. Answer: FALSE Diff: 2 Page Ref: 8 AACSB: Reflective Thinking 3) A company's online inventory control process is an example of e-business, as opposed to e-commerce. Answer: TRUE Diff: 2 Page Ref: 13 AACSB: Analytic Skills 4) Ubiquity increases cognitive energy outlays. Answer: FALSE Diff: 2 Page Ref: 16 AACSB: Analytic…
-
Management: Social Responsibility and Page Ref
19403 Words | 78 Pagesthe high standards for cleaning that they were looking for Diff: 1 Page Ref: 29 Objective: 2.1 2) The $10 test was enthusiastically accepted by workers immediately. Answer: Explanation: The $10 test was at first resented by workers. They didn 't like being checked up on. As time passed, workers adjusted to the standards of the test and began to look forward to the extra money they could earn. Diff: 2 Page Ref: 29 Objective: 2.1 3) One area in which most global companies are…
-
Paragraph and Arrow Ref
3364 Words | 14 Pages____. a. Print Layout view b. Headline view c. Web Layout view d. Outline view REF: WD 5 2. The ____ as shown in the accompanying figure is a formatting mark that indicates where the ____ was pressed. a. TAB key c. ENTER key b. SPACEBAR d. SHIFT key REF: WD 6 3. To enter a blank line into a document, press the ____ key without typing any text on the line. a. CTRL c. ENTER b. ALT d. ESC REF: WD 7 4. Press the ENTER key in all of the following circumstances EXCEPT ____. a. to…
-
Database Vs. Database Technology
6492 Words | 26 Pagesretrieval. For such purposes, the concept of the database has been utilised. A database is referred to as “the collection of related data, which are organised so that useful information may be extracted” (Wiederhold, 1980). Databases provide a single and comprehensive place for storing data. A collection of various paper-based files and electronic spreadsheets or files containing similar types of information are also categorised as databases. However, databases are considered effective not only because…
-
Marketing and Page Ref
14698 Words | 59 Pagesthe global environment Answer: B Diff: 1 Page Ref: 66 Skill: Concept Objective: 3-1 2) Which of the following terms is used to describe the factors and forces outside marketing that affect marketing management 's ability to build and maintain successful relationships with target customers? A) the marketing environment B) the cultural environment C) strategic planning D) target markets E) the marketing mix Answer: A Diff: 1 Page Ref: 66 Skill: Concept Objective: 3-1 3) You…
More about Database and Page Ref
-
Marketing and Page Ref
9872 Words | 40 Pages -
Computer Security and Page Ref
6114 Words | 25 Pages -
database
4793 Words | 20 Pages -
Database: Data Management and Ref
2448 Words | 10 Pages -
Management and Page Ref
11976 Words | 48 Pages -
Electronic Commerce and Page Ref Essay
4966 Words | 20 Pages -
Management: Social Responsibility and Page Ref
19403 Words | 78 Pages -
Paragraph and Arrow Ref
3364 Words | 14 Pages -
Database Vs. Database Technology
6492 Words | 26 Pages -
Marketing and Page Ref
14698 Words | 59 Pages