C170, WGU Full Study Pack, Questions with accurate answers, 100% Accurate, rated A+
2 views 0 purchase
Course
C170, WGU
Institution
C170, WGU
C170, WGU Full Study Pack, Questions with accurate answers, 100% Accurate, rated 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? - -Many-to-many
Which two examples are attrib...
C170, WGU Full Study Pack , Questions with accurate answers, 100% Accurate, rated A+ A salesperson is authorized to sell many products and a prod uct can be sold by many salespersons. Which kind of binary relationship does this scenario describe? - ✔✔-Many -to-many Which two examples are attributes? - ✔✔-An employee number A meeting code Which delete rule sets column values in a child table to a mi ssing value when the matching data is deleted from the parent table? - ✔✔-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? - ✔✔-member_id expiration This database table has ten different employee numbers in the first column. Employee_ID is the primary 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? - ✔✔-Move the data from the third column into its o wn 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? - ✔✔-Seco nd 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? - ✔✔-Foreign SELECT PRODNUM, PRODNAME FROM PRODUCT Which line sh ould be added to the end of the statement to return the product numbers and product names for products that cost 20 dollars? - ✔✔-WHERE PRODCOST=20; What does WHERE identify in a basic SQL SELECT statement? - ✔✔-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? - ✔✔-
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? - ✔✔-GROUP BY PRODNUM; Which data definition language statement affects databases or objects in them? - ✔✔-ALTER What does the DELETE statement do? - ✔✔-It removes rows from a table. Which condition must be in effect to use the INSERT INTO ... VALUES syntax for an INSERT statement? - ✔✔-The VALUES list must contain a value for each non -null valued column in the table. CREATE TABLE mytb l ( 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? - ✔✔-Decimal Which two SQL data types can represent images or sounds? - ✔✔-TINYBLOB BINARY CREATE TABLE CUSTOMER (Custom erID 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? - ✔✔-CUSTOMER Which method creates an empty copy of a table and then populates it from the original table? - ✔✔-
CREATE TABLE ... LIKE followed by INSERT INTO ... SELECT : ALTER TABLE tbl_name action [, action ] ... ; What does this syntax allow? Choose 2 answers - ✔✔-Dropping indexes Changing column data types Which command eliminates a table? - ✔✔-DROP TABLE Why is a view used to give controlled access to data? - ✔✔-To restrict access to persons retrieving and modifying sensitive information A database manager plans to create a view of a table and has these two elements: - ✔✔-The SELECT privilege for every column referred to elsewhere in the statement SELECT product_name, product_number, mfg_city FROM product; Which statement, when added before this statement, gener ates a view? - ✔✔-CREATE VIEW viewprod AS What is the proper command to change a view? - ✔✔-ALTER VIEW DROP VIEW EMPLOYEE; What happens as a result of the execution of this statement to the HRDB table on which the EMPLOYEE view is based? - ✔✔-The view is discarded. When a product is deleted from the product table, all corresponding rows for the product in the pricing table are deleted automatically as well. What is this referential integrity technique called? - ✔✔-Cascaded delete CREATE TABLE 'test1' (
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 QuickPass. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.49. You're not tied to anything after your purchase.
