You need to add a NOT NULL constraint to the COST column in the PART table. Which statement should you use to complete this task?

You create a CUSTOMERS table in which CUSTOMER_ID is designated as a primary key. You want the values that are entered into the CUSTOMER_ID column to be generated automatically. Which of the following actions should you perform?

In order to query a database using a view, which of the following statements applies?

Examine the structures of the PRODUCT and SUPPLIER tables.PRODUCTPRODUCT_ID NUMBER NOT NULL, Primary KeyPRODUCT_NAME VARCHAR2 (25)SUPPLIER_ID NUMBER Foreign key to SUPPLIER_ID of the SUPPLIER tableLIST_PRICE NUMBER (7,2)COST NUMBER (7,2)QTY_IN_STOCK NUMBERQTY_ON_ORDER NUMBERREORDER_LEVEL NUMBERREORDER_QTY NUMBERSUPPLIERSUPPLIER_ID NUMBER NOT NULL, Primary KeySUPPLIER_NAME VARCHAR2 (25)ADDRESS VARCHAR2 (30)CITY VARCHAR2 (25)REGION VARCHAR2 (10)POSTAL_CODE VARCHAR2 (11)Evaluate this statement:ALTER TABLE suppliersDISABLE CONSTRAINT supplier_id_pk CASCADE;For which task would you issue this statement?

The LINE_ITEM table contains these columns: LINE_ITEM_ID NUMBER PRIMARY KEYPRODUCT_ID NUMBER(9) FOREIGN KEY references the ID column of the PRODUCT tableQUANTITY NUMBER(9)UNIT_PRICE NUMBER(5,2)You need to disable the FOREIGN KEY constraint. Which statement should you use?

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?