微信客服：xiaoxionga100
微信客服：ITCS521
考试代写-BISM7206
时间：2021-11-11
5/18/2021 Preview Test: BISM7206 Semester One Final Examination 2021 &...
https://learn.uq.edu.au/webapps/assessment/take/launch.jsp?course_assessment_id=_222082_1&course_id=_137038_1&content_id=_6607638_1&step=null 1/10
Edit Mode is: ON•
Preview Test: BISM7206 Semester One Final Examination 2021
[BISM7206] Information Retrieval and Management (external). Semester 1, 2021 BISM7206S_7120_24375 Final Exam
Preview Test: BISM7206 Semester One Final Examination 2021
Test Information
Description
Instructions
Multiple Attempts Not allowed. This test can only be taken once.
Force Completion This test can be saved and resumed later.
Your answers are saved automatically.
a.
b.
c.
d.
QUESTION 1
Big Data
relies on the use of structured data
relies on the use of unstructured data
captures data in whatever format it naturally exists
imposes a structure on data when it is captured
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 2
If a table has multiple candidate keys and one of those candidate keys is a composite key, the table can have
_____ based on this composite candidate key even when the primary key chosen is a single attribute.
redundancies
partial dependencies
Boyce-Codd normal forms
time-variances
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 3
Which of the following contains a single-part primary key that serves as an index for the fact table and
also contains other fields associated with the primary key value?
star table
dimension table
fact table
relational table
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 4
_____ deals with ensuring that data is protected against unauthorized access, and if the data are accessed by an
authorized user, that the data are used only for an authorized purpose.
Compliance
Integrity
Privacy
Confidentiality
0.5 points Save Answer
?
Question Completion Status:
Welcome Organisations Sta Help Guides System Admin
Click Save and Submit to save and submit. Click Save All Answers to save all answers.
Courses Fiona Porter
5/18/2021 Preview Test: BISM7206 Semester One Final Examination 2021 &...
https://learn.uq.edu.au/webapps/assessment/take/launch.jsp?course_assessment_id=_222082_1&course_id=_137038_1&content_id=_6607638_1&step=null 2/10
a.
b.
c.
d.
QUESTION 5
A DBMS uses a __________ technique to identify a synchronisation point between the
database and the transaction log le.
checkpointing
backup
change log
recovery
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 6
Data redundancy produces _____.
data integrity problems
efficient storage use
slower lookups
robust design
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 7
Which of the following queries will display rows in the PRODUCT table with a COLOUR_CODE not equal to
5555?
SELECT P_DESCRIPT, P_PRICE, COLOUR_CODE
FROM PRODUCT
WHERE COLOUR_CODE ≠ 5555;
SELECT P_DESCRIPT, P_PRICE, COLOUR_CODE
FROM PRODUCT
WHERE COLOUR_CODE >< 5555;
SELECT P_DESCRIPT, P_PRICE, COLOUR_CODE
FROM PRODUCT
WHERE COLOUR_CODE NOT = 5555;
SELECT P_DESCRIPT, P_PRICE, COLOUR_CODE
FROM PRODUCT
WHERE COLOUR_CODE <> 5555;
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 8
_____ can render data useless to unauthorized users who might have violated some of the database security
layers.
Physical security
Access rights
Data encryption
Password security
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 9
What is the first query known as in an SQL subquery?
left
base
outer
inner
0.5 points Save Answer
a.
b.
c.
QUESTION 10
Hadoop is generally used with a set of other related products that interact and complement each other to create an
entire suite of applications and tools. This is also known as a(n) ____________?
ecosystem
big data system
database environment
0.5 points Save Answer
Question Completion Status:
Click Save and Submit to save and submit. Click Save All Answers to save all answers.
5/18/2021 Preview Test: BISM7206 Semester One Final Examination 2021 &...
https://learn.uq.edu.au/webapps/assessment/take/launch.jsp?course_assessment_id=_222082_1&course_id=_137038_1&content_id=_6607638_1&step=null 3/10
d.
database e o e t
applications system
a.
b.
c.
d.
QUESTION 11
A distributed _____ can reference several different local or remote data processing sites.
request
transaction
data location
site
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 12
A(n) ____ condition occurs when two or more transactions wait for each other to unlock data.
exclusive lock
deadlock
two-phase lock
binary lock
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 13
_____ are designed for presenting data to the end user in a variety of ways.
Data analysis tools
ETL tools
Data stores
Data visualization tools
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 14
In business analytics, ______ uses data to understand the past and present.
Descriptive analytics
Predictive analytics
Prescriptive analytics
Diagnostic analytics
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 15
From a structural point of view, 3NF is better than _____.
4NF
2NF
5NF
6NF
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 16
A _____ contains the description of the entire database as seen by the database administrator.
distributed global dictionary
distributed global schema
distributed data dictionary
distributed data schema
0.5 points Save Answer
a.
QUESTION 17
In the context of security controls, what technique is used to determine whether a user is who he or she claims to
be?
Confidentiality
0.5 points Save Answer
Question Completion Status:
Click Save and Submit to save and submit. Click Save All Answers to save all answers.
5/18/2021 Preview Test: BISM7206 Semester One Final Examination 2021 &...
https://learn.uq.edu.au/webapps/assessment/take/launch.jsp?course_assessment_id=_222082_1&course_id=_137038_1&content_id=_6607638_1&step=null 4/10
a.
b.
c.
d.
Confidentiality
Authorization
Authentication
Encryption
a.
b.
c.
d.
QUESTION 18
Which of the following statements is correct for the SQL data manipulation command HAVING?
restricts the selection of rows based on a conditional expression.
groups the selected rows based on one or more attributes.
modifies an attribute’s values in one or more table’s rows.
restricts the selection of grouped rows based on a condition.
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 19
The first step in developing the conceptual model using Entity Relationship Diagrams is to _____.
complete the initial Entity Relationship diagram
identify, analyze, and refine the business rules
normalize the entities
define the attributes, primary keys, and foreign keys for each of the entities
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 20
The SQL command that allows a user to permanently save data changes is _____.
INSERT
COMMIT
UPDATE
SELECT
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 21
The reliance on _____ as the design methodology for relational databases is seen as a stumbling block to its use
in OLAP systems.
star schema
normalization
multidimensional schema
denormalization
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 22
The special operator used to check whether a subquery returns any rows is _____.
BETWEEN
IN
LIKE
EXISTS
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 23
A table that is in 2NF and contains no transitive dependencies is said to be in _____.
1NF
2NF
3NF
4NF
0.5 points Save Answer
a.
QUESTION 24
A trigger can be used as a security measure in which of the following ways?
To control database transactions
0.5 points Save Answer
Question Completion Status:
Click Save and Submit to save and submit. Click Save All Answers to save all answers.
5/18/2021 Preview Test: BISM7206 Semester One Final Examination 2021 &...
https://learn.uq.edu.au/webapps/assessment/take/launch.jsp?course_assessment_id=_222082_1&course_id=_137038_1&content_id=_6607638_1&step=null 5/10
b.
c.
d.
To control database transactions
To check for viruses
To execute a special procedure
To control error handling
a.
b.
c.
d.
QUESTION 25
In business analytics, ______ analyses data relating to past performance.
Predictive analytics
Descriptive analytics
Diagnostic analytics
Prescriptive analytics
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 26
Fact and dimension tables are related by _____ keys.
foreign
primary
linked
shared
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 27
In business intelligence framework, data are captured from an operational database and placed in _____.
dashboard
relational database
decision support system
data warehouse
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 28
One of the steps in the conceptual database design is:
check integrity constraints
check entity relationship model for dependencies
check for future growth
check model for redundancy
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 29
_____ transparency allows a physically dispersed database to be managed as though it were centralized.
Distribution
Transaction
Performance
Failure
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 30
In the context of Big Data, _____ refers to the trustworthiness or correctness of a set of data.
variability
viability
value
veracity
0.5 points Save Answer
Question Completion Status:
Click Save and Submit to save and submit. Click Save All Answers to save all answers.
5/18/2021 Preview Test: BISM7206 Semester One Final Examination 2021 &...
https://learn.uq.edu.au/webapps/assessment/take/launch.jsp?course_assessment_id=_222082_1&course_id=_137038_1&content_id=_6607638_1&step=null 6/10
-
-
-
-
-
-
-
a.
b.
c.
d.
e.
f.
g.
h.
i.
j.
k.
QUESTION 31
Consider the following transaction schedule representing bank account transfers. The
original balance of the bank account at t1 is $120.
Using this transaction schedule, you are required to nd matching pairs. For each item
in the left-hand column, click the drop-down menu. From the drop-down menu, select
the character that corresponds to the matching item from the right-hand column. You
may use an item in the right-hand column more than once.
Time T1 T2
t1 begin_transaction
t2 read(balx) begin_transaction
t3 balx = balx + 80 read(balx)
t4 write(balx) balx = balx - 100
t5 commit write(balx)
t6 commit
balx at t2
balx at t3
balx at t4
balx at t5
balx at t6
If the nal balance was correct, what would it
be?
What is this problem known as?
Lost update
$120
Inconsistent analysis
$80
$20
$220
Correct answer is not in this list
Uncommitted dependency
The nal balance is correct
$200
$100
7 points Save Answer
-
-
-
-
-
-
-
-
-
-
a.
b.
c.
d.
e.
f.
g.
h.
i.
j.
k.
l.
m.
n.
o.
QUESTION 32
This question requires you to nd matching pairs. Using this transaction schedule, you are required to nd
matching pairs. For each item in the left-hand column, click the drop-down menu. From the drop-down
menu, select the character that corresponds to the matching item from the right-hand column. You may use
an item in the right-hand column more than once.
derived fragment
global system catalog
vertical fragment
distribution transparency
replication transparency
horizontal fragment
local conceptual schema
no fragmentation
global conceptual schema
fragmentation transparency
based on parent relation
leaves the database whole
subset of attributes
specic to distributed systems
subset of tuples
the whole database
user does not need to know that data is
fragmented
done after the logical design
ANSI-SPARC architecture
based on child relation
highest level of distribution transparency
user is unaware of fragment replication
subset of relation
external view
replicates the relation
10 points Save Answer
QUESTION 33
This question requires you to nd matching pairs. For each item in the left-hand column, click the drop-down
menu From the drop down menu select the character that corresponds to the matching item from the
9 points Save Answer
Question Completion Status:
Click Save and Submit to save and submit. Click Save All Answers to save all answers.
5/18/2021 Preview Test: BISM7206 Semester One Final Examination 2021 &...
https://learn.uq.edu.au/webapps/assessment/take/launch.jsp?course_assessment_id=_222082_1&course_id=_137038_1&content_id=_6607638_1&step=null 7/10
-
-
-
-
-
-
-
-
-
a.
b.
c.
d.
e.
f.
g.
h.
i.
j.
k.
l.
menu. From the drop-down menu, select the character that corresponds to the matching item from the
right-hand column. You may use an item in the right-hand column more than once.
Public methods
Benchmarking
Use-case driven approach
State diagram
Extensibility
Class diagram
Private methods
Sequence diagram
Object diagram
OODBMS advantage
Behavioural diagram
Comprehensive standards
UML
Structural diagram
Internal to class
DBMS performance
Constructors
Class instances
Conguration diagram
Interaction between objects
Design diagram
-
-
-
-
-
-
-
-
-
a.
b.
c.
d.
e.
f.
g.
h.
i.
j.
k.
QUESTION 34
Time T1 T2
begin_transaction
t2 read(balx)
t3 balx = balx + 50
t4 begin_transaction write(balx)
t5 read(balx) :
t6 balx = balx - 60 rollback
t7 write(balx)
t8
Consider the following transaction schedule representing bank account transfers. The
original balance of the bank account at t1 is $150.
Using this transaction schedule, you are required to nd matching pairs. For each item
in the left-hand column, click the drop-down menu. From the drop-down menu,
select the character that corresponds to the matching item from the right-hand
column. You may use an item in the right-hand column more than once.
t1
commit
balx at t2
balx at t3
balx at t4
balx at t5
balx at t6
balx at t7
balx at t8
If the nal balance was correct, what would it
be?
What is this problem known as?
$90
$200
$190
$260
$150
Inconsistent analysis
Uncommitted dependency
Lost update
$100
Correct answer is not in this list
$140
9 points Save Answer
QUESTION 35
F b i i b i l i h i i i h ll d d b D i h
3 points Save Answer
Question Completion Status:
Click Save and Submit to save and submit. Click Save All Answers to save all answers.
5/18/2021 Preview Test: BISM7206 Semester One Final Examination 2021 &...
https://learn.uq.edu.au/webapps/assessment/take/launch.jsp?course_assessment_id=_222082_1&course_id=_137038_1&content_id=_6607638_1&step=null 8/10
For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac).
From a business perspective, briey explain, why it is important to have a well-structured database. Do not write more than two sentences
to answer this question.
P 0 WORDS POWERED BY TINY
For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac).
QUESTION 36
From a business perspective, briey explain why a business organisation's data is important. Do not write more than two sentences to
answer this question.
P 0 WORDS POWERED BY TINY
3 points Save Answer
For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac).
QUESTION 37
a. Identify what type of schema is displayed above.
b. What type of modelling is this used for?
c. In your own words, identify and explain the two types of tables used in this type of schema.
Based on the following schema, answer the following questions:
P 0 WORDS POWERED BY TINY
6 points Save Answer
Question Completion Status:
Paragraph Arial 14px
Paragraph Arial 14px
Paragraph Arial 14px
Click Save and Submit to save and submit. Click Save All Answers to save all answers.
5/18/2021 Preview Test: BISM7206 Semester One Final Examination 2021 &...
https://learn.uq.edu.au/webapps/assessment/take/launch.jsp?course_assessment_id=_222082_1&course_id=_137038_1&content_id=_6607638_1&step=null 9/10
P 0 WORDS POWERED BY TINY
For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac).
QUESTION 38
a. Identify what level of normal form the above table is in and in your own words briey justify your answer.
b. The table shown above is susceptible to update anomalies. Specify three types of update anomalies and give one example of
each using the data in the above table. Start a new line for each type of anomaly.
c. Identify two transitive dependencies in the above table. List each transitive dependency on a new line.
d. In your own words, briey explain each step required to convert the above table to third normal form (3NF). Start a new line
for each step being explained and use appropriate database design terminology.
The table below displays the details of lm directors and roles played by actors/actresses in those lms.
P 0 WORDS POWERED BY TINY
10 points Save Answer
QUESTION 39
Using dot-points, identify each syntax and execution error shown in the following SQL script (write each error on a new line):
8 points Save Answer
Question Completion Status:
Paragraph Arial 14px
Click Save and Submit to save and submit. Click Save All Answers to save all answers.
5/18/2021 Preview Test: BISM7206 Semester One Final Examination 2021 &...
https://learn.uq.edu.au/webapps/assessment/take/launch.jsp?course_assessment_id=_222082_1&course_id=_137038_1&content_id=_6607638_1&step=null 10/10
For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac).
P 0 WORDS POWERED BY TINY
Question Completion Status:
Paragraph Arial 14px
Click Save and Submit to save and submit. Click Save All Answers to save all answers.
学霸联盟
https://learn.uq.edu.au/webapps/assessment/take/launch.jsp?course_assessment_id=_222082_1&course_id=_137038_1&content_id=_6607638_1&step=null 1/10
Edit Mode is: ON•
Preview Test: BISM7206 Semester One Final Examination 2021
[BISM7206] Information Retrieval and Management (external). Semester 1, 2021 BISM7206S_7120_24375 Final Exam
Preview Test: BISM7206 Semester One Final Examination 2021
Test Information
Description
Instructions
Multiple Attempts Not allowed. This test can only be taken once.
Force Completion This test can be saved and resumed later.
Your answers are saved automatically.
a.
b.
c.
d.
QUESTION 1
Big Data
relies on the use of structured data
relies on the use of unstructured data
captures data in whatever format it naturally exists
imposes a structure on data when it is captured
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 2
If a table has multiple candidate keys and one of those candidate keys is a composite key, the table can have
_____ based on this composite candidate key even when the primary key chosen is a single attribute.
redundancies
partial dependencies
Boyce-Codd normal forms
time-variances
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 3
Which of the following contains a single-part primary key that serves as an index for the fact table and
also contains other fields associated with the primary key value?
star table
dimension table
fact table
relational table
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 4
_____ deals with ensuring that data is protected against unauthorized access, and if the data are accessed by an
authorized user, that the data are used only for an authorized purpose.
Compliance
Integrity
Privacy
Confidentiality
0.5 points Save Answer
?
Question Completion Status:
Welcome Organisations Sta Help Guides System Admin
Click Save and Submit to save and submit. Click Save All Answers to save all answers.
Courses Fiona Porter
5/18/2021 Preview Test: BISM7206 Semester One Final Examination 2021 &...
https://learn.uq.edu.au/webapps/assessment/take/launch.jsp?course_assessment_id=_222082_1&course_id=_137038_1&content_id=_6607638_1&step=null 2/10
a.
b.
c.
d.
QUESTION 5
A DBMS uses a __________ technique to identify a synchronisation point between the
database and the transaction log le.
checkpointing
backup
change log
recovery
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 6
Data redundancy produces _____.
data integrity problems
efficient storage use
slower lookups
robust design
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 7
Which of the following queries will display rows in the PRODUCT table with a COLOUR_CODE not equal to
5555?
SELECT P_DESCRIPT, P_PRICE, COLOUR_CODE
FROM PRODUCT
WHERE COLOUR_CODE ≠ 5555;
SELECT P_DESCRIPT, P_PRICE, COLOUR_CODE
FROM PRODUCT
WHERE COLOUR_CODE >< 5555;
SELECT P_DESCRIPT, P_PRICE, COLOUR_CODE
FROM PRODUCT
WHERE COLOUR_CODE NOT = 5555;
SELECT P_DESCRIPT, P_PRICE, COLOUR_CODE
FROM PRODUCT
WHERE COLOUR_CODE <> 5555;
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 8
_____ can render data useless to unauthorized users who might have violated some of the database security
layers.
Physical security
Access rights
Data encryption
Password security
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 9
What is the first query known as in an SQL subquery?
left
base
outer
inner
0.5 points Save Answer
a.
b.
c.
QUESTION 10
Hadoop is generally used with a set of other related products that interact and complement each other to create an
entire suite of applications and tools. This is also known as a(n) ____________?
ecosystem
big data system
database environment
0.5 points Save Answer
Question Completion Status:
Click Save and Submit to save and submit. Click Save All Answers to save all answers.
5/18/2021 Preview Test: BISM7206 Semester One Final Examination 2021 &...
https://learn.uq.edu.au/webapps/assessment/take/launch.jsp?course_assessment_id=_222082_1&course_id=_137038_1&content_id=_6607638_1&step=null 3/10
d.
database e o e t
applications system
a.
b.
c.
d.
QUESTION 11
A distributed _____ can reference several different local or remote data processing sites.
request
transaction
data location
site
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 12
A(n) ____ condition occurs when two or more transactions wait for each other to unlock data.
exclusive lock
deadlock
two-phase lock
binary lock
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 13
_____ are designed for presenting data to the end user in a variety of ways.
Data analysis tools
ETL tools
Data stores
Data visualization tools
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 14
In business analytics, ______ uses data to understand the past and present.
Descriptive analytics
Predictive analytics
Prescriptive analytics
Diagnostic analytics
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 15
From a structural point of view, 3NF is better than _____.
4NF
2NF
5NF
6NF
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 16
A _____ contains the description of the entire database as seen by the database administrator.
distributed global dictionary
distributed global schema
distributed data dictionary
distributed data schema
0.5 points Save Answer
a.
QUESTION 17
In the context of security controls, what technique is used to determine whether a user is who he or she claims to
be?
Confidentiality
0.5 points Save Answer
Question Completion Status:
Click Save and Submit to save and submit. Click Save All Answers to save all answers.
5/18/2021 Preview Test: BISM7206 Semester One Final Examination 2021 &...
https://learn.uq.edu.au/webapps/assessment/take/launch.jsp?course_assessment_id=_222082_1&course_id=_137038_1&content_id=_6607638_1&step=null 4/10
a.
b.
c.
d.
Confidentiality
Authorization
Authentication
Encryption
a.
b.
c.
d.
QUESTION 18
Which of the following statements is correct for the SQL data manipulation command HAVING?
restricts the selection of rows based on a conditional expression.
groups the selected rows based on one or more attributes.
modifies an attribute’s values in one or more table’s rows.
restricts the selection of grouped rows based on a condition.
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 19
The first step in developing the conceptual model using Entity Relationship Diagrams is to _____.
complete the initial Entity Relationship diagram
identify, analyze, and refine the business rules
normalize the entities
define the attributes, primary keys, and foreign keys for each of the entities
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 20
The SQL command that allows a user to permanently save data changes is _____.
INSERT
COMMIT
UPDATE
SELECT
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 21
The reliance on _____ as the design methodology for relational databases is seen as a stumbling block to its use
in OLAP systems.
star schema
normalization
multidimensional schema
denormalization
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 22
The special operator used to check whether a subquery returns any rows is _____.
BETWEEN
IN
LIKE
EXISTS
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 23
A table that is in 2NF and contains no transitive dependencies is said to be in _____.
1NF
2NF
3NF
4NF
0.5 points Save Answer
a.
QUESTION 24
A trigger can be used as a security measure in which of the following ways?
To control database transactions
0.5 points Save Answer
Question Completion Status:
Click Save and Submit to save and submit. Click Save All Answers to save all answers.
5/18/2021 Preview Test: BISM7206 Semester One Final Examination 2021 &...
https://learn.uq.edu.au/webapps/assessment/take/launch.jsp?course_assessment_id=_222082_1&course_id=_137038_1&content_id=_6607638_1&step=null 5/10
b.
c.
d.
To control database transactions
To check for viruses
To execute a special procedure
To control error handling
a.
b.
c.
d.
QUESTION 25
In business analytics, ______ analyses data relating to past performance.
Predictive analytics
Descriptive analytics
Diagnostic analytics
Prescriptive analytics
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 26
Fact and dimension tables are related by _____ keys.
foreign
primary
linked
shared
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 27
In business intelligence framework, data are captured from an operational database and placed in _____.
dashboard
relational database
decision support system
data warehouse
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 28
One of the steps in the conceptual database design is:
check integrity constraints
check entity relationship model for dependencies
check for future growth
check model for redundancy
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 29
_____ transparency allows a physically dispersed database to be managed as though it were centralized.
Distribution
Transaction
Performance
Failure
0.5 points Save Answer
a.
b.
c.
d.
QUESTION 30
In the context of Big Data, _____ refers to the trustworthiness or correctness of a set of data.
variability
viability
value
veracity
0.5 points Save Answer
Question Completion Status:
Click Save and Submit to save and submit. Click Save All Answers to save all answers.
5/18/2021 Preview Test: BISM7206 Semester One Final Examination 2021 &...
https://learn.uq.edu.au/webapps/assessment/take/launch.jsp?course_assessment_id=_222082_1&course_id=_137038_1&content_id=_6607638_1&step=null 6/10
-
-
-
-
-
-
-
a.
b.
c.
d.
e.
f.
g.
h.
i.
j.
k.
QUESTION 31
Consider the following transaction schedule representing bank account transfers. The
original balance of the bank account at t1 is $120.
Using this transaction schedule, you are required to nd matching pairs. For each item
in the left-hand column, click the drop-down menu. From the drop-down menu, select
the character that corresponds to the matching item from the right-hand column. You
may use an item in the right-hand column more than once.
Time T1 T2
t1 begin_transaction
t2 read(balx) begin_transaction
t3 balx = balx + 80 read(balx)
t4 write(balx) balx = balx - 100
t5 commit write(balx)
t6 commit
balx at t2
balx at t3
balx at t4
balx at t5
balx at t6
If the nal balance was correct, what would it
be?
What is this problem known as?
Lost update
$120
Inconsistent analysis
$80
$20
$220
Correct answer is not in this list
Uncommitted dependency
The nal balance is correct
$200
$100
7 points Save Answer
-
-
-
-
-
-
-
-
-
-
a.
b.
c.
d.
e.
f.
g.
h.
i.
j.
k.
l.
m.
n.
o.
QUESTION 32
This question requires you to nd matching pairs. Using this transaction schedule, you are required to nd
matching pairs. For each item in the left-hand column, click the drop-down menu. From the drop-down
menu, select the character that corresponds to the matching item from the right-hand column. You may use
an item in the right-hand column more than once.
derived fragment
global system catalog
vertical fragment
distribution transparency
replication transparency
horizontal fragment
local conceptual schema
no fragmentation
global conceptual schema
fragmentation transparency
based on parent relation
leaves the database whole
subset of attributes
specic to distributed systems
subset of tuples
the whole database
user does not need to know that data is
fragmented
done after the logical design
ANSI-SPARC architecture
based on child relation
highest level of distribution transparency
user is unaware of fragment replication
subset of relation
external view
replicates the relation
10 points Save Answer
QUESTION 33
This question requires you to nd matching pairs. For each item in the left-hand column, click the drop-down
menu From the drop down menu select the character that corresponds to the matching item from the
9 points Save Answer
Question Completion Status:
Click Save and Submit to save and submit. Click Save All Answers to save all answers.
5/18/2021 Preview Test: BISM7206 Semester One Final Examination 2021 &...
https://learn.uq.edu.au/webapps/assessment/take/launch.jsp?course_assessment_id=_222082_1&course_id=_137038_1&content_id=_6607638_1&step=null 7/10
-
-
-
-
-
-
-
-
-
a.
b.
c.
d.
e.
f.
g.
h.
i.
j.
k.
l.
menu. From the drop-down menu, select the character that corresponds to the matching item from the
right-hand column. You may use an item in the right-hand column more than once.
Public methods
Benchmarking
Use-case driven approach
State diagram
Extensibility
Class diagram
Private methods
Sequence diagram
Object diagram
OODBMS advantage
Behavioural diagram
Comprehensive standards
UML
Structural diagram
Internal to class
DBMS performance
Constructors
Class instances
Conguration diagram
Interaction between objects
Design diagram
-
-
-
-
-
-
-
-
-
a.
b.
c.
d.
e.
f.
g.
h.
i.
j.
k.
QUESTION 34
Time T1 T2
begin_transaction
t2 read(balx)
t3 balx = balx + 50
t4 begin_transaction write(balx)
t5 read(balx) :
t6 balx = balx - 60 rollback
t7 write(balx)
t8
Consider the following transaction schedule representing bank account transfers. The
original balance of the bank account at t1 is $150.
Using this transaction schedule, you are required to nd matching pairs. For each item
in the left-hand column, click the drop-down menu. From the drop-down menu,
select the character that corresponds to the matching item from the right-hand
column. You may use an item in the right-hand column more than once.
t1
commit
balx at t2
balx at t3
balx at t4
balx at t5
balx at t6
balx at t7
balx at t8
If the nal balance was correct, what would it
be?
What is this problem known as?
$90
$200
$190
$260
$150
Inconsistent analysis
Uncommitted dependency
Lost update
$100
Correct answer is not in this list
$140
9 points Save Answer
QUESTION 35
F b i i b i l i h i i i h ll d d b D i h
3 points Save Answer
Question Completion Status:
Click Save and Submit to save and submit. Click Save All Answers to save all answers.
5/18/2021 Preview Test: BISM7206 Semester One Final Examination 2021 &...
https://learn.uq.edu.au/webapps/assessment/take/launch.jsp?course_assessment_id=_222082_1&course_id=_137038_1&content_id=_6607638_1&step=null 8/10
For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac).
From a business perspective, briey explain, why it is important to have a well-structured database. Do not write more than two sentences
to answer this question.
P 0 WORDS POWERED BY TINY
For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac).
QUESTION 36
From a business perspective, briey explain why a business organisation's data is important. Do not write more than two sentences to
answer this question.
P 0 WORDS POWERED BY TINY
3 points Save Answer
For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac).
QUESTION 37
a. Identify what type of schema is displayed above.
b. What type of modelling is this used for?
c. In your own words, identify and explain the two types of tables used in this type of schema.
Based on the following schema, answer the following questions:
P 0 WORDS POWERED BY TINY
6 points Save Answer
Question Completion Status:
Paragraph Arial 14px
Paragraph Arial 14px
Paragraph Arial 14px
Click Save and Submit to save and submit. Click Save All Answers to save all answers.
5/18/2021 Preview Test: BISM7206 Semester One Final Examination 2021 &...
https://learn.uq.edu.au/webapps/assessment/take/launch.jsp?course_assessment_id=_222082_1&course_id=_137038_1&content_id=_6607638_1&step=null 9/10
P 0 WORDS POWERED BY TINY
For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac).
QUESTION 38
a. Identify what level of normal form the above table is in and in your own words briey justify your answer.
b. The table shown above is susceptible to update anomalies. Specify three types of update anomalies and give one example of
each using the data in the above table. Start a new line for each type of anomaly.
c. Identify two transitive dependencies in the above table. List each transitive dependency on a new line.
d. In your own words, briey explain each step required to convert the above table to third normal form (3NF). Start a new line
for each step being explained and use appropriate database design terminology.
The table below displays the details of lm directors and roles played by actors/actresses in those lms.
P 0 WORDS POWERED BY TINY
10 points Save Answer
QUESTION 39
Using dot-points, identify each syntax and execution error shown in the following SQL script (write each error on a new line):
8 points Save Answer
Question Completion Status:
Paragraph Arial 14px
Click Save and Submit to save and submit. Click Save All Answers to save all answers.
5/18/2021 Preview Test: BISM7206 Semester One Final Examination 2021 &...
https://learn.uq.edu.au/webapps/assessment/take/launch.jsp?course_assessment_id=_222082_1&course_id=_137038_1&content_id=_6607638_1&step=null 10/10
For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac).
P 0 WORDS POWERED BY TINY
Question Completion Status:
Paragraph Arial 14px
Click Save and Submit to save and submit. Click Save All Answers to save all answers.
学霸联盟
