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

IS5213 Data Science and Big Data Solutions

WEEK- 2 code  install.packages("dplyr") library(dplyr) Rajeshdf = read.csv('c:\\Insurance.csv') str(Rajeshdf)                        str(Rajeshdf) summary(Rajeshdf) agg_tbl <- Rajeshdf %>% group_by(Rajeshdf$JOB) %>%    summarise(total_count=n(),             .groups = 'drop') agg_tbl a = aggregate( x=Rajeshdf$HOME_VAL, by=list( Rajeshdf$CAR_TYPE), FUN=median, na.rm=TRUE ) a QUIZ 2. What famous literary detective solved a crime because a dog did not bark at the criminal? A). Sherlock Holmes 1.  In the Insurance data set, how many Lawyers are there? A).  1031 3. What two prefixes does the instructor use for variables when fixing the missing values? Select all that apply. A). IMP_ M_ 4. What is the median Home Value of a person who drives a Van? A).  204139 5. In the insurance data set, how many missing (NA) values does the variable AGE have? A) 7   1. What...
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 t...
Post a Comment
Read more

GE5093 Design Thinking All Quizzes

  GE---5093-1D2-FA-2021 - Design Thinking Home My courses 2021-FA GE---5093-1D2-FA-2021 Week 1 Reading Quiz 1 Started on Sunday, October 31, 2021, 2:04 PM State Finished Completed on Sunday, October 31, 2021, 2:30 PM Time taken 25 mins 58 secs Grade 8.00  out of 10.00 ( 80 %) Top of Form Question  1 Correct 1.00 points out of 1.00 Flag question Question text A critical finding of Edward Lorenz related to Design Thinking was: Select one: a. An application of the caterpillar effect b. The idea of deterministic chaos or the "Butterfly Effect" c. Business leaders enjoy chaos d. Statistical modeling of weather was fairly accurate in the long term Feedback Your answer is correct. The correct answer is: The idea of deterministic chaos or the "Butterfly Effect" Question  2 Incorrect 0.00 point...
Post a Comment
Read more