тест selory / 70
.pdf
CS403: Certificate Final Exam: Attempt review | Saylor Academy |
https://learn.saylor.org/mod/quiz/review.php?attempt=1602447&cmid=23178&showall=1 |
Back to 'Certificate Final Exam\'
Started on |
Sunday, April 24, 2022, 8:01 AM |
|||
|
|
|
|
|
|
State |
Finished |
||
|
|
|
|
|
Completed on |
Sunday, April 24, 2022, 8:19 AM |
|||
|
|
|
|
|
Time taken |
17 mins 54 secs |
|||
|
|
|
|
|
Points |
35.00/50.00 |
|||
|
|
|
|
|
Grade |
7.00 out of 10.00 (70%) |
|||
|
|
|
|
|
|
|
|
|
|
Question 1 |
|
|
What is one of the disadvantages of file processing systems? |
|
|
|
|
||
Correct |
|
|
|
|
1.00 points out |
|
|
Select one: |
|
of 1.00 |
|
|
a. |
Low data quality |
|
|
|
||
|
|
|
b. Limited data sharing |
|
|
|
|
c. |
Short development time |
|
|
|
d. Program-data independence |
|
|
|
|
|
|
Question 2
Correct
1.00 points out of 1.00
Which of the following is data?
Select one: 
a. 32
b. I am 32
c. It is 32 degrees.
d. It is 32 outside.
Question 3
Correct
1.00 points out of 1.00
Which of the following is information?
Select one:
a. 32
b. It is 32.
c. It is 32 degrees.
d. It is 32 degrees Fahrenheit.
Question 4 |
|
Which of the following sets of terms describes the data in a database? |
|
|
|
||
Correct |
|
|
|
1.00 points out |
|
Select one: |
|
of 1.00 |
|
a. |
integrated and shared |
|
|
||
|
|
b. |
redundant and accurate |
|
|
c. |
functional and redundant |
|
|
d. |
transactional and unconstrained |
|
|
|
|
1 of 15 |
4/24/22, 15:23 |
CS403: Certificate Final Exam: Attempt review | Saylor Academy |
https://learn.saylor.org/mod/quiz/review.php?attempt=1602447&cmid=23178&showall=1 |
Question 5 |
|
Which of the following best describes a database? |
|
|
|
||
Correct |
|
|
|
1.00 points out |
|
Select one: |
|
of 1.00 |
|
a. |
A system for managing data |
|
|
||
|
|
b. |
A set of data for a particular application |
|
|
c. |
A major subsystem of an operating system |
|
|
d. |
A reusable, organized collection of related data |
|
|
|
|
|
|
|
|
Question 6 |
|
What is used in DBMSes to make sure that data are accurate and consistent? |
|
|
|
||
Incorrect |
|
|
|
0.00 points out |
|
Select one: |
|
of 1.00 |
|
a. |
Primary keying |
|
|
||
|
|
b. |
Check constraints |
|
|
c. |
Referential integrity |
|
|
d. |
Field-level validations |
|
|
|
|
|
|
|
|
Question 7 |
|
To support concurrent transactions, a DBMS should have which of the following properties? |
|
|
|
||
Correct |
|
|
|
1.00 points out |
|
Select one: |
|
of 1.00 |
|
a. |
atomicity, durability, and isolation |
|
|
||
|
|
b. |
atomicity, irreducibility, and isolation |
|
|
c. |
durability, irreducibility, and isolation |
|
|
d. |
atomicity, durability, and irreducibility |
|
|
|
|
|
|
|
|
Question 8 |
|
Which of the following are generic database architectures? |
|
|
|
||
Correct |
|
|
|
1.00 points out |
|
Select one: |
|
of 1.00 |
|
a. |
Distributed and leased |
|
|
||
|
|
b. |
Centralized and leased |
|
|
c. |
Centralized and distributed |
|
|
d. |
Centralized and networked |
|
|
|
|
|
|
|
|
Question 9 |
|
Which of the following are the most widely-used types of database today? |
|
|
|
||
Correct |
|
|
|
1.00 points out |
|
Select one: |
|
of 1.00 |
|
a. |
Network |
|
|
||
|
|
b. |
Relational |
|
|
c. |
Hierarchical |
|
|
d. |
Object-oriented |
|
|
|
|
2 of 15 |
4/24/22, 15:23 |
CS403: Certificate Final Exam: Attempt review | Saylor Academy |
https://learn.saylor.org/mod/quiz/review.php?attempt=1602447&cmid=23178&showall=1 |
Question 10 |
|
Which level of the three-level database architecture deals with how the user sees data? |
|
|
|
||
Incorrect |
|
|
|
0.00 points out |
|
Select one: |
|
of 1.00 |
|
a. |
Conceptual |
|
|
||
|
|
b. |
External |
|
|
c. |
Individual |
|
|
d. |
Internal |
|
|
|
|
|
|
|
|
Question 11 |
|
Which of the following describes the capability to change the physical schema of a database without having to rewrite application programs? |
|
|
|
||
Correct |
|
|
|
1.00 points out |
|
Select one: |
|
of 1.00 |
|
a. |
Logical data independence |
|
|
||
|
|
b. |
Physical data dependence |
|
|
c. |
Physical data independence |
|
|
d. |
Physical schema refinement |
|
|
|
|
|
|
|
|
Question 12 |
|
What is commonly used to represent a relation? |
|
|
|
||
Correct |
|
|
|
1.00 points out |
|
Select one: |
|
of 1.00 |
|
a. |
an index |
|
|
||
|
|
b. |
a schema |
|
|
c. |
a table |
|
|
d. |
a view |
|
|
|
|
|
|
|
|
Question 13 |
|
What is a value that a DBMS maps to a single element of a relation? |
|
|
|
||
Correct |
|
|
|
1.00 points out |
|
Select one: |
|
of 1.00 |
|
a. |
a key |
|
|
||
|
|
b. |
a field value |
|
|
c. |
a field name |
|
|
d. |
a query value |
|
|
|
|
|
|
|
|
Question 14 |
|
A link can be established between two tables by the use of what kind of key? |
|
|
|
||
Correct |
|
|
|
1.00 points out |
|
Select one: |
|
of 1.00 |
|
a. |
foreign |
|
|
||
|
|
b. |
hash |
|
|
c. |
national |
|
|
d. |
primary |
|
|
|
|
3 of 15 |
4/24/22, 15:23 |
CS403: Certificate Final Exam: Attempt review | Saylor Academy |
https://learn.saylor.org/mod/quiz/review.php?attempt=1602447&cmid=23178&showall=1 |
Question 15 |
|
IMS is an example of a database system that implemented which of the following models? |
|
|
|
||
Correct |
|
|
|
1.00 points out |
|
Select one: |
|
of 1.00 |
|
a. |
Hierarchical |
|
|
||
|
|
b. |
Network |
|
|
c. |
Relational |
|
|
d. |
Theoretical |
|
|
|
|
|
|
|
|
Question 16 |
|
If you were a database consultant tasked with recommending a data model for organizing book records for a library, which of the following types of database would you recommend? |
|
|
|
||
Correct |
|
|
|
1.00 points out |
|
Select one: |
|
of 1.00 |
|
a. |
Hierarchical |
|
|
||
|
|
b. |
NoSQL |
|
|
c. |
Object |
|
|
d. |
Relational |
|
|
|
|
|
|
|
|
Question 17 |
|
Which of the following statements best describes object-relational databases? |
|
|
|
||
Correct |
|
|
|
1.00 points out |
|
Select one: |
|
of 1.00 |
|
a. |
They have little vendor support |
|
|
||
|
|
b. |
They integrate multiple paradigms |
|
|
c. |
They cannot be easily implemented |
|
|
d. |
They integrate incompatible paradigms |
|
|
|
|
|
|
|
|
Question 18 |
|
Object-oriented databases were not initially commercially successful for which of the following reasons? |
|
|
|
||
Correct |
|
|
|
1.00 points out |
|
Select one: |
|
of 1.00 |
|
a. |
They had high transition costs |
|
|
||
|
|
b. |
They had overly lengthy queries |
|
|
c. |
They were difficult to understand |
|
|
d. |
They were incompatible with many applications |
|
|
|
|
|
|
|
|
Question 19 |
|
Which of the following is an example of a use of an E-R diagram? |
|
|
|
||
Correct |
|
|
|
1.00 points out |
|
Select one: |
|
of 1.00 |
|
a. |
A model of a database |
|
|
||
|
|
b. |
A design of a database |
|
|
c. |
A diagram of a database |
|
|
d. |
A specification of database requirements |
|
|
|
|
4 of 15 |
4/24/22, 15:23 |
CS403: Certificate Final Exam: Attempt review | Saylor Academy |
https://learn.saylor.org/mod/quiz/review.php?attempt=1602447&cmid=23178&showall=1 |
Question 20 |
In this figure, what is TextBook an example of? |
|
|
Incorrect |
|
0.00 points out |
|
of 1.00 |
|
Select one:
a. Primary key
b. Ccomposite key
c. Multivalued attribute
d. Single-valued attribute
Question 21 |
What kind of relationship is this figure an example of? |
|
|
Incorrect |
|
0.00 points out |
|
of 1.00 |
|
Select one:
a. Binary
b. Singleton
c. Ternary
d. Unary
5 of 15 |
4/24/22, 15:23 |
CS403: Certificate Final Exam: Attempt review | Saylor Academy |
https://learn.saylor.org/mod/quiz/review.php?attempt=1602447&cmid=23178&showall=1 |
Question 22 |
What kind of relationship is this figure an example of? |
|
|
Correct |
|
1.00 points out |
|
of 1.00 |
|
Select one:
a. Unary
b. One to all
c. One to one
d. One to many
Question 23
Correct
1.00 points out of 1.00
Question 24
Incorrect
0.00 points out of 1.00
Which of the following can we use to indicate whether an entity instance is mandatory?
Select one:
a. Cardinality
b. Optionality
c. Disjointedness
d. Referential integrity
Your answer is correct.
You have an application domain that consists of Cities, Towns, and Neighborhoods. A City has a name, zip code, state, and a country. A Town has a name, zip code, state, and country. A Neighborhood has a name, coordinate, and population. Using a relational m Students, Courses, and Sections called?
Select one:
a. Attributes
b. Constraints
c. Entities
d. Relations
Your answer is incorrect.
6 of 15 |
4/24/22, 15:23 |
CS403: Certificate Final Exam: Attempt review | Saylor Academy |
https://learn.saylor.org/mod/quiz/review.php?attempt=1602447&cmid=23178&showall=1 |
Question 25
Correct
1.00 points out of 1.00
The diagram contains a unary entity with a one to many relationship. Which of the following best demonstrates a mapping of this relationship?
Select one:
a.
b.
c. |
|
|
d.
Your answer is correct.
7 of 15 |
4/24/22, 15:23 |
CS403: Certificate Final Exam: Attempt review | Saylor Academy |
https://learn.saylor.org/mod/quiz/review.php?attempt=1602447&cmid=23178&showall=1 |
Question 26
Incorrect
0.00 points out of 1.00
Question 27
Incorrect
0.00 points out of 1.00
This figure shows an ER diagram that contains a one-to-one relationship and four possible ways to map the diagram to a set of relations. Which is the correct solution to mapping this ER diagram to a set of relations?
Select one:
a.
b. |
|
|
c.
d.
Your answer is incorrect.
What constraint type does the following constraint belong to?
"Every table must have a primary key, of which no part can be null."
Select one:
a. Entity integrity
b. Domain integrity
c. Semantic integrity
d. Referential integrity
8 of 15 |
4/24/22, 15:23 |
CS403: Certificate Final Exam: Attempt review | Saylor Academy |
https://learn.saylor.org/mod/quiz/review.php?attempt=1602447&cmid=23178&showall=1 |
Question 28 |
|
Which of the following statements about domain constraints is true? |
|
|
|
||
Correct |
|
|
|
1.00 points out |
|
Select one: |
|
of 1.00 |
|
a. |
They cannot be used in most modern database systems |
|
|
||
|
|
b. |
They ensure values entered into a table satisfy conditions |
|
|
c. |
They can only check numeric values for arithmetic relations |
|
|
d. |
They cannot always be implemented in some SQL implementations |
|
|
|
|
|
|
|
|
Question 29 |
|
What is relational algebra? |
|
|
|
||
Correct |
|
|
|
1.00 points out |
|
Select one: |
|
of 1.00 |
|
a. |
The mathematical basis for SQL |
|
|
||
|
|
b. |
A language used to store data in a database |
|
|
c. |
The translation of a query by an SQL compiler |
|
|
d. |
An informal way to describe how a database works |
|
|
|
|
Question 30
Correct
1.00 points out of 1.00
Which is the correct expression to find all students registered for CS403?
Select one:
a. σcourse_id="CS403" (course)
b. σdescription="CS403" (course)
c. σcourse_id = "CS403" (registration)
d. σdescription="CS403" (registration)
Question 31
Correct
1.00 points out of 1.00
Assuming that we have an additional relation called staff which is union compatible with faculty, what will the following operation result in?
Πname (Staff Instructor)
Select one:
a. No rows being printed
b. The cartesian product of instructor and staff
c. All rows of instructor being added to all rows of staff
d. The name of all rows which are in both staff and instructor
Question 32 |
|
Which of the following is Student Courses an example of? |
|
|
|
||
Incorrect |
|
|
|
0.00 points out |
|
Select one: |
|
of 1.00 |
|
a. |
A theta join |
|
|
||
|
|
b. |
An inner join |
|
|
c. |
A natural join |
|
|
d. |
A cartesian product |
|
|
|
|
9 of 15 |
4/24/22, 15:23 |
CS403: Certificate Final Exam: Attempt review | Saylor Academy |
https://learn.saylor.org/mod/quiz/review.php?attempt=1602447&cmid=23178&showall=1 |
Question 33
Incorrect
0.00 points out of 1.00
Which of the following is this operation an example of?
ΠName(Student) ΠCourseID(Course)
Select one:
a. An equijoin
b. A theta join
c. A natural join
d. A cartesian product
Question 34 |
In what normal form is the relation in the figure? |
|
|
||
Correct |
|
|
1.00 points out |
|
|
of 1.00 |
|
|
|
Select one: |
|
|
||
|
a. |
First normal form |
|
b. |
Second normal form |
|
c. |
Third normal form |
d. Boyce-Codd normal form
Question 35 |
|
What is the highest normal form that all relations in the diagram are in? |
|
|
|
||
Incorrect |
|
|
|
0.00 points out |
|
|
|
of 1.00 |
|
|
|
|
|
Select one: |
|
|
|
||
|
|
a. |
First normal form |
|
|
b. |
Third normal form |
|
|
c. |
Fourth normal form |
|
|
d. |
Boyce-Codd normal form |
|
|
|
|
|
|
|
|
Question 36 |
|
When is a relation considered to be in second normal form (2NF)? (Select the best answer.) |
|
|
|
||
Correct |
|
|
|
1.00 points out |
|
Select one: |
|
of 1.00 |
|
a. |
When there are no repeating groups in a relation |
|
|
||
|
|
b. |
When there are no transitive functional dependencies |
|
|
c. |
When there are no dependencies on part of the primary key |
|
|
d. |
When there are no dependent attributes in transitive relation |
|
|
|
|
10 of 15 |
4/24/22, 15:23 |