Exam (elaborations)
C170, WGU Full Study Pack Latest Update (A+)
- Course
- Institution
C170, WGU Full Study Pack Latest Update (A+)C170, WGU Full Study Pack Latest Update (A+)C170, WGU Full Study Pack Latest Update (A+)
[Show more]
Content preview
1[Date]C170, WGU Full Study Pack Latest Update (A+)A salesperson is authorized to sell many products and a product can be sold by many salespersons.
Which kind of binary relationship does this scenario describe? - correct answers Many-to-many
Which two examples are attributes? - correct answers An employee number
A meeting code
Which delete rule sets column values in a child table to a missing value when the matching data is
deleted from the parent table? - correct answers Set-to-Null
member_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY (member_id),
last_name VARCHAR(20) NOT NULL,
first_name VARCHAR(20) NOT NULL,
suffix VARCHAR(5) NULL,
expiration DATE NULL,
Which two columns are created as something other than variable-length strings in this statement? - correct answers member_id
expiration
This database table has ten different employee numbers in the first column. Employee_ID is the primary 2[Date]key. In addition, it has ten different names in the second column and two office addresses repeated five
times each in the third column.
Which action should be used to translate this data into third normal form? - correct answers Move the data from the third column into its own table.
A database manager starts to convert data that has been normalized into a form
that conforms to the
relational model. A simple primary key has been established and all the repeating groups have been
deleted.
In which form is this data? - correct answers Second normal form
Two attributes in two related tables have the exact same domain of values. The attribute is a primary
key in one table.
Which kind of key is the attribute in the other table? - correct answers Foreign
SELECT PRODNUM, PRODNAME
FROM PRODUCT
Which line should be added to the end of the statement to return the product numbers and product
names for products that cost 20 dollars? - correct answers WHERE PRODCOST=20; 3[Date]What does WHERE identify in a basic SQL SELECT statement? - correct answers The rows to be included
Refer to the given SQL statement.
SELECT EMPNUM
FROM EMPLOYEE
Which line added to the end of the statement returns employee numbers of at least 1000? - correct answers WHERE EMPNUM >= 1000;
SELECT PRODNUM, SUM(QUANTITY)
FROM SALESPERSON
Which line, when added to the end of the statement, returns the total number of each kind of product
by product number? - correct answers GROUP BY PRODNUM;
Which data definition language statement affects databases or objects in them? - correct answers ALTER
What does the DELETE statement do? - correct answers It removes rows from a table.
Which condition must be in effect to use the INSERT INTO ... VALUES syntax for an INSERT statement? - correct answers The VALUES list must contain a value for each non-null valued column in the
table. 4[Date]CREATE TABLE mytbl
(
f FLOAT(10,4),
c CHAR(15) NOT NULL DEFAULT 'none',
i TINYINT UNSIGNED NULL
);
Which kind of data type is FLOAT in this statement? - correct answers Decimal
Which two SQL data types can represent images or sounds? - correct answers TINYBLOB
BINARY
CREATE TABLE CUSTOMER
(CustomerID INT NOT NULL AUTO_INCREMENT,
LastName VARCHAR(100) NOT NULL,
FirstName VARCHAR(100) NOT NULL,
PRIMARY KEY ( CustomerID ));
Which component of the command indicates the table's name? - correct answers CUSTOMER
Which method creates an empty copy of a table and then populates it from the original table? - correct answers CREATE TABLE ... LIKE followed by INSERT INTO ... SELECT :
ALTER TABLE tbl_name action [, action ] ... ;
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller newsolutions. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $17.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
79373 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now