（）his examination of the patient, the

1、Examine the description of the EMPLOY

Examine the description of the EMPLOYEES table:EMP_ID NUMBER(4) NOT NULLLAST_NAME VARCHAR2(30) NOT NULLFIRST_NAME VARCHAR2(30)DEPT_ID NUMBER(2)Which s...

2、Examine the structure of the EMPLOYEE

Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEESColumn name Data type RemarksEMPLOYEE_ID NUMBER NOT NULL, Primary KeyEMP_NA...

3、Examine the description of the CUSTOM

Examine the description of the CUSTOMERS table:CUSTOMER_ID NUMBER(4) NOT NULLCUSTOMER_NAME VARCHAR2(100) NOT NULLSTREET_ADDRESS VARCHAR2(150)CITY_ADDRES...

4、Examine the structure of the STUDENTS

Examine the structure of the STUDENTS table:You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999.Which SQL statement accomplishes this task?（）ABCD

5、Examine the structure of the EMPLOYEE

Examine the structure of the EMPLOYEES table:EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2(25)LAST_NAME VARCHAR2(25)Which three statements insert ...

6、Examine the description of the STUDEN

Examine the description of the STUDENTS table:Which two aggregate functions are valid on the START_DATE column?（）A SUM(start_date)B AVG(start_date)C COUNT(start_date)D AVG(start_date, end_date)E MIN(start_date)F MAXIMUM(start_date)