тест selory / 28
.pdf
CS403: Certificate Final Exam: Attempt review | Saylor Academy |
https://learn.saylor.org/mod/quiz/review.php?attempt=1593274&cmid=23178&showall=1 |
Back to 'Certificate Final Exam\'
Started on |
Wednesday, April 20, 2022, 5:16 PM |
|
|
State |
Finished |
|
|
Completed on |
Wednesday, April 20, 2022, 5:32 PM |
|
|
Time taken |
15 mins 54 secs |
|
|
Points |
14.00/50.00 |
|
|
Grade |
2.80 out of 10.00 (28%) |
|
|
Question 1
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 2
Incorrect
0.00 points out of 1.00
Which of the following code segments best describes information?
Select one:
a. Cost = 10
b. Int X;
X = 10
c. int Dollars = 10; Print Dollars
d. Int Dollars; Dollars = 10; Cost = Dollars
Question 3
Incorrect
0.00 points out of 1.00
Your answer is incorrect.
What is one of the disadvantages of file processing systems?
Select one:
a. Low data quality
b. Limited data sharing
c. Short development time
d. Program-data independence
1 of 16 |
4/24/22, 12:24 |
CS403: Certificate Final Exam: Attempt review | Saylor Academy |
https://learn.saylor.org/mod/quiz/review.php?attempt=1593274&cmid=23178&showall=1 |
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 |
|
|
|
|
|
|
|
|
|
|
|
|
Question 5 |
|
What are databases generally used for today? |
|||
|
|
||||
Incorrect |
|
|
|
|
|
0.00 points out |
|
Select one: |
|||
of 1.00 |
|
|
|
a. |
Backing up hard drives or other storage disks |
|
|
|
|
||
|
|
|
|
b. |
Recording the behavior of real time embedded systems |
|
|
|
|
c. |
Storing and retrieving enterprise data for business systems |
|
|
|
|
d. |
Performing computations for scientific and engineering application systems |
|
|
|
|
|
|
|
|
|
|
|
|
Question 6 |
|
A DBMS primarily supports a database for which of the following activities of the database's life-cycle? |
|||
|
|
||||
Incorrect |
|
|
|
|
|
0.00 points out |
|
Select one: |
|||
of 1.00 |
|
|
|
a. |
Design |
|
|
|
|
||
|
|
|
|
b. |
Testing |
|
|
|
|
c. |
Usage |
|
|
|
|
d. |
Requirements elicitation |
|
|
|
|
|
|
|
|
|
|
|
|
Question 7 |
|
Which of the following describes a DBMS? |
|||
|
|
||||
Incorrect |
|
|
|
|
|
0.00 points out |
|
Select one: |
|||
of 1.00 |
|
|
|
a. |
A part of a database |
|
|
|
|
||
|
|
|
|
b. |
A database application |
|
|
|
|
||
|
|
|
|
c. |
An interface between applications |
|
|
|
|
d. |
An interface between a database and users of the database |
|
|
|
|
|
|
|
|
|
|
|
|
Question 8 |
|
Which kind of database corresponds to 'class'? |
|||
|
|
||||
Incorrect |
|
|
|
|
|
0.00 points out |
|
Select one: |
|||
of 1.00 |
|
|
|
a. |
Network |
|
|
|
|
||
|
|
|
|
b. |
Relational |
|
|
|
|
c. |
Hierarchical |
|
|
|
|
d. |
Object-oriented |
|
|
|
|
|
|
2 of 16 |
4/24/22, 12:24 |
CS403: Certificate Final Exam: Attempt review | Saylor Academy |
https://learn.saylor.org/mod/quiz/review.php?attempt=1593274&cmid=23178&showall=1 |
Question 9 |
|
Which of the following are the most widely-used types of database today? |
|||
|
|
||||
Incorrect |
|
|
|
|
|
0.00 points out |
|
Select one: |
|||
of 1.00 |
|
|
|
a. |
Network |
|
|
|
|
||
|
|
|
|
b. |
Relational |
|
|
|
|
c. |
Hierarchical |
|
|
|
|
d. |
Object-oriented |
|
|
|
|
|
|
|
|
|
|
|
|
Question 10 |
|
Which view in the three-level database architecture offers a formal description of the data with no concern for how it will be stored? |
|||
|
|
||||
Correct |
|
|
|
|
|
1.00 points out |
|
Select one: |
|||
of 1.00 |
|
|
|
a. |
Conceptual |
|
|
|
|
||
|
|
|
|
b. |
Data |
|
|
|
|
c. |
External |
|
|
|
|
d. |
Internal |
|
|
|
|
|
|
|
|
|
|
|
|
Question 11 |
|
What is data that describes data called? |
|||
|
|
||||
Correct |
|
|
|
|
|
1.00 points out |
|
Select one: |
|||
of 1.00 |
|
|
|
a. |
Metadata |
|
|
|
|
||
|
|
|
|
b. |
Abstract data |
|
|
|
|
c. |
Semantic data |
|
|
|
|
d. |
Referential data |
|
|
|
|
|
|
|
|
|
|
|
|
Question 12 |
|
What is commonly used to represent a relation? |
|||
|
|
||||
Incorrect |
|
|
|
|
|
0.00 points out |
|
Select one: |
|||
of 1.00 |
|
|
|
a. |
an index |
|
|
|
|
||
|
|
|
|
b. |
a schema |
|
|
|
|
||
|
|
|
|
c. |
a table |
|
|
|
|
d. |
a view |
|
|
|
|
|
|
|
|
|
|
|
|
Question 13 |
|
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 16 |
4/24/22, 12:24 |
CS403: Certificate Final Exam: Attempt review | Saylor Academy |
https://learn.saylor.org/mod/quiz/review.php?attempt=1593274&cmid=23178&showall=1 |
Question 14 |
|
What is a database view? |
|||
|
|
||||
Incorrect |
|
|
|
|
|
0.00 points out |
|
Select one: |
|||
of 1.00 |
|
|
|
a. |
a meta table |
|
|
|
|
||
|
|
|
|
b. |
a virtual table |
|
|
|
|
c. |
a copy of a table |
|
|
|
|
d. |
a pointer to a table |
|
|
|
|
|
|
|
|
|
|
|
|
Question 15 |
|
What did the predecessor to modern databases stored data in? |
|||
|
|
||||
Correct |
|
|
|
|
|
1.00 points out |
|
Select one: |
|||
of 1.00 |
|
|
|
a. |
Flat files |
|
|
|
|
||
|
|
|
|
b. |
Rough files |
|
|
|
|
c. |
Magnetic tape |
|
|
|
|
d. |
Punched cards |
|
|
|
|
|
|
|
|
|
|
|
|
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 is one of the problems with non-relational databases? |
|||
|
|
||||
Incorrect |
|
|
|
|
|
0.00 points out |
|
Select one: |
|||
of 1.00 |
|
|
|
a. |
Data dependency |
|
|
|
|
||
|
|
|
|
b. |
Limited vendor support |
|
|
|
|
||
|
|
|
|
c. |
Low speed of operation |
|
|
|
|
d. |
Structural independence |
|
|
|
|
|
|
|
|
|
|
|
|
Question 18 |
|
If you were a database consultant tasked with recommending a data model for a company that gathers data from the internet to identify information on trends in consumer behavior, which type of database would you recommend? |
|||
|
|
||||
Incorrect |
|
|
|
|
|
0.00 points out |
|
Select one: |
|||
of 1.00 |
|
|
|
a. |
Hierarchical |
|
|
|
|
||
|
|
|
|
b. |
NoSQL |
|
|
|
|
c. |
Object |
|
|
|
|
d. |
Relational |
|
|
|
|
|
|
4 of 16 |
4/24/22, 12:24 |
CS403: Certificate Final Exam: Attempt review | Saylor Academy |
https://learn.saylor.org/mod/quiz/review.php?attempt=1593274&cmid=23178&showall=1 |
Question 19
Correct
1.00 points out of 1.00
Which of the following statements describes the role of an E-R diagram in the development of a relational database?
Select one:
a. An E-R diagram is transformed into the database design.
b. An E-R diagram is transformed into the internal database.
c. An E-R diagram is transformed into the physical database.
d. An E-R diagram is used to represent the database requirements.
Question 20 |
Which of the following does this figure represent? |
|
|
Incorrect |
|
0.00 points out |
|
of 1.00 |
|
Select one: |
|||
|
|
a. |
Imaging entity |
|
|
b. |
Associative entity |
|
|
c. |
Binary relationship |
|
|
||
|
|
d. |
Ternary relationship |
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. Ternary
c. Tributary 
d. Unary
5 of 16 |
4/24/22, 12:24 |
CS403: Certificate Final Exam: Attempt review | Saylor Academy |
https://learn.saylor.org/mod/quiz/review.php?attempt=1593274&cmid=23178&showall=1 |
Question 22 |
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
Question 23
Incorrect
0.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 incorrect.
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 model, Students, Courses, and Sections called?
Select one:
a. Attributes
b. Constraints
c. Entities
d. Relations
Your answer is incorrect.
6 of 16 |
4/24/22, 12:24 |
CS403: Certificate Final Exam: Attempt review | Saylor Academy |
https://learn.saylor.org/mod/quiz/review.php?attempt=1593274&cmid=23178&showall=1 |
Question 25
Incorrect
0.00 points out of 1.00
The diagram shows a supertype/subtype relationship. Which of the following best demonstrates a mapping of this relationship?
Select one:
a. |
|
|
b.
c.
d.
Your answer is incorrect.
7 of 16 |
4/24/22, 12:24 |
CS403: Certificate Final Exam: Attempt review | Saylor Academy |
https://learn.saylor.org/mod/quiz/review.php?attempt=1593274&cmid=23178&showall=1 |
Question 26 |
The diagram contains a unary entity with a one to many relationship. Which of the following best demonstrates a mapping of this relationship? |
|
|
Incorrect |
|
0.00 points out |
|
of 1.00 |
|
Select one:
a. |
|
|
b.
c.
d.
Question 27
Incorrect
0.00 points out of 1.00
Your answer is incorrect.
Which of the following statements about domain constraints is true?
Select one:
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
8 of 16 |
4/24/22, 12:24 |
CS403: Certificate Final Exam: Attempt review | Saylor Academy |
https://learn.saylor.org/mod/quiz/review.php?attempt=1593274&cmid=23178&showall=1 |
Question 28 |
|
Which of the following does referential integrity ensure? |
|
|
|
||
Incorrect |
|
|
|
0.00 points out |
|
Select one: |
|
of 1.00 |
|
a. |
A field is not duplicated in the table |
|
|
||
|
|
b. |
Two fields are related to one another |
|
|
c. |
Field values are consistent in the table |
|
|
d. |
There are no repeating groups in the table |
|
|
|
|
|
|
|
|
Question 29 |
|
What is a tuple? |
|
|
|
||
Incorrect |
|
|
|
0.00 points out |
|
Select one: |
|
of 1.00 |
|
a. |
A field in a relation |
|
|
||
|
|
b. |
An index on a table |
|
|
c. |
A way for a database to store tables |
|
|
d. |
A collection of attributes of a relation |
|
|
|
|
|
|
|
|
Question 30 |
|
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 31
Incorrect
0.00 points out of 1.00
If we had another relation, staff, which was union compatible with faculty, what would the following expression return for a result?
Πempno (Staff Instructor)
Select one:
a. The employee number of every staff employee and every instructor
b. Every employee who is either a member of the staff or an instructor
c. All tuples of the instructor relation along with all tuples of the staff relation
d. The employee number of all rows in the staff and in the instructor relations
Question 32
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
9 of 16 |
4/24/22, 12:24 |
CS403: Certificate Final Exam: Attempt review | Saylor Academy |
https://learn.saylor.org/mod/quiz/review.php?attempt=1593274&cmid=23178&showall=1 |
Question 33 |
|
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 |
|
|
|
|
|
|
|
|
Question 34 |
|
When is a relation considered to be in first normal form (1NF)? |
|
|
|
||
Incorrect |
|
|
|
0.00 points out |
|
Select one: |
|
of 1.00 |
|
a. |
When there are no dependencies of an attribute on another attribute in the table |
|
|
||
|
|
b. |
When there are no compound primary keys or partial key that can have a null value |
|
|
c. |
When there are no partial dependencies or transitive dependencies on a primary key |
|
|
d. |
When there are no repeating groups of values of an attribute in one or more columns |
|
|
|
|
|
|
|
|
Question 35 |
|
Which of the following describes a relation is in first normal form (1NF)? |
|
|
|
||
Incorrect |
|
|
|
0.00 points out |
|
Select one: |
|
of 1.00 |
|
a. |
It has no identical rows |
|
|
||
|
|
b. |
It has no repeating groups |
|
|
c. |
It has no partial functional dependencies |
|
|
d. |
It has no transitive functional dependencies |
|
|
|
|
Question 36
Correct
1.00 points out of 1.00
Consider the following database table:
PartNo |
Description |
CustID |
Name |
QuantityOrdered |
|
|
|
|
|
2361 |
Pens |
7810 |
J. Smith |
22 |
|
|
|
|
|
2371 |
Paper Clips |
7810 |
J. Smith |
1000 |
|
|
|
|
|
2914 |
Pens |
7914 |
K. Jones |
900 |
|
|
|
|
|
If we were to delete the third row, all information about customer 7914 would be lost. Which of the following is this an example of?
Select one:
a. A deletion anomaly
b. An update anomaly
c. An insertion anomaly
d. A modification anomaly
10 of 16 |
4/24/22, 12:24 |