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?

Evaluate this SELECT statement: SELECT p.player_id, m.last_name, m.first_name, t.team_name FROM player p LEFT OUTER JOIN player m ON (p.manager_id = m.player_id) LEFT OUTER JOIN team t ON (p.team_id = t.team_id); Which join is evaluated first?

Which of the following best describes the function of a CHECK constraint?

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?