CS403: Introduction to Modern Database Systems Final Exams Answers

Posted on by

Though we may not recognise them in our everyday activities, databases are everywhere. They are hidden behind your online banking profile, airline reservation systems, medical records, and even employment records. This course will provide a general overview of databases, introducing you to database history, modern database systems, the different models used to design a database, and Structured Query Language (SQL), which is the standard language used to access and manipulate databases. Many of the principles of database systems carry to other areas in computer science, especially operating systems. Databases are often thought of as one of the core computer science topics since many other areas in the discipline have been derived from this area.

To effectively use this website to answer your alison questions with ease, checkout this short tutorial I put together to help you in the video below.

Question 1

Question text

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 2

Question text

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

Question 3

Question text

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 4

Question text

What are databases generally used for today?
Select one:

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 5

Question text

Which of the following sets of terms describes the data in a database?
Select one:

a. integrated and shared

b. redundant and accurate

c. functional and redundant

d. transactional and unconstrained

Question 6

Question text

A DBMS primarily supports a database for which of the following activities of the database’s life-cycle?
Select one:

a. Design

b. Testing

c. Usage

d. Requirements elicitation

Question 7

Question text

One function of a DBMS is provision of which of the following?
Select one:

a. Data security

b. Data accuracy

c. Data redundancy

d. Data dependence

Question 8

Question text

What kind of database corresponds to ‘table’?
Select one:

a. Network

b. Relational

c. Hierarchical

d. Object-oriented

Question 9

Question text

Which kind of database corresponds to ‘class’?
Select one:

a. Network

b. Relational

c. Hierarchical

d. Object-oriented

 

Question 10

Question text

Which level of the three-level database architecture deals with how the user sees data?
Select one:

a. Conceptual

b. External

c. Individual

d. Internal

Question 11

Question text

What is data that describes data called?
Select one:

a. Metadata

b. Abstract data

c. Semantic data

d. Referential data

Question 12

Question text

What is a database view?
Select one:

a. a meta table

b. a virtual table

c. a copy of a table

d. a pointer to a table

Question 13

Question text

A link can be established between two tables by the use of what kind of key?
Select one:

a. foreign

b. hash

c. national

d. primary

Question 14

Question text

What is commonly used to represent a relation?
Select one:

a. an index

b. a schema

c. a table

d. a view

Question 15

Question text

What did the predecessor to modern databases stored data in?
Select one:

a. Flat files

b. Rough files

c. Magnetic tape

d. Punched cards

Question 19

Question text

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

Question text

In this figure, what is TextBook an example of?

Select one:

a. Primary key

b. Composite key

c. Multivalued attribute

d. Single-valued attribute

Question 21

Question text

On an ER diagram, which shape is used to represent an entity?
Select one:

a. Circle

b. Diamond

c. Oval

d. Rectangle

Question 22

Question text

What kind of relationship is this figure an example of?

Select one:

a. Unary

b. One to all

c. One to one

d. One to many

Question 23

Question text

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

Question 24

Question text

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

Select one:

a. Attributes

b. Constraints

c. Entities

d. Relations

Question 25

Question text

Which of the following describes the capability to change the physical schema of a database without having to rewrite application programs?
Select one:
a. Logical data independence
b. Physical data dependence
c. Physical data independence
d. Physical schema refinement

Question 26

Question text

Question 27

Question text

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

Question 28

Question text

What is a value that a DBMS maps to a single element of a relation?
Select one:
a. a key
b. a field value
c. a field name
d. a query value

Question 29

Question text

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 30

Question text

What is relational algebra?
Select one:

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

Question text

What are rules that are valid for information in a database called?
Select one:
a. constructs
b. constraints
c. foreign keys
d. primary keys

 

Question 32

Question text

Which of the following is Student ⨯ Courses an example of?
Select one:

a. A theta join

b. An inner join

c. A natural join

d. A cartesian product

 

Question 33

Question text

Which of the following is this operation an example of?

Student ⋈ student.sid = course.sid Course

Select one:

a. An equijoin

b. A hash join

c. A theta join

d. A natural join

Question 34

Question text

In what normal form is the relation in the figure?

Select one:

a. First normal form

b. Second normal form

c. Third normal form

d. Boyce-Codd normal form

Question 35

Question text

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

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

Question text

Which of the following terms describes one attribute (or field) that determines the value of another attribute?
Select one:

a. Foreign key

b. Primary key

c. Independent key

d. Functional dependency

 

Question 37

Question text

When is a relation considered to be in second normal form (2NF)? (Select the best answer.)
Select one:

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

Question 38

Question text

Question 39

Question text

Which of the following is a data definition command?
Select one:

a. Insert

b. Select

c. Update

d. Create table

 

Question 40

Question text

If we have the following table:

customer (custNo, name, street, city, state, zip, telephone, creditLimit)

What will this update command do?

update customer
set creditLimit = creditLimit * 1.05
where state = ‘MA’

Select one:

a. Insert a new record into the table for each MA customer

b. Set the credit limit of all MA customers to credit limit * 1.05

c. Set the credit limit of all MA customers to credit limit / 1.05

d. Change state to MA where credit limit was increased by 5%

Question 41

Question text

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 42

Question text

What is the delete statement used to do?
Select one:

a. Delete table rows that match a condition

b. Truncate parts of a table that are too long

c. Remove table columns that match a condition

d. Insert a mark to indicate that a table is deleted

Question 43

Question text

Which of the following is true about a select statement?
Select one:

a. It can only be used by itself.

b. It can be included as part of an insert only.

c. It can be included as part of an update but not as part of a delete.

d. It can be included as part of an update, delete, or insert statement.

 

Question 44

Question text

Which of the following is the where clause most useful for?
Select one:

a. Only joining tables

b. Choosing the table

c. Choosing the expression to display

d. Choosing only rows that fit a certain criteria

 

Question 45

Question text

What will the following query return for results?

select lname
from customer
where credit_limit in (1000,2000,3000)

Select one:

a. All last names and credit limits from 1000 to 2000, and 2000 to 3000

b. The last name of all customers with a credit limit of 1000, 2000, or 3000

c. All last names and credit limits where the credit limit is 1000, 2000, 3000

d. The last name of all customers with a credit from 1000 to 2000, and 2000 to 3000

Question 46

Question text

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

Question 47

Question text

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

Question 48

Question text

What does an inner join do?
Select one:

a. Return all rows in all tables

b. Return only those rows with a matching row in the corresponding table

c. Return all rows in the right table regardless of whether there is a match in the left table

d. Return all rows in the left or right table regardless of whether there is a match in the corresponding table

Question 49

Question text

Question 50

Question text

You are given the following tables:

Course
CourseID Description Credits
CS101 Computer Science I 3
CS201 Elementary Data Structures 3
ENGL210 Technical Writing 3

 

Registration
SID CourseID SemID Instructor Grade
282712 ENGL210 201701 H. Zacny B+
362112 CS101 201701 K. Ross C

What would the following SQL Select statement produce for output?

select course.description, registration.SID,registration.grade
from registration
right join course
on registration.courseID = course.courseID

Select one:

a. Computer Science I 362112 C

b. Computer Science I 362112 C

Technical Writing 28212 B+

c. Computer Science I 362112 C

Elementary Data Structures null null
Technical Writing 28212 B+

d. No results due to syntax error

 

UPDATES(Questions Repeat)

Question 1

Correct
Mark 1.00 out of 1.00

Question text

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 2

Correct
Mark 1.00 out of 1.00

Question text

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 4

Correct
Mark 1.00 out of 1.00

Question text

What are databases generally used for today?
Select one:

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 5

Correct
Mark 1.00 out of 1.00

Question text

Which of the following sets of terms describes the data in a database?
Select one:

a.

integrated and shared

b.

redundant and accurate

c.

functional and redundant

d.

transactional and unconstrained

Question 7

Correct
Mark 1.00 out of 1.00

Question text

Which of the following describes a DBMS?
Select one:

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

Correct
Mark 1.00 out of 1.00

Question text

Which kind of database corresponds to ‘graph’?
Select one:

a.

Network

b.

Relational

c.

Hierarchical

d.

Object-oriented

Question 9

Correct
Mark 1.00 out of 1.00

Question text

What kind of database corresponds to ‘table’?
Select one:

a.

Network

b.

Relational

c.

Hierarchical

d.

Object-oriented

Question 10

Correct
Mark 1.00 out of 1.00

Question text

What is data that describes data called?
Select one:

a.

Metadata

b.

Abstract data

c.

Semantic data

d.

Referential data

Question 11

Correct
Mark 1.00 out of 1.00

Question text

Which level of the three-level database architecture deals with how the user sees data?
Select one:

a.

Conceptual

b.

External

c.

Individual

d.

Internal

Question 12

Correct
Mark 1.00 out of 1.00

Question text

Indices are useful for searching a database because they decrease which of the following?
Select one:

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 14

Correct
Mark 1.00 out of 1.00

Question text

What is commonly used to represent a relation?
Select one:

a.

an index

b.

a schema

c.

a table

d.

a view

Question 15

Correct
Mark 1.00 out of 1.00

Question text

IMS is an example of a database system that implemented which of the following models?
Select one:

a.

Hierarchical

b.

Network

c.

Relational

d.

Theoretical

Question 16

Correct
Mark 1.00 out of 1.00

Question text

“Design” corresponds to which of the following database terms?
Select one:

a.

Internal view

b.

External view

c.

Conceptual schema

d.

Data management language

Question 17

Correct
Mark 1.00 out of 1.00

Question text

“User requirements” corresponds to which of the following database terms?
Select one:

a.

Internal view

b.

External view

c.

Network schema

d.

Data management language

Question 18

Correct
Mark 1.00 out of 1.00

Question text

Which of the following statements best describes object-relational databases?
Select one:

a.

They have little vendor support

b.

They integrate multiple paradigms

c.

They cannot be easily implemented

d.

They integrate incompatible paradigms

Question 19

Correct
Mark 1.00 out of 1.00

Question text

Which of the following is an example of a use of an E-R diagram?
Select one:

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

Correct
Mark 1.00 out of 1.00

Question text

In this figure, which of the following is a candidate key?

Select one:

a.

Name

b.

License

c.

SocSec#

d.

StudentId

Question 21

Correct
Mark 1.00 out of 1.00

Question text

Which of the following is true of the ER diagram in the figure below?

Select one:

a.

An employee can work for many departments

b.

An employee can work for one department and a department can only have one employee

c.

An employee can work for one department and a department can have one or more employees

d.

An employee can work for one department only and a department does not have to have employees

Question 22

Correct
Mark 1.00 out of 1.00

Question text

What kind of relationship is this figure an example of?

Select one:

a.

Unary

b.

One to all

c.

One to one

d.

One to many

Question 23

Correct
Mark 1.00 out of 1.00

Question text

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

Feedback

Question 24

Correct
Mark 1.00 out of 1.00

Question text

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

Select one:

a.

Attributes

b.

Constraints

c.

Entities

d.

Relations

Feedback

Question 25

Correct
Mark 1.00 out of 1.00

Question text

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.

Feedback

Question 27

Correct
Mark 1.00 out of 1.00

Question text

Which of the following should we always do when preparing to map an ER diagram to relations?
Select one:

a.

Normalize the ERD until no more normalization can be done

b.

Check that the DBMS can interpret the constraints in the ERD

c.

Make sure that we have simplified the ERD as much as possible

d.

Make sure that our ERD has only one entity and one relationship

Question 29

Correct
Mark 1.00 out of 1.00

Question text

What is a tuple?
Select one:

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

Correct
Mark 1.00 out of 1.00

Question text

What is relational algebra?
Select one:

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

Correct
Mark 1.00 out of 1.00

Question text

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

Correct
Mark 1.00 out of 1.00

Question text

Which of the following is Student ⨯ Courses an example of?
Select one:

a.

A theta join

b.

An inner join

c.

A natural join

d.

A cartesian product

Question 34

Correct
Mark 1.00 out of 1.00

Question text

Which of the following describes a relation is in first normal form (1NF)?
Select one:

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 35

Correct
Mark 1.00 out of 1.00

Question text

In what normal form is the relation in the figure?

Select one:

a.

First normal form

b.

Second normal form

c.

Third normal form

d.

Boyce-Codd normal form

Question 36

Correct
Mark 1.00 out of 1.00

Question text

When is a relation considered to be in second normal form (2NF)? (Select the best answer.)
Select one:

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

Question 37

Correct
Mark 1.00 out of 1.00

Question text

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 J. Smith changes her last name to Klein, we would have to update multiple rows in the table. Which of the following is this an example of?

Select one:

a.

A hash anomaly

b.

A deletion anomaly

c.

An update anomaly

d.

An insertion anomaly

Question 39

Correct
Mark 1.00 out of 1.00

Question text

Which of the following is a data definition command?
Select one:

a.

Insert

b.

Select

c.

Update

d.

Create table

Question 41

Correct
Mark 1.00 out of 1.00

Question text

Which of the following are constraints that can be used with the create table command?
Select one:

a.

references, alias, check

b.

null, primary key, view of

c.

primary key, not null, unique

d.

primary key, default, between

Question 42

Correct
Mark 1.00 out of 1.00

Question text

What would this delete operation do?

delete from course
where credits = 3

Select one:

a.

Add a new row to the course table

b.

Delete all records in the course table

c.

Delete three credit courses from the course table

d.

Delete all records except those with three credits from the course table

Question 43

Correct
Mark 1.00 out of 1.00

Question text

What is the select statement used to do?
Select one:

a.

Query a table

b.

Create a new table

c.

Insert data into a table

d.

Delete rows from a table

Question 44

Correct
Mark 1.00 out of 1.00

Question text

What will the following query return for results?

select lname
from customer
where credit_limit in (1000,2000,3000)

Select one:

a.

All last names and credit limits from 1000 to 2000, and 2000 to 3000

b.

The last name of all customers with a credit limit of 1000, 2000, or 3000

c.

All last names and credit limits where the credit limit is 1000, 2000, 3000

d.

The last name of all customers with a credit from 1000 to 2000, and 2000 to 3000

Question 45

Correct
Mark 1.00 out of 1.00

Question text

Which of the following is a SQL aggregate function?
Select one:

a.

average

b.

avg

c.

mean

d.

sqrt

Question 46

Correct
Mark 1.00 out of 1.00

Question text

What would the following SQL statement produce for output?

select top 2 from customers

Select one:

a.

The first two records of the customer table

b.

The last two records of the customer table

c.

The first two customers based on some condition

d.

The last two customers ordered by some condition

Question 47

Correct
Mark 1.00 out of 1.00

Question text

What does an inner join do?
Select one:

a.

Return all rows in all tables

b.

Return only those rows with a matching row in the corresponding table

c.

Return all rows in the right table regardless of whether there is a match in the left table

d.

Return all rows in the left or right table regardless of whether there is a match in the corresponding table

Question 48

Correct
Mark 1.00 out of 1.00

Question text

Which type of join returns all rows in the left table regardless of whether there are matches in the right table?
Select one:

a.

Hash join

b.

Full outer join

c.

Left outer join

d.

Right outer join

Question 50

Correct
Mark 1.00 out of 1.00

Question text

You are given the following tables:

Course
CourseID Description Credits
CS101 Computer Science I 3
CS201 Elementary Data Structures 3
ENGL210 Technical Writing 3

 

 

Registration
SID CourseID SemID Instructor Grade
282712 ENGL210 201701 H. Zacny B+
362112 CS101 201701 K. Ross C

 

What would the following SQL Select statement produce for output?

select course.description, registration.SID,registration.grade
from registration
right join course
on registration.courseID = course.courseID

Select one:

a.

Computer Science I 362112 C

b.

Computer Science I 362112 C
Technical Writing 28212 B+

c.

Computer Science I 362112 C
Elementary Data Structures null null
Technical Writing 28212 B+

d.

No results due to syntax error

Feedback