WGU C175 Practice Exam 2 questions and answers (scored 30 out of 30)
c
A record consists of a ____.
a. character
b. collection of related records
c. set of one or more fields
d. group of files
c
A DBMS preforms... [Show More] 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?
a. Data integrity management
b.Data storage management
c. Data reports
d. Security management
b
Which item is unstructured data?
a. A record representing one student
B. A video
C. A table that holds student data
D. A relational database that hold course registration data.
b
Data is/are:
a. information
b. raw facts
c. processed information
d. a DBMS
a
Which classification is correct for the box marked "Registration" in the given E-R Diagram?
a. Intersection data
b. Modality data
c. Cardinality data
d. Student data
a
Database models were developed to ____.
a. model-real world events or conditions
b. deposit data within a single file
c. keep data within multiple data repositories
d. allow DBMSs to maintain loose control over the database activities
a
What type of relationship is expressed with the phrase "A painter paints one or more paintings?"
a. 1:M
b. 1:1
c. M:1
d. M:N
a
The entity integrity rule requires that ____.
a. all primary key entries are unique
b. a part of the key may be null
c. foreign key values do not reference primary key values
d. duplicate object values are allowed
c
What does the "refer" in referential integrity mean?
a. The relationships between entities and attributes, also called referrals
b. Reference points that databases place in each record during backups
c. A foreign key in a table must refer to a valid primary key in another table.
d. you delete a row in one table whose primary key does not have a matching foreign key
value in another table
b
A table is perceived as a ____.
a. flat structure
b two-dimensional structure
c. linked structure
d. graph
c
Another word for the term "relation" is ___
a. datafile
b. dataindex
c. table
d. data query
c
DISTINT filters the results to remove duplicates. ORDER BY ____.
a. does the same thing
b. alters the order of the rows in a table
c. modifies the presentation by changing the order of the result set
d. removes duplicates in the table.
d
A primary key___
a. is a minimal superkey
b. is always the first field in each table
c. must be numeric
d. must be unique
b
A table can be logically connected to another table by defining a _____.
a. hyperlink
b. common attribute
c. primary key
d. logic key
c
A relational operator that allows for the combination of information from two or more tables is known as the ____ operator.
a. SELECT
b. PROJECT
c. JOIN
d. DIFFERENCE
a
a. All primary key entries are unique.
Which of the following statements concerning the primary key is true?
a. All primary key entries are unique
b. The primary key may be null.
c. The primary key is not required for all tables.
d. The primary key data do not have to be unique.
c
We can describe a link by observing that___
a. a primary key of one table appears again as a primary key in a related table
b. a foreign key of one table appears again as a foreign key in a related table
c. 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
a
When designing a new database, it is a good idea to ____
a. minimize data redundancy
b. include redundant fields
c. include a common field in all tables
d. use composite keys
a
An attribute (or combo of attributes) that uniquely identifies each entry in a table is a called a _____.
a. superkey
b. candidate key
c. primary key
d. secondary key
d
A foreign key must ____.
a. be numeric
b. be unique
c. be defined in all tables within the database
d. match the value of a primary key in a related table
d
The ERD is used to graphically represent the ____ database model.
a. condensed
b. physical
c. logical
d. conceptual
b
A derived attribute ____.
a. must be stored physically within the database
b. need not be physically stored within the database
c. has many values
d. must be based on the value of three or more attributes
b
A relationship is an association between ____.
a. objects
b. entities
c. databases
d. fields
c
A ____ key is a key that consists of more than one attribute.
a. primary
b. foreign
c. composite
d. domain
b
A ____ attribute is one that cannot be subdivided.
a. composite
b. atomic
c. single valued
d. multivalued
a
If an entity can exist apart from one or more related entities, it is said to be ____-independent.
a. existence
b. relationship
c. business
d. weak
c
A _____ relationship exists when three entities are associated.
a. unary
b. bianry
c. turnary
d. weak
a
The set of possible values for an attribute is a____
a. domain
b. range
c. set
d. key
c
Which attribute(s) make up the primary key in the table definition: CLASS (CRS_CODE, CLASS_SECTION, CLASS_TIME, CLASS_ROOM, PROF_NUM)
a. CRS_CODE
B. CLASS_SECTION
C. CRS_CODE and CLASS_SECTION
D. there is no primary key
a
A table that has all key attributes defined, has no repeating groups, and all attributes are dependent on the primary key is said to be in _____
a. 1NF
b. 2NF
c. 3NF
d. 4NF
c
A table tha is in 2NF and contains no transitive dependencies is said to be in _____
d
Data redundancy produces____.
a. slower look ups
b. robust design
c. efficient storage use
d. data integrity problems
d
Normalization works through a series of normal _____.
a. schema
b entities
c. database
d. forms
b
Dependencies based on only a part of a composite primary key are called ____ dependencies
a. primary
b. partial
c. incomplete
d. composite
a
Give 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?
A. PROJ_NUM --> PROJ_NAME
B. JOB_CLASS-->CHG_HOUR
C. PROJ_NUM, EMP_NUM--->HOURS
D. PROJ_NUM, EMP_NUM-->CHG_HOURS
c
A relation is not in 1NF if:
a. it has multiple candidate keys
b. all of the key attributes are defined
c. there are not repeating groups in the table
d. all attributes are dependent on the primary key
a
The SQL command that lets you insert data into a table, one row at a time, is ____.
a. insert
b. select
c. commit
d. update
d
The SQL command that enables you to make changes in the data is ____.
a insert
b select
c. commit
d. update
b
To list all the contents of the PRODUCT table, you would use ____.
a. LIST * FROM PRODUCT;
b.SELECT * FROM PRODUCT;
c.DISPLAY * FROM PRODUCT;
d. SELECT ALL FROM PRODUCT;
d
Which command would you use when making corrections to the PRODUCT table?
A. CHANGE PRODUCTSET P_INDATE = '01/18/2004'
WHERE P_CODE = '13-Q2/P2';
B. ROLLBACK PRODUCT
SET P_INDATE = '01/18/2004'
WHERE P_CODE = '13-Q2/P2';
C. EDIT PRODUCTSET P_INDATE = '01/18/2004'
WHERE P_CODE = '13-Q2/P2';
d. UPDATE PRODUCT
SET P_INDATE = '01/18/2004'
WHERE P_CODE = '13-Q2/P2';
a
Which command would be used to delete the table row where the P_Code = '2238/QPD'?
A. DELETE FROM PRODUCT
WHERE P_CODE = '2238/QPD';
B. REMOVE FROM PRODUCT
WHERE P_CODE = '2238/QPD';
C. ERASE FROM PRODUCT
WHERE P_CODE = '2238/QPD';
D. ROLLBACK FROM PRODUCT
WHERE P_CODE = '2238/QPD';
c
Which command is used to select partial table contents?
a. select
FROM
WHERE ;
b. LIST
FROM
WHERE ;
c.SELECT
FROM
WHERE ;
d. LIST
FROM
WHERE ;
b
Which query will output the table contents when the value of V_CODE is less than or equal to 21344?
A. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE V_CODE <> 21344;
b. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT WHERE V_CODE <=21344;
c. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT;
WHERE V_CODE => 21344
c.SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCTWHERE V_CODE = 21344;
a
Which query will list all the rows in which the inventory stock dates occur on or after January 20, 2006?
a. SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT
WHERE P_INDICATE >= '01/20/2006'
b. SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE
FROM PRODUCTWHERE P_INDICATE >= #01/20/2004#
c. SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT
WHERE P_INDICATE >= '20-JAN-2004'
d. SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT
WHERE P_INDICATE >= {01-20-2004}
d
What is the SQL syntax requirement to list the table contents for either V_CODE = 21344 or V_CODE = 24288?
a. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE V_CODE = 21344 OR V_CODE <= 24288
b. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE V_CODE = 21344 OR V_CODE => 24288
c. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE V_CODE = 21344 OR V_CODE > 24288
d. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE V_CODE = 21344 OR V_CODE = 24288
b
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?
a. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
FROM PRODUCT, VENDORWHERE PRODUCT.V_CODE <> VENDOR.V_CODE;
b. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
FROM PRODUCT, VENDORWHERE PRODUCT.V_CODE = VENDOR.V_CODE;
c. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
FROM PRODUCT, VENDORWHERE PRODUCT.V_CODE <= VENDOR.V_CODE;
d. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
FROM PRODUCT, VENDORWHERE PRODUCT.V_CODE => VENDOR.V_CODE;
c
SQL allows the use of special operators in conjunction with the WHERE clause. A special operator used to check for similar character strings is ____.
a. between
c. is null
c. like
d. in
a
A table can be deleted from the database by using the ____ command.
a. drop
b. delete
c. modify
d. erase
a
Update tablename *****[WHERE conditionlist];What command replaces the **** in the above statement?
a. SET columnname = expression
b. columnname = expression
c. expression = columnname
d. LET columnname = expression
c
A _____ join returns rows with matching values and includes all rows from both tables (T1 and T2) with unmatched values.
a. natural
b. cross
c. full outer
d. left outer
a
During which step in the extract, transform, load (ETL) process are raw data sets aggregated?
a. Transformation
b. Extraction
c. Loading
d. Denormalization
b
Which is an important issue associated with the loading component of ETL?
a. Mapping keys from one system to another
b. Monitor refreshing volume and frequency
c. Determining the content of the data
d. Denormalizing and renormalizing data
d
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)?
a) Combine the FirstName and LastName columns into a single column.
b) Combine the Campus, Address, City, State, Country, and PostalCode columns
into a single column.
c) 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.
d) 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.
b
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?
a) DELETEMaterialsWHERE Status = 'Obsolete' OR VendorID IS NULL
a) DELETEFROM MaterialsWHERE Status = 'Obsolete' AND VendorID IS NULL
b) DELETE MaterialID, Description, Status, VendorID
FROM MaterialsWHERE Status = 'Obsolete' AND VendorID IS NULL
c) DELETEFROMMaterials WHERE Status = 'Obsolete' WHERE VendorID IS NULL
c
The TestScores table is shown in the exhibit and has these characteristics:
Each student has a unique StudentID that references the Students table.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?
a) StudentID,Date
b) StudentID, Test, Date, InstructorID
c) StudentID, Test, and Date
d) Test
d
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?
a) Create a new column in the Instructor table.
b) Create new columns in the Instructors table for each course taught.
c) Create a new table that includes two columns.
d) Create a new column in the Course tabl
c
Which of the following is structured data?
a) Images
b) Email Attachments
c) Records in a database
d) Audio/Video [Show Less]
Preview 2 out of 10 pages
Generating Your Document
Purchase the document to get the full access instantly