C175 Alternate Practice Test

Question 1 of 75

1

A record consists of a ____

Select one of the following:

character
collection of related records
set of one or more field
group of files

Explanation

Question 2 of 75

1

A DBMS performs several important functions that guarantee the integrity and consistency of the data in the database. Which of the following is NOT one of those functions?

Select one of the following:

Data integrity management
Data storage management
Data reports
Security management

Explanation

Question 3 of 75

1

Which item is unstructured data

Select one of the following:

A record representing one student
A video
A table that holds student data
A relational database that hold course registration data

Explanation

Question 4 of 75

1

Data is/are

Select one of the following:

information
raw facts
processed information
DBMS

Explanation

Question 5 of 75

1

Which classification is correct for the box marked “Registration” in the given E-R Diagram?

Select one of the following:

Intersection data
Modality data
Cardinality data
Student data

Explanation

Question 6 of 75

1

Which type of relationship exists between Student and Course

Select one of the following:

One-to-many binary
Many-to-many binary
One-to-many unary
Many-to-many unary

Explanation

Question 7 of 75

1

What is the E-R Diagram about an online pet food vendor showing?

Select one of the following:

An Invoice Line can include many Items
An item can only be included in one Invoice Line
One Invoice Line must include a minimum of one and a maximum of one Item.
The relationship between Item and Invoice Line is many-to-many.

Explanation

Question 8 of 75

1

A pet owner can have many pets; a specific pet is linked to one pet owner.

Select one of the following:

One-to-one
One-to-many
Many-to-many
Associative

Explanation

Question 9 of 75

1

Database models were developed to ____

Select one of the following:

model real-world events or conditions
deposit data within a single file
keep data within multiple data repositories
allow DBMSs to maintain loose control over the database activities

Explanation

Question 10 of 75

1

What is the correct way to read the modality on the right side of the association?

Select one of the following:

A maximum of one activity
A maximum of zero activities
A minimum of zero activities
A maximum of many activities

Explanation

Question 11 of 75

1

What is the modality of Volunteer?

Select one of the following:

Two or more
Two
Dependent on registration date
At least one

Explanation

Question 12 of 75

1

What type of relationship is expressed with the phrase “A Painter paints one or more Paintings”?

Select one of the following:

1:M
1:1
M:1
M:N

Explanation

Question 13 of 75

1

The entity integrity rule requires that ____

Select one of the following:

all primary key entries are unique
a part of the key may be null
foreign key values do not reference primary key values
duplicate object values are allowed

Explanation

Question 14 of 75

1

What does the ‘refer’ in referential integrity mean ?

Select one of the following:

The relationships between entities and attributes, also called referrals
Reference points that databases place in each record during backups
A foreign key in a table must refer to a valid primary key in another table.
You delete a row in one table whose primary key does not have a matching foreign key value in another table

Explanation

Question 15 of 75

1

A table is perceived as a ____

Select one of the following:

flat structure
two-dimensional structure
linked structure
graph

Explanation

Question 16 of 75

1

Another word for the term “relation” is _____

Select one of the following:

datafile
data index
table
data query

Explanation

Question 17 of 75

1

DISTINT filters the results to remove duplicates. ORDER BY _____

Select one of the following:

does the same thing.
alters the order of the rows in a table.
modifies the presentation by changing the order of the result set.
removes duplicates in the table.

Explanation

Question 18 of 75

1

A primary key ____.

Select one of the following:

is a minimal superkey
is always the first field in each table
must be numeric
must be unique

Explanation

Question 19 of 75

1

A table can be logically connected to another table by defining a ____

Select one of the following:

hyperlink
common attribute
primary key
logic key

Explanation

Question 20 of 75

1

A relational operator that allows for the combination of information from two or more tables is known as the ____ operator

Select one of the following:

SELECT
PROJECT
JOIN
DIFFERENCE

Explanation

Question 21 of 75

1

Which of the following statements concerning the primary key is true?

Select one of the following:

All primary key entries are unique.
The primary key may be null.
The primary key is not required for all tables.
The primary key data do not have to be unique.

Explanation

Question 22 of 75

1

We can describe a link by observing that ____

Select one of the following:

a primary key of one table appears again as a primary key in a related table
a foreign key of one table appears again as a foreign key in a related table
a primary key of one table appears again as a foreign key in a related table
a foreign key of one table appears again as a primary key in a related table

Explanation

Question 23 of 75

1

When designing a new database, it is a good idea to ____

Select one of the following:

minimize data redundancy
include redundant fields
include a common field in all tables
use composite keys

Explanation

Question 24 of 75

1

An attribute (or combination of attributes) that uniquely identifies each entity in a table is called a ____

Select one of the following:

superkey
foreign key
master key
secondary key

Explanation

Question 25 of 75

1

A foreign key must ____.

Select one of the following:

be numeric
be unique
be defined in all tables within the database
match the value of a primary key in a related table

Explanation

Question 26 of 75

1

The ERD is used to graphically represent the ____ database model.

Select one of the following:

condensed
physical
logical
conceptual

Explanation

Question 27 of 75

1

A derived attribute ____.

Select one of the following:

must be stored physically within the database
need not be physically stored within the database
has many values
must be based on the value of three or more attributes

Explanation

Question 28 of 75

1

A relationship is an association between ____

Select one of the following:

objects
entities
databases
fields

Explanation

Question 29 of 75

1

A ____ key is a key that consists of more than one attribute.

Select one of the following:

primary
foreign
composite
domain

Explanation

Question 30 of 75

1

A ____ attribute is one that cannot be subdivided.

Select one of the following:

composite
atomic
single-valued
multivalued

Explanation

Question 31 of 75

1

If an entity can exist apart from one or more related entities, it is said to be ____-independent

Select one of the following:

existence
relationship
business
weak

Explanation

Question 32 of 75

1

A ____ relationship exists when three entities are associated

Select one of the following:

unary
binary
ternary
weak

Explanation

Question 33 of 75

1

The set of possible values for an attribute is a ____

Select one of the following:

domain
range
set
key

Explanation

Question 34 of 75

1

Which attribute(s) make up the primary key in the table definition:

CLASS (CRS_CODE, CLASS_SECTION, CLASS_TIME, CLASS_ROOM, PROF_NUM)

Select one of the following:

CRS_CODE
CLASS_SECTION
CRS_CODE and CLASS_SECTION
There is no primary key

Explanation

Question 35 of 75

1

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 of the following:

1NF
2NF
3NF
4NF

Explanation

Question 36 of 75

1

A table that is in 2NF and contains no transitive dependencies is said to be in ____

Select one of the following:

1NF
2NF
3NF
4NF

Explanation

Question 37 of 75

1

Data redundancy produces ____

Select one of the following:

slower lookups
robust design
efficient storage use
data integrity problems

Explanation

Question 38 of 75

1

Normalization works through a series of normal ____

Select one of the following:

schemas
entities
databases
forms

Explanation

Question 39 of 75

1

Dependencies based on only a part of a composite primary key are called ____ dependencies

Select one of the following:

primary
partial
incomplete
composite

Explanation

Question 40 of 75

1

Given the table EMP_PROJ (PROJ_NUM, EMP_NUM, PROJ_NAME, EMP_NAME, JOB_CLASS, CHG_HOURS, HOURS), which of the following is a partial dependency?

Select one of the following:

PROJ_NUM --> PROJ_NAME
JOB_CLASS --> CHG_HOUR
PROJ_NUM, EMP_NUM --> HOURS
PROJ_NUM, EMP_NUM --> CHG_HOURS

Explanation

Question 41 of 75

1

A relation is not in 1NF if

Select one of the following:

it has multiple candidate keys
all of the key attributes are defined
there are repeating groups in the table
all attributes are dependent on the primary key

Explanation

Question 42 of 75

1

The SQL command that lets you insert data into a table, one row at a time, is ____

Select one of the following:

INSERT
SELECT
COMMIT
UPDATE

Explanation

Question 43 of 75

1

The SQL command that enables you to make changes in the data is ____

Select one of the following:

INSERT
SELECT
COMMIT
UPDATE

Explanation

Question 44 of 75

1

To list all the contents of the PRODUCT table, you would use ____.

Select one of the following:

LIST * FROM PRODUCT;
SELECT * FROM PRODUCT;
DISPLAY * FROM PRODUCT;
SELECT ALL FROM PRODUCT;

Explanation

Question 45 of 75

1

Which command would you use when making corrections to the PRODUCT table?

Select one of the following:

CHANGE PRODUCT
SET P_INDATE = '01/18/2004'
WHERE P_CODE = '13-Q2/P2';
ROLLBACK PRODUCT
SET P_INDATE = '01/18/2004'
WHERE P_CODE = '13-Q2/P2';
EDIT PRODUCT
SET P_INDATE = '01/18/2004'
WHERE P_CODE = '13-Q2/P2';
UPDATE PRODUCT
SET P_INDATE = '01/18/2004'
WHERE P_CODE = '13-Q2/P2';

Explanation

Question 46 of 75

1

Which command would be used to delete the table row where the P_Code = '2238/QPD'?

Select one of the following:

DELETE FROM PRODUCT
WHERE P_CODE = '2238/QPD';
REMOVE FROM PRODUCT
WHERE P_CODE = '2238/QPD'
ERASE FROM PRODUCT
WHERE P_CODE = '2238/QPD';
ROLLBACK FROM PRODUCT
WHERE P_CODE = '2238/QPD';

Explanation

Question 47 of 75

1

Which command is used to select partial table contents?

Select one of the following:

SELECT <column(s)>
FROM <Table name>
WHERE <Item>;
LIST <column(s)>
FROM <Table name>
WHERE <Conditions>;
SELECT <column(s)>
FROM <Table name>
WHERE <Conditions>;
LIST<column(s)>
FROM <Table name>
WHERE <Item>;

Explanation

Question 48 of 75

1

Which query will output the table contents when the value of V_CODE is less than or equal to 21344?

Select one of the following:

SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE <> 21344;
SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE <=21344;
SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE => 21344;
SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE = 21344;

Explanation

Question 49 of 75

1

Which query will list all the rows in which the inventory stock dates occur on or after January 20, 2006?

Select one of the following:

SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE
FROM PRODUCT
WHERE P_INDICATE >= '01/20/2006'
SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE
FROM PRODUCT
WHERE P_INDICATE >= #01/20/2004#
SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE
FROM PRODUCT
WHERE P_INDICATE >= '20-JAN-2004'
SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE
FROM PRODUCT
WHERE P_INDICATE >= {01-20-2004}

Explanation

Question 50 of 75

1

What is the SQL syntax requirement to list the table contents for either V_CODE = 21344 or V_CODE = 24288?

Select one of the following:

SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE = 21344
OR V_CODE <= 24288
SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE = 21344
OR V_CODE => 24288
SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE = 21344
OR V_CODE > 24288
SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE = 21344
OR V_CODE = 24288

Explanation

Question 51 of 75

1

What is the command to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME, V_AREACODE, V_PHONE, and V_CONTACT fields from the VENDOR table where the value of V_CODE match?

Select one of the following:

SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
FROM PRODUCT, VENDOR
WHERE PRODUCT.V_CODE <> VENDOR.V_CODE;
SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
FROM PRODUCT, VENDOR
WHERE PRODUCT.V_CODE = VENDOR.V_CODE
SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
FROM PRODUCT, VENDOR
WHERE PRODUCT.V_CODE <= VENDOR.V_CODE;
SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
FROM PRODUCT, VENDOR
WHERE PRODUCT.V_CODE => VENDOR.V_CODE;

Explanation

Question 52 of 75

1

SQL allows the use of special operators in conjunction with the WHERE clause. A special operator used to check for similar character strings is ____.

Select one of the following:

BETWEEN
IS NULL
LIKE
IN

Explanation

Question 53 of 75

1

A table can be deleted from the database by using the ____ command.

Select one of the following:

DROP
DELETE
MODIFY
ERASE

Explanation

Question 54 of 75

1

UPDATE tablename
*
[WHERE conditionlist];
What command replaces the * in the above statement?

Select one of the following:

SET columnname = expression
columnname = expression
expression = columnname
LET columnname = expression

Explanation

Question 55 of 75

1

A ____ join returns rows with matching values and includes all rows from both tables (T1 and T2) with unmatched values.

Select one of the following:

natural
cross
full outer
left outer

Explanation

Question 56 of 75

1

During which step in the extract, transform, load (ETL) process are raw data sets aggregated?

Select one of the following:

Transformation
Extraction
Loading
Denormalization

Explanation

Question 57 of 75

1

Which is an important issue associated with the loading component of extract, transform, load (ETL)?

Select one of the following:

Mapping keys from one system to another
Monitor refreshing volume and frequency
Determining the content of the data
Denormalizing and renormalizing data

Explanation

Question 58 of 75

1

A database includes the table shown above in the exhibit. Each teacher is associated with exactly one campus. The address in the table is the address for the campus where the teacher teaches.

What change would you need to make to normalize the database to the third normal form (3NF)?

Select one of the following:

Combine the FirstName and LastName columns into a single column.
Combine the Campus, Address, City, State, Country, and PostalCode columns into a single column.
Create a separate table for campus address information. Use the Campus as the primary key. Add a TeacherID column to the table and relate it to the Teacher ID column in the Teachers table.
Create a separate table for campus address information. Use Campus as the primary key for the table. Create a foreign key in the Teachers table that relates teacher to the campus.

Explanation

Question 59 of 75

1

Which statement will remove all rows from the Materials table that have a Status value of ‘Obsolete’ but do not have a value for the VendorID column?

Select one of the following:

DELETE Materials
WHERE Status = ‘Obsolete’ OR VendorID IS NULL
DELETE
FROM Materials
WHERE Status = ‘Obsolete’ AND VendorID IS NULL
DELETE MaterialID, Description, Status, VendorID
FROM Materials
WHERE Status = ‘Obsolete’ AND VendorID IS NULL
DELETE FROM Materials
WHERE Status = ‘Obsolete’
WHERE VendorID IS NULL

Explanation

Question 60 of 75

1

The TestScores table is shown in the exhibit and has these characteristics:
Each student has a unique StudentID that references the Students table.
A specific test can be taken more than once.
Each instructor has a unique InstructorID that references the Instructors table
Each student may take multiple tests on the same date.
Each student may take tests on multiple dates.

What column or columns should you use for the primary key?

Select one of the following:

StudentID, Date
StudentID, Test, Date, InstructorID
StudentID, Test, and Date
Test

Explanation

Question 61 of 75

1

You are creating a relational database to store information about instructors and the courses that each instructor teaches. Each course is taught by a single instructor.

You have created an Instructor table and a Course table as shown above. You need to create a relationship between the Instructor table and the Course table. You need to keep duplicate data to a minimum. What should you do?

Select one of the following:

Create a new column in the Instructor table.
Create new columns in the Instructors table for each course taught
Create a new table that includes two columns.
Create a new column in the Course table

Explanation

Question 62 of 75

1

Which of the following is structured data?

Select one of the following:

Images
Email Attachments
Records in a database
Audio/Video

Explanation

Question 63 of 75

1

Which kind of relationship does the diagram depict?

Select one of the following:

Unary one-to-many
Binary many-to-many
Unary many-to-many
Binary one-to-many

Explanation

Question 64 of 75

1

Which kind of relationship does the diagram depict?

Select one of the following:

Unary one-to-many
Binary many-to-many
Unary one-to-one
Binary one-to-many

Explanation

Question 65 of 75

1

What is the modality of appointment?

Select one of the following:

At least one
Dependent on the quantity
Two
Two or more

Explanation

Question 66 of 75

1

What form is this table in?

Select one of the following:

Unnormalized
First normal form
Second normal form
Third normal form

Explanation

Question 67 of 75

1

What form is this table in?

Select one of the following:

Unnormalized
First normal form
Second normal form
Third normal form

Explanation

Question 68 of 75

1

What form is this table in?

Select one of the following:

Unnormalized
First normal form
Second normal form
Third normal form

Explanation

Question 69 of 75

1

What form is this table in?

Select one of the following:

Unnormalized
First normal form
Second normal form
Third normal form

Explanation

Question 70 of 75

1

Affinity grouping question – Where does affinity grouping occur in data mining?

Select one of the following:

Between objects
Among clusters
Among entities and target applications
Between entity group names

Explanation

Question 71 of 75

1

How is prediction distinguished from estimation in data mining?

Select one of the following:

Estimation assumptions do not need to be tested.
Prediction is used to look at historical data only.
Estimation divides small collections of entities into smaller groups of similar entities.
Prediction classifies objects according to an expected future behavior.

Explanation

Question 72 of 75

1

During which step in the extract, transform, load (ETL) process are raw data sets aggregated?

Select one of the following:

Conversion
Loading
Extraction
Transformation
Denormalization

Explanation

Question 73 of 75

1

Which issues is focused on the loading component of extract, transform, load (ETL)?

Select one of the following:

Monitor refreshing volume and frequency
Mapping keys from one system to another
Determining the content of the data
Denormalizaing and renormalizing the data

Explanation

Question 74 of 75

1

How can a data warehouse assist in an organization’s data analysis?

Select one of the following:

By serving as the primary source of information that feeds analytical processing
By storing data that is no longer in use but may be needed for future analyses
By providing a place where unnormalized data can reside before it is processed
By providing a physical space where groups of servers can process data on a large scale

Explanation

Question 75 of 75

1

Which set of results should a company expect from implementing a business intelligence system?

Select one of the following:

Reduced hardware redundancy and decreased workloads
Riskier capital and asset investments and increased throughput
Increased profitability and reduced hardware redundancy
Increased profitability and increased throughput.

	Created by Craig Willey over 7 years ago

Database Foundations

C175 Alternate Practice Test

C175 Alternate Practice Test

Question 1 of 75

A record consists of a ____

Select one of the following:

Explanation

Question 2 of 75

A DBMS performs several important functions that guarantee the integrity and consistency of the data in the database. Which of the following is NOT one of those functions?

Select one of the following:

Explanation

Question 3 of 75

Which item is unstructured data

Select one of the following:

Explanation

Question 4 of 75

Data is/are

Select one of the following:

Explanation

Question 5 of 75

Which classification is correct for the box marked “Registration” in the given E-R Diagram?

Select one of the following:

Explanation

Question 6 of 75

Which type of relationship exists between Student and Course

Select one of the following:

Explanation

Question 7 of 75

What is the E-R Diagram about an online pet food vendor showing?

Select one of the following:

Explanation

Question 8 of 75

A pet owner can have many pets; a specific pet is linked to one pet owner.

Select one of the following:

Explanation

Question 9 of 75

Database models were developed to ____

Select one of the following:

Explanation

Question 10 of 75

What is the correct way to read the modality on the right side of the association?

Select one of the following:

Explanation

Question 11 of 75

What is the modality of Volunteer?

Select one of the following:

Explanation

Question 12 of 75

What type of relationship is expressed with the phrase “A Painter paints one or more Paintings”?

Select one of the following:

Explanation

Question 13 of 75

The entity integrity rule requires that ____

Select one of the following:

Explanation

Question 14 of 75

What does the ‘refer’ in referential integrity mean ?

Select one of the following:

Explanation

Question 15 of 75

A table is perceived as a ____

Select one of the following:

Explanation

Question 16 of 75

Another word for the term “relation” is _____

Select one of the following:

Explanation

Question 17 of 75

DISTINT filters the results to remove duplicates. ORDER BY _____

Select one of the following:

Explanation

Question 18 of 75

A primary key ____.

Select one of the following:

Explanation

Question 19 of 75

A table can be logically connected to another table by defining a ____

Select one of the following:

Explanation

Question 20 of 75

Which attribute(s) make up the primary key in the table definition:

CLASS (CRS_CODE, CLASS_SECTION, CLASS_TIME, CLASS_ROOM, PROF_NUM)