Which statement about an index is true?

You want to issue the following command on a database that includes your company’s inventory information: ALTER TABLE products SET UNUSED COLUMN color; What will be the result of issuing this command?

Evaluate the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER(9) LAST_NAME VARCHAR2(25) FIRST_NAME VARCHAR2(25)DEPARTMENT_ID NUMBER(9) MANAGER_ID NUMBER(9)SALARY NUMBER(7,2)Which statement should you use to increase the LAST_NAME column length to 35 if the column currently contains 200 records?

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?

Which type of constraint by default requires that a column be both unique and not null?

You need to add a row to an existing table. Which DML statement should you use?

You cannot modify data in a view if the view contains ______.

You need to create a report that lists all employees in department 10 (Sales) whose salary is not equal to $25,000 per year. Which query should you issue to accomplish this task?

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?

You have been asked to create a report that lists all customers who have placed orders of at least $2,500. The report’s date should be displayed in the Day, Date Month, Year format (For example, Tuesday, 13 April, 2004 ). Which statement should you issue?