Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit

Preview Test: BISM7206 Semester One End-of-semester Examination 2022

QUESTION 1

Which of the following is a file that automatically records a brief description of the database operations performed by all users?

a. database log

b. digital footprint

c. audit log

d. change tracker

QUESTION 2

What can organisations use in their computer systems that allow the

system to continue to process database transactions after a hard drive failure?

a. backup

b. surge suppressor

c. UPS

d. RAID

QUESTION 3

A trigger can be used as a security measure in which of the following ways?

a. To check for viruses

b. To control error handling

c. To control database transactions

d. To execute a special procedure

QUESTION 4

_____ is the protection of the database against unauthorized access, either intentional or accidental.

a. Access monitoring

b. Data decryption

c. Security

d. Integrity checking

QUESTION 5

_____ are designed for presenting data to the end user in a variety of ways.

a. Data analysis tools

b. ETL tools

c. Data visualization tools

d. Data stores

QUESTION 6

From a data analyst’s point of view, decision support data differ from operational data in three main areas: time span, granularity, and _____.

a. sparsity

b. usability

c. transaction processing

d. dimensionality

QUESTION 7

Fact and dimension tables are related by _____ keys.

a. foreign

b. shared

c. primary

d. linked

QUESTION 8

_____ tools focus on the strategic and tactical use of information.

a. Business intelligence

b. Business

c. Networking

d. Relational database management

QUESTION 9

_____ transparency allows data to be updated simultaneously at several network sites.

a. Transaction

b. Distribution

c. Failure

d. Performance

QUESTION 10

_____ fragmentation refers to the division of a relation into subsets of tuples.

a. Data

b. Mixed

c. Horizontal

d. Vertical

QUESTION 11

_____ transparency is the highest level of transparency. The end user or programmer does not need to know that a database is partitioned.

a. Location

b. Local mapping

c. Performance

d. Fragmentation

QUESTION 12

_____ fragmentation refers to the division of a relation into attribute subsets.

a. Vertical

b. Horizontal

c. Mixed

d. Data

QUESTION 13

Big Data

a. relies on the use of structured data

b. relies on the use of unstructured data

c. captures data in whatever format it naturally exists

d. imposes a structure on data when it is captured

QUESTION 14

_____ is NOT one of the "Vs" of Big Data.

a. Volume

b. Validity

c. Velocity

d. Variety

QUESTION 15

In business analytics, ______ analyses data relating to past performance to predict likely future events.

a. Descriptive analytics

b. Predictive analytics

c. Prescriptive analytics

d. Diagnostic analytics

QUESTION 16

In the context of Big Data, which of the following "Vs" refers to the speed at which data is entering the system?

a. veracity

b. variety

c. volume

d. velocity

QUESTION 17

The database design methodology has several steps to build a conceptual data model. 

Using dot-points, briefl y describe two important aspects about "Step 9 - Review conceptual data model with user". 

QUESTION 18

If a data file from an old system was imported into a new database, it is important to check that the integrity of the new database is maintained.

Examine the data file above and identify data anomalies (or errors) where you think the data appears to be invalid, inconsistent, or incorrect. For each error you identify, specify the following: 

a. the row number, data value of the error, and

b. a new value that would be correct or more suitable.

QUESTION 19

Using the above relation, answer the following questions:

a. Identify any partial dependencies that exist. 

b. Identify any transitive dependencies that exist. 

c. Convert the relation to Third Normal Form (3NF) and show the 3NF relation/s in the following format: relation name (primary key attribute/s, attribute1, attribute2, attribute3 …)

QUESTION 20

Using the above transaction schedule that represents bank account deposits and withdrawals, answer the following questions:

If the original balance of the bank account is $450 at t1:

a. What is the balance at time period t2?

b. What is the balance at time period t4?

c. What is the balance at time period t6? 

d. What is the correct final balance?

e. What is this problem known as? 

QUESTION 21

The above table contains data about properties for sale that are listed with a local real estate agent.

Using the Property table above and its column headings  (attributes), write the SQL script for the following queries as if it were going to be run/executed in MySQL Workbench:

a. List all details about properties for sale in alphabetical order by city.

b. List the street, city, type, and price for properties for sale in Marcoola.

c. How many houses are for sale in Coolum?

d. What is the average property price in each city?

e. List all details about apartments with 3 rooms.

QUESTION 22

Please use this space if you believe there is missing or incorrect information that impacted your ability to answer any question. Please state which questions this is related to.