Data Application Question homework help

Anonymous
timer Asked: May 17th, 2016
account_balance_wallet $9.99

Question Description

Answer Questions 1-19 True/False and fill in blanks in the attach file below.

Unformatted Attachment Preview

QUESTION 1 Denormalization is never a good practice. True False QUESTION 2 The purpose of concurrency control is: preventing users from working on a database concurrently. ensuring that one user’s work does not influence another user’s work inappropriately. providing an opportunity for users to work on databases concurrently. stopping all concurrent transactions. QUESTION 3 Locks placed automatically by the DBMS are called: implicit locks. explicit locks. automated locks. DBMS locks. QUESTION 4 Locks placed by the user for exclusive rights to the data are called: implicit locks. explicit locks. user-defined locks. exclusive locks. QUESTION 5 A pointer into a set of rows that are the result set from an SQL SELECT statement is called a: SQL pointer. selector. row pointer. cursor. QUESTION 6 Reprocessing is not typically the best method of recovery from a failure in a multiuser system. True False QUESTION 7 "User-defined function” and “stored procedure” are synonyms. True False QUESTION 8 The standard developed in the early 90’s to provide a DBMS-independent means for processing relational database data is: ADO AMP ODBC API QUESTION 9 A database system that has data, programs, and personnel specializing in the preparation of data for BI processing is called: a data mart. an ETL system. OLAP. a data warehouse. QUESTION 10 Dimensional database use which type of design: Normalized database design Star schema Operational database design Dimensional schema QQUESTION 11 1. Describe the lost update problem. QQUESTION 12 What is the difference between authentication and authorization? QQUESTION 13 1. What is an SQL injection attack? QQUESTION 14 What are six problems with using operational data for BI processing? QQUESTION 15 What is a data mart? QQUESTION 16 What is the difference between a database and a DBMS? QQUESTION 17 What is a surrogate key? QQUESTION 18 Discuss three reasons to learn SQL even though Microsoft Access provides us with a Query Wizard? QQUESTION 19 List and describe the three types of binary relationships. ...
Purchase answer to see full attachment

Tutor Answer

Mr Intel
School: UC Berkeley

QUESTION 1

Denormalization is never a good practice.
True
False

QUESTION 2

The purpose of concurrency control is:
preventing users from working on a database concurrently.
ensuring that one user’s work does not influence another user’s work
inappropriately.
providing an opportunity for users to work on databases concurrently.
stopping all concurrent transactions.

QUESTION 3

Locks placed automatically by the DBMS are called:
implicit locks.
explicit locks.
automated locks.
DBMS locks.

QUESTION 4

Locks placed by the user for exclusive rights to the data are called:
implicit locks.
explicit locks.

user-defined locks.
exclusive locks.

QUESTION 5

A pointer into a set of rows that are the result set from an SQL SELECT statement is
called a:
SQL pointer.
selector.
row pointer.
cursor.

QUESTION 6

Reprocessing is not typically the best method of recovery from a failure in a multiuser
system.
True
False

QUESTION 7

"User-defined function” and “stored procedure” are
synonyms.
True
False

QUESTION 8

The standard developed in the early 90’s to provide a DBMS-independent means for
processing relational database data is:

ADO
AMP
ODBC
API

QUESTION 9

A database system that has data, programs, and personnel specializing in the
preparation of data for BI processing is called:
a data mart.
an ETL system.
OLAP.
a data warehouse.
QUESTION 10

Dimensional database use which type of design:
Normalized database design
Star schema
Operational database design
Dimensional schema

QQUESTION 11

1. Describe the lost update problem.
It is a typical problem in the SQL transaction processing. It occurs when
two queries or transactions access and update the same data from the
database. Each tra...

flag Report DMCA
Review

Anonymous
Tutor went the extra mile to help me with this essay. Citations were a bit shaky but I appreciated how well he handled APA styles and how ok he was to change them even though I didnt specify. Got a B+ which is believable and acceptable.

Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors