Skip to main content

INF503 Week 3 Quize's

 Skip to main content

INF--503-1D1-SP-2021 - Advanced Database

Started onSunday, January 30, 2022, 2:20 PM
StateFinished
Completed onSunday, January 30, 2022, 2:30 PM
Time taken9 mins 27 secs
Grade18.00 out of 20.00 (90%)

Question 1

Correct
1.00 points out of 1.00
Flag question

Question text

A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on the primary key is said to be in _____.
Select one:
a.
3NF
b.
2NF
c.
4NF
d.
1NF
Correct

Feedback

Question 2

Correct
1.00 points out of 1.00
Flag question

Question text

A table where all attributes are dependent on the primary key but are independent of each other, and no row contains two or more multivalued facts about an entity is said to be in _____.
Select one:
a.
2NF
b.
3NF
c.
4NF
Correct
d.
1NF

Feedback

Question 3

Incorrect
0.00 points out of 1.00
Flag question

Question text

A relational table must not contain a(n) _____.
Select one:
a.
entity
Incorrect
b.
relationship
c.
repeating group
d.
attribute

Feedback

Question 4

Correct
1.00 points out of 1.00
Flag question

Question text

An entity cluster is formed by combining multiple interrelated entities into _____.
Select one:
a.
multiple abstract entity objects
b.
a single entity object
c.
a single abstract entity object
Correct
d.
multiple entity objects

Feedback

Question 5

Correct
1.00 points out of 1.00
Flag question

Question text

A total completeness constraint is represented by a _____.
Select one:
a.
double horizontal line under a circle
Correct
b.
smaller circle inside a bigger circle
c.
rhombus inside a circle
d.
single horizontal line above a circle

Feedback

Question 6

Correct
1.00 points out of 1.00
Flag question

Question text

A table that is in 2NF and contains no transitive dependencies is said to be in _____.
Select one:
a.
1NF
b.
2NF
c.
3NF
Correct
d.
4NF

Feedback

Question 7

Correct
1.00 points out of 1.00
Flag question

Question text

An atomic attribute _____.
Select one:
a.
is always chosen to be a foreign key
b.
cannot be further subdivided
Correct
c.
displays multiplicity
d.
cannot exist in a relational table

Feedback

Question 8

Correct
1.00 points out of 1.00
Flag question

Question text

An attribute that is part of a key is known as a(n) _____ attribute.
Select one:
a.
important
b.
prime
Correct
c.
nonprime
d.
entity

Feedback

Question 9

Incorrect
0.00 points out of 1.00
Flag question

Question text

A _____ key is a real-world, generally accepted identifier used to uniquely identify real-world objects.
Select one:
a.
surrogate
Incorrect
b.
primary
c.
foreign
d.
natural

Feedback

Question 10

Correct
1.00 points out of 1.00
Flag question

Question text

A table is in 4NF if it is in 3NF, and _____.
Select one:
a.
it has no multivalued dependencies
Correct
b.
no column contains the same values
c.
all attributes are unrelated
d.
all attributes must be dependent on the primary key and must be dependent on each other

Feedback

Question 11

Correct
1.00 points out of 1.00
Flag question

Question text

_____ is the bottom-up process of identifying a higher-level, more generic entity supertype from lower-level entity subtypes.
Select one:
a.
Normalization
b.
Generalization
Correct
c.
Total completeness
d.
Specialization

Feedback

Question 12

Correct
1.00 points out of 1.00
Flag question

Question text

A(n)_____ is a generic entity type that is related to one or more entity subtypes.
Select one:
a.
entity supertype
Correct
b.
specialization hierarchy
c.
subtype discriminator
d.
inheritance

Feedback

Question 13

Correct
1.00 points out of 1.00
Flag question

Question text

A specialization hierarchy can have _____ level(s) of supertype/subtype relationships.
Select one:
a.
one or many
b.
zero
c.
only one
d.
many
Correct

Feedback

Question 14

Correct
1.00 points out of 1.00
Flag question

Question text

A(n) _____ is the attribute in the supertype entity that determines to which entity subtype each supertype occurrence is related.
Select one:
a.
entity supertype
b.
specialization hierarchy
c.
inheritance discriminator
d.
subtype discriminator
Correct

Feedback

Question 15

Correct
1.00 points out of 1.00
Flag question

Question text

A(n) _____ exists when there are functional dependencies such that Y is functionally dependent on X, Z is functionally dependent on Y, and X is the primary key.
Select one:
a.
repeating group
b.
partial dependency
c.
transitive dependency
Correct
d.
atomic attribute

Feedback

Question 16

Correct
1.00 points out of 1.00
Flag question

Question text

A _____ derives its name from the fact that a collection of multiple entries of the same type can exist for any single key attribute occurrence.
Select one:
a.
partial dependency
b.
primary key
c.
repeating group
Correct
d.
transitive dependency

Feedback

Question 17

Correct
1.00 points out of 1.00
Flag question

Question text

A _____ is a primary key created by a database designer to simplify the identification of entity instances. 
Select one:
a.
natural key
b.
compound key
c.
composite key
d.
surrogate key
Correct

Feedback

Question 18

Correct
1.00 points out of 1.00
Flag question

Question text

_____ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely.
Select one:
a.
Temporary
b.
Data warehouse
Correct
c.
Normalized
d.
Report

Feedback

Question 19

Correct
1.00 points out of 1.00
Flag question

Question text

A partial completeness constraint is represented by _____.
Select one:
a.
a dotted line
b.
two dashed lines
c.
a double horizontal line over a circle
d.
a single horizontal line under a circle
Correct

Feedback

Question 20

Correct
1.00 points out of 1.00
Flag question

Question text

According to the "preferably single-attribute" characteristic of a primary key, the primary key:
Select one:
a.
must be composed of attributes that are free from security risks or violations.
b.
must be able to guarantee unique attribute values. 
c.
should have embedded semantic meaning associated with each attribute.
d.
should have the minimum number of attributes possible. 
Correct

Feedback

Finish review
















































Comments

Post a Comment

Popular posts from this blog

IS5203 Type 2 Post Assessment and Final Quiz

  Carlos has just created a new subnet for the finance department. He needs to be able to allow the employees in finance to retrieve files from the sales server, which is located in another subnet. Which of the following OSI model layers would it be necessary to categorize the device into? a. Layer 4 b. Layer 6 c. Layer 2 d. Layer 3 All of the cubicles in a company's office have cables that run up to the ceiling and across to an IDF. Inside the IDF, they connect directly to the latest generation switch available from the networking equipment vendor that they have chosen. Which of the following describes the physical topology most likely in use? a. mesh
Post a Comment
Read more

GE5103-2 Project Management [Aug 23 Syllabus]

    Some of the advantages of using time boxes and cycles in project coordination efforts include creating urgency, measuring progress, and allowing for predictable measurements. A)        True 2.    Even though most project managers are not contract specialists, they need to understand the process well enough to coordinate with the team. For the current assignment, you are looking at a short-term and small effort with a contractor of just a few hours without significant clarity. Which of the following would be the most applicable contract to use in this situation? A)        Time and materials 3. The project you are working on has had modifications to the plan from the start and even how the project is run. Project governance covers all of the 3 following except: A)        Naming The project manager 4. Of the following, which is most likely a trigger condition defined early in the project? A) Alerting Governance board if 10 percent over schedule 5. Of the following options, which stand
Post a Comment
Read more

GE5163 Week8 ( Final Exam ) Quize's

  A process or product that is insensitive to normal variation is referred to as being Select one: a. in specification b. capable c. robust d. out of control Feedback Your answer is correct. A completed failure mode and effects analysis (FMEA) results in the following assessment rating.      Occurrence = 4      Severity = 8      Detection = 10 What is the risk priority number (RPN) for this FMEA? Select one: a. 42 b. 22 c. 320 d. 120 Feedback Your answer is correct. In a visual inspection situation, one of the best ways to minimize deterioration of the quality level is to: Select one: a. have a program of frequent eye exams. b. retrain the inspector frequently. c. add variety to the task. d. have a standard to compare against as an element of the operation. Feedback Your answer is correct. Which of the following elements is least necessary to a good corrective action feedback report? Select one: a. What caused the failure b. Who caused the failure c. What correction has been made d. Wh
Post a Comment
Read more