You need to grant user BOB SELECT privileges on the EMPLOYEES table. You want to allow BOB to grant this privileges to other users. Which statement should you use?

The FACULTY table contains these columns:FACULTYID VARCHAR2(5) NOT NULL PRIMARY KEYFIRST_NAME VARCHAR2(20)LAST_NAME VARCHAR2(20)ADDRESS VARCHAR2(35)CITY VARCHAR2(15)STATE VARCHAR2(2)ZIP NUMBER(9)TELEPHONE NUMBER(10)STATUS VARCHAR2(2) NOT NULLThe COURSE table contains these columns:COURSEID VARCHAR2(5) NOT NULL PRIMARY KEYSUBJECT VARCHAR2(5)TERM VARCHAR2(6FACULTYID VARCHAR2(5) NOT NULL FOREIGN KEYYou have been asked to compile a report that identifies all adjunct professors who will be teaching classes in the upcoming term. You want to create a view that will simplify the creation of this report. Which CREATE VIEW statements will accomplish this task?

Evaluate this CREATE SEQUENCE statement:CREATE SEQUENCE order_id_seq NOCYCLE NOCACHE;Which statement is true?

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?