BISM7206 Semester One End-of-semester Examination 2022
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.
2023-06-15