asssssiiiiiiiiiiiggnnnnnmeeeeeent

IF a SQL subquery included the statement that reads SELECT P_CODE AS PART_CODE, P_DESCRIPT AS PART_DESCRIPT, P_PRICE AS PART_PRICE, VENDOR_CODE, then the new columns would have been created for specific information from a more overall table that was most likely called ____.

Group of answer choicesVENDORPARTPRODUCTPURCHASES

Flag question: Question 2

Question 21 pts

The database administrator must add a constraint to the PART table so a PART’s price is never entered as a negative number. The administrator can enter the SQL statement ____ to satisfy the constraint command.

Group of answer choicesALTER TABLE PART ADD CHECK (PART_PRICE > 0);ALTER TABLE PART ADD CHECK (PART_PRICE =< 0);ALTER TABLE PART ADD CHECK (PART_PRICE /= 0);ALTER TABLE PART ADD CHECK (PART_PRICE >= 0);

Flag question: Question

3

Question 31 pts

An administrator must connect the V_CODE (vendor code) column between tables PART and VENDOR, where the VENDOR has a one-to-many relationship with PART. The part table should be updated by running the SQL statement ____.

Group of answer choicesALTER TABLE PART ADD FOREIGN KEY (V_CODE) REFERENCES VENDOR (V_CODE);ALTER TABLE PART ADD FOREIGN KEY (V_CODE) REFERENCES VENDOR;ALTER TABLE PART ADD FOREIGN KEY (V_CODE) FROM VENDOR (V_CODE);ALTER TABLE PART ADD FOREIGN KEY REFERENCES VENDOR (V_CODE);

Flag question: Question 4

Question 41 pts

A database administrator must add a P_DESCRIPTION column to the PRODUCT table to provide more information to products other than its

name

. The administrator should run the SQL statement ____ to complete this requirement.

Group of answer choicesALTER TABLE PRODUCT ADD (P_DESCRIPTION CHAR(15));ALTER PRODUCT ADD (P_DESCRIPTION CHAR(200));ALTER TABLE PRODUCT ADD (P_DESCRIPTION CHAR(255));ALTER PRODUCT ADD (P_DESCRIPTION CHAR(255));

Flag question: Question 5

Question 51 pts

The PRODUCT table has product entries in the P_CODE column with ‘1355’ (for a jigsaw) and ‘1356 (for a hammer). The hammer must be given a specific name as called by the vendor and can be updated by running the SQL statement ____.

Group of answer choicesUPDATE PRODUCT SET P_NAME = ‘Silver-tip Hammer’ WHERE P_CODE = ‘1356’;UPDATE PRODUCT SET P_CODE = ‘1356’ WHERE P_NAME = ‘Silver-tip Hammer’;UPDATE PRODUCT SET P_NAME = ‘Silver-tip Hammer’ WHERE P_CODE = ‘1355’;UPDATE PRODUCT SET P_NAME = ‘Silver-tip Hammer’ WHERE VEND_ID = ‘1356’;

Flag question: Question 6

Question 61 pts

If an administrator needs to create a new table with different column names PROD_CODE, PROD_DESCRIPT, except for V_CODE, the SQL line ____ should be added to the overall query.

Group of answer choicesSELECT P_CODE AS PROD_CODE, P_DESCRIPT AS PROD_DESCRIPT, P_PRICEAS PROD_PRICE, V_CODESELECT P_CODE AS PROD_CODE, P_DESCRIPT AS PROD_DESCRIPT, V_CODESELECT P_CODE AS PROD_CODE, P_DESCRIPT AS PROD_DESCRIPT, V_CODE AS VENDOR_CODESELECT PROD_CODE AS P_CODE, PROD_DESCRIPT AS P_DESCRIPT, VENDOR_CODE AS V_CODE

Flag question: Question

7

Question 71 pts

If an administrator requires a view of PRODUCTs that are below $50, the ____ statement must be used to specify that range.

Group of answer choicesWHEREFROMSELECTBETWEEN

Flag question: Question

8

Question 81 pts

If new data was added to a database after a revect VIEW called PRICEOVER100 was queried, a database administrator can ____ to view the latest data in PRICEOVER100 view.

Group of answer choicesrun the same CREATE VIEW query statement againcreate a new VIEW query statement with new VIEW nameSELECT from the current VIEWrun SELECT query in another VIEW query

Flag question: Question

9

Question 91 pts

Working with a PART table that has columns PART_CODE, PART_DESCRIPT, PART_PRICE, and VENDOR_CODE, how would a user drop the vendor information from the table?

Group of answer choicesALTER TABLE PART DROP COLUMN VENDOR_CODE;MODIFY TABLE PART DELETE COLUMN VENDOR_CODE;MODIFY TABLE PART DELETE VENDOR_CODE;CHANGE TABLE PART DROP COLUMN VENDOR_CODE;

Flag question: Question 10

Question 101 pts

When using a cross join between a table with 8 rows and another with 5 rows how many rows are in the result?

Group of answer choices10132040

Flag question: Question

11

Question 111 pts

Which of the following is equivalent to WHERE NOT(attribute1 > 100 AND attribute2 = 100)?

Group of answer choicesWHERE attribute1 <= 100 AND attribute2 <> 100WHERE attribute1 <= 100 OR attribute2 <> 100WHERE attribute1 > 100 OR attribute2 = 100WHERE attribute1 < 100 OR attribute2 <> 100

Flag question: Question 12

Question 121 pts

Consider the following tables:

table1

name

7

8

9

11

	vcode
	Alex
	Tony
	Charles
	Mary

table2

vcode

7

9

7

3

	scode	total
341	102
213	59
312	89
712	301

How many rows has the result of the following query?

SELECT * FROM table1 NATURAL JOIN table2

Group of answer choices0123

Flag question: Question 13

Question 131 pts

Some rows of a

User

table are shown below:

User

name

scode

7Alex

8Tony

9Charles

11Mary

BD

ucode	phone
847 – 3902	UX
203 – 3902	PX
	BD
877 – 3333

Which of the following queries retrieves the rows where there is no phone?

Group of answer choicesSELECT * FROM User WHERE phone = “ ”SELECT * FROM User WHERE phone NOT IS NULLSELECT * FROM User WHERE phone IS NULLSELECT * FROM User WHERE phone > 0