A firm is producing 4 units of output at an average total cost of $10. When the firm produces 5 units of output, average total cost rises to $20. What is the marginal cost of the fifth unit of output?

Which SQL statement below will correctly create the EMP table based on the structure of the EMPLOYEES table? Include only the EMPLOYEE_ID, FIRST_NAME, LAST_NAME, SALARY, and DEPARTMENT_ID columns.

Examine the data from the LINE_ITEM table: LINE_ITEM_ID ORDER_ID PRODUCT_ID PRICE DISCOUNT 890898 847589 848399 8.99 0.10 768385 862459 849869 5.60 0.05 867950 985490 945809 5.60   954039 439203 438925 5.25 0.15 543949 349302 453235 4.50   You query the LINE_ITEM table and a *value of 3 is returned. Which SQL statement did you execute?

The EMPLOYEES table contains these columns: LAST_NAME VARCHAR2(20) FIRST_NAME VARCHAR2(20) HIRE_DATE DATEEVAL_MONTHS NUMBER(3) Evaluate this SELECT statement: SELECT hire_date + eval_months FROM employees; The values returned by this SELECT statement will be of which data type?

You need to ensure that the LAST_NAME column only contains certain character values. No numbers or special characters are allowed. Which type of constraint should you define on the LAST_NAME column?

For which column would you create an index?

The EMPLOYEES and ORDERS tables contain these columns: EMPLOYEES:EMPLOYEE_ID NUMBER(10) NOT NULL PRIMARY KEY FIRST_NAME VARCHAR2(30)LAST_NAME VARCHAR2(30)ADDRESS VARCHAR2(25)CITY VARCHAR2(20)STATE VARCHAR2(2) ZIP NUMBER(9)TELEPHONE NUMBER(10) ORDERS:ORDER_ID NUMBER(10) NOT NULL PRIMARY KEY EMPLOYEE_ID NUMBER(10) NOT NULL FOREIGN KEYORDER_DATE DATETOTAL NUMBER(10) Which SELECT statement will return all orders generated by a sales representative named Franklin during the year 2001?

The CUSTOMERS and SALES tables contain these columns: CUSTOMERS:CUST_ID NUMBER(10) PRIMARY KEY COMPANY VARCHAR2(30) LOCATION VARCHAR2(20) SALES:SALES_ID NUMBER(5) PRIMARY KEY CUST_ID NUMBER(10) FOREIGN KEY TOTAL_SALES NUMBER(30) Which SELECT statement will return the customer ID, the company and the total sales?

Evaluate this view definition: CREATE OR REPLACE VIEW part_name_v AS SELECT DISTINCT part_name FROM partsWHERE cost >= 45; Which of the following statements using the PART_NAME_V view will execute successfully?

Which of the following keywords cannot be used when creating a view?