Добавил:

Aleksellion Опубликованный материал нарушает ваши авторские права? Сообщите нам.

Вуз:

Санкт-Петербургский политехнический университет Петра Великого (бывш. СПбГПУ)

Предмет:

Базы данных

Файл:

тест selory / 74

.pdf

Скачиваний:

Добавлен:

26.05.2023

Размер:

274.46 Кб

Скачать

☆

1 / 21 2 > Следующая >>>

CS403: Certiﬁcate Final Exam: Attempt review | Saylor Academy

https://learn.saylor.org/mod/quiz/review.php?attempt=1608448&cmid=23178&showall=1

Back to 'Certificate Final Exam\'

Started on	Wednesday, April 27, 2022, 5:38 PM

State	Finished

Completed on	Wednesday, April 27, 2022, 6:03 PM

Time taken	24 mins 43 secs

Points	37.00/50.00

Grade	7.40 out of 10.00 (74%)

Question 1

Correct

1.00 points out of 1.00

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

Your answer is correct.

Which of the following selections best describes information?

Select one:

a. Letters

b. Data plus semantics

c. Letters that spell a word

d. A number and its data type

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.

1 of 16

4/27/22, 18:03

CS403: Certiﬁcate Final Exam: Attempt review | Saylor Academy

https://learn.saylor.org/mod/quiz/review.php?attempt=1608448&cmid=23178&showall=1

Question 4	Which of the following best describes a database?
	Which of the following best describes a database?
Correct
1.00 points out	Select one:
of 1.00	a.	A system for managing data
	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 5	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
	a.	integrated and shared
	b.	redundant and accurate
	c.	functional and redundant
	d.	transactional and unconstrained


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
	a.	Primary keying
	b.	Check constraints
	c.	Referential integrity
	d.	Field-level validations


Question 7	One function of a DBMS is provision of which of the following?

Correct
1.00 points out	Select one:
of 1.00	a.	Data security
	a.	Data security
	b.	Data accuracy
	c.	Data redundancy
	d.	Data dependence


Question 8	Which kind of database corresponds to 'graph'?
	Which kind of database corresponds to 'graph'?
Incorrect
0.00 points out	Select one:
of 1.00	a.	Network
	a.	Network
	b.	Relational
	c.	Hierarchical
	d.	Object-oriented

2 of 16

4/27/22, 18:03

CS403: Certiﬁcate Final Exam: Attempt review | Saylor Academy

https://learn.saylor.org/mod/quiz/review.php?attempt=1608448&cmid=23178&showall=1

Question 9	Which kind of database corresponds to 'class'?
	Which kind of database corresponds to 'class'?
Correct
1.00 points out	Select one:
of 1.00	a.	Network
	a.	Network
	b.	Relational
	c.	Hierarchical
	d.	Object-oriented


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
	a.	Conceptual
	b.	External
	c.	Individual
	d.	Internal


Question 11	What is data that describes data called?
	What is data that describes data called?
Correct
1.00 points out	Select one:
of 1.00	a.	Metadata
	a.	Metadata
	b.	Abstract data
	c.	Semantic data
	d.	Referential data


Question 12	Indices are useful for searching a database because they decrease which of the following?

Correct
1.00 points out	Select one:
of 1.00	a.	query complexity
	a.	query complexity
	b.	search time for certain types of queries
	c.	the amount of storage used in searching a database
	d.	the design effort needed for developing the database search algorithms


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
	a.	a key
	b.	a field value
	c.	a field name
	d.	a query value

3 of 16

4/27/22, 18:03

CS403: Certiﬁcate Final Exam: Attempt review | Saylor Academy

https://learn.saylor.org/mod/quiz/review.php?attempt=1608448&cmid=23178&showall=1

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
	a.	foreign
	b.	hash
	c.	national
	d.	primary


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
	a.	Hierarchical
	b.	Network
	c.	Relational
	d.	Theoretical


Question 16	If you were a database consultant tasked with recommending a data model for storing parts shared by large machinery for a manufacturing company, which of the following types of database would you recommend?

Correct
1.00 points out	Select one:
of 1.00	a.	Network
	a.	Network
	b.	NoSQL
	c.	Object
	d.	Relational


Question 17	"Design" corresponds to which of the following database terms?

Incorrect
0.00 points out	Select one:
of 1.00	a.	Internal view
	a.	Internal view
	b.	External view
	c.	Conceptual schema
	d.	Data management language


Question 18	"User interface" corresponds to which of the following database terms?

Correct
1.00 points out	Select one:
of 1.00	a.	Subschema
	a.	Subschema
	b.	External view
	c.	Network schema
	d.	Data management language

4 of 16

4/27/22, 18:03

CS403: Certiﬁcate Final Exam: Attempt review | Saylor Academy

https://learn.saylor.org/mod/quiz/review.php?attempt=1608448&cmid=23178&showall=1

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
		a. A model of a database
		b. A design of a database
		c. A diagram of a database
		d. A specification of database requirements


Question 20		In this figure, which of the following is a candidate key?
		In this figure, which of the following is a candidate key?
Incorrect
0.00 points out
of 1.00

Select one:

a. Name

b. License

c. SocSec# d. StudentId

Question 21	On an ER diagram, which shape is used to represent an entity?

Correct
1.00 points out	Select one:
of 1.00	a.	Circle
	a.	Circle
	b.	Diamond
	c.	Oval
	d.	Rectangle

5 of 16

4/27/22, 18:03

CS403: Certiﬁcate Final Exam: Attempt review | Saylor Academy

https://learn.saylor.org/mod/quiz/review.php?attempt=1608448&cmid=23178&showall=1

Question 22	What kind of relationship is this figure an example of?
	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

Correct

1.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 relation what are Students, Courses, and Sections called?

Select one:

a. Attributes

b. Constraints

c. Entities

d. Relations

Your answer is correct.

6 of 16

4/27/22, 18:03

CS403: Certiﬁcate Final Exam: Attempt review | Saylor Academy

https://learn.saylor.org/mod/quiz/review.php?attempt=1608448&cmid=23178&showall=1

Question 25

Incorrect

0.00 points out of 1.00

The diagram contains a unary entity which has a many-to-many relationship. Which of the following best demonstrates a mapping of the ERD to relations?

Select one:

b.

Your answer is incorrect.

7 of 16

4/27/22, 18:03

CS403: Certiﬁcate Final Exam: Attempt review | Saylor Academy

https://learn.saylor.org/mod/quiz/review.php?attempt=1608448&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 many relationship, and four possible ways to map the diagram to a set of relations. Which mapping is correct?

Select one:

c.

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 16

4/27/22, 18:03

CS403: Certiﬁcate Final Exam: Attempt review | Saylor Academy

https://learn.saylor.org/mod/quiz/review.php?attempt=1608448&cmid=23178&showall=1

Question 28	Which of the following is an additional constraint that is added by users or database administrators?

Correct
1.00 points out	Select one:
of 1.00	a.	Entity integrity
	a.	Entity integrity
	b.	Domain integrity
	c.	Semantic integrity
	d.	Referential integrity


Question 29	What is relational algebra?
	What is relational algebra?
Correct
1.00 points out	Select one:
of 1.00	a.	The mathematical basis for SQL
	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

In relational algebra, how would one select just the name from the student relation?

Select one:

a. Π (Student)

b. Π (Course)

c. ΠName (Student)

d. σname (Student)

Question 31

Correct

1.00 points out of 1.00

Question 32

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

What would the following operation produce for output?

πdescription,name((course course.courseid = registration.courseid registration) sid = student.sid student)

Select one:

a. All course descriptions and names of all students

b. Registered students and all the course descriptions

c. All student names and all courses that are registered d. Registered students and descriptions of their courses

9 of 16

4/27/22, 18:03

student.sid = course.sid

CS403: Certiﬁcate Final Exam: Attempt review | Saylor Academy

https://learn.saylor.org/mod/quiz/review.php?attempt=1608448&cmid=23178&showall=1

Question 33

Correct

1.00 points out of 1.00

Which of the following is this operation an example of?

Student Course

Select one:

a. An equijoin

b. A hash join

c. A theta join

d. Aa natural join

Question 34	In what normal form is the relation in the figure?
	In what normal form is the relation in the figure?
Correct
1.00 points out
of 1.00
	Select one:
	Select one:
	a.	First normal form
	b.	Second normal form
	c.	Third normal form
	d.	Boyce-Codd normal form


Question 35	A relation is considered to be in Boyce-Codd normal form if and only if which of the following applies?

Correct
1.00 points out	Select one:
of 1.00	a.	It is in fourth normal form
	a.	It is in fourth normal form
	b.	There are transitive dependencies
	c.	Every determinant is a candidate key
	d.	There are some partial functional dependencies

Question 36

Incorrect

0.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

Since the primary key is made up of PartNo and CustID, we cannot insert a new part without adding an associated customer. Which of the following is this an example of?

Select one:

a. A non-normal form

b. A deletion anomaly c. An update anomaly

d. An insertion anomaly

10 of 16

4/27/22, 18:03

1 / 21 2 > Следующая >>>

Соседние файлы в папке тест selory

#
26.05.2023316.78 Кб2724.pdf
#
26.05.2023307.8 Кб1928.pdf
#
26.05.2023300.28 Кб2052.pdf
#
26.05.2023272.77 Кб2470.pdf
#
26.05.2023274.46 Кб1974.pdf
#
26.05.2023312.53 Кб1994.pdf