What does the following SQL statement add to the Terms table?Insert Into Terms (TermsDueDays)Values (90)a) A row with a value of 90 for the TermsDueDays columnb) 90 rows with a column of TermsDueDaysc) All rows where the TermsDueDays column has a value of 90d) A TermsDueDays column with a default value of 90

Write the SQL code to calculate the ASSIGN_CHARGE values in the ASSIGNMENT table in the Ch07_ConstructCo database. (See Figure P7.1.) Note that ASSIGN_CHARGE is a derived attribute that is calculated by multiplying ASSIGN_CHG_HR by ASSIGN_HOURS.

Delete the index named ITEM_INDEX3.

What is a NULL value?

What is the purpose of a column alias?

A unique identifier for a data row that consists of more than one field is commonly called a: primary plus key composite primary key foreign key none of the above

In PL/SQL, how do you assign variables the same type as a column in the database?

Attempt to view the structure of the HOMEWORK13 view.

What happens if you try to decrease the scale or precision of a NUMBER column to a value less than the data already stored in the field?

Create a new table containing these four columns: Emp#, Lastname, Firstname, and Job_class. The table name should be EMPLOYEES. The Job_class column should be able to store character strings up to a maximum length of four, but the column values shouldn’t be padded if the value has less than four characters. The Emp# column contains a numeric ID and should allow a five-digit number. Use column sizes you consider suitable for the Firstname and Lastname columns.

Create the following indexes: a. Create an index named TRIP_INDEX1 on the TRIP_NAME column in the TRIPtable. b. Create an index named TRIP_INDEX2 on the TYPE column in the TRIP table. c. Create an index named TRIP_INDEX3 on the LAST_NAME and FIRST_NAME columns in the CUSTOMER table.

Perform the following tasks: a. Create an index named ITEM_INDEX1 on the ITEM_NUM column in the ORDER_LINEtable. b. Create an index named ITEM_INDEX2 on the CATEGORY column in the ITEMtable. c. Create an index named ITEM_INDEX3 on the CATEGORY and STOREHOUSE columnsin the ITEM table. d. Create an index named ITEM_INDEX4 on the CATEGORY and STOREHOUSEcolumns in the ITEM table. List categories in descending order.

Which of the following SQL statements is invalid and returns an error message? ALTER TABLE books ADD CONSTRAINT books_pubid_uk UNIQUE (pubid); ALTER TABLE books ADD CONSTRAINT books_pubid_pk PRIMARY KEY (pubid); ALTER TABLE books ADD CONSTRAINT books_pubid_nn NOT NULL (pubid); ALTER TABLE books ADD CONSTRAINT books_pubid_fk FOREIGN KEY (pubid) REFERENCES publisher (pubid); All of the above statements are invalid.