| Question ID 1708 | Examine the structure of the EMPLOYEES table:
EMPLOYEE_ID NUMBER NOT NULL, Primary Key
EMP_NAME VARCHAR2(30)
JOB_ID NUMBER
SAL NUMBER
MGR_ID NUMBER References EMPLOYEE_ID column
DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column
of the DEPARTMENTS table
You created a sequence called EMP_ID_SEQ in order to populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table.
Which two statements regarding the EMP_ID_SEQ sequence are true? (Choose two.)
|
| Option A | A. The EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column.
|
| Option B | B. The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEE_ID
column.
|
| Option C | C. The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table.
|
| Option D | D. You cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column.
|
| Option E | E. The EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table.
|
| Option F | F. Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.
|
| Correct Answer | E,F |
| Question ID 1709 | Examine the description of the CUSTOMERS table:
CUSTOMER_ID NUMBER(4) NOT NULL
CUSTOMER_NAME VARCHAR2(100) NOT NULL
STREET_ADDRESS VARCHAR2(150) CITY_ADDRESS VARCHAR2(50) STATE_ADDRESS VARCHAR2(50) PROVINCE_ADDRESS VARCHAR2(50) COUNTRY_ADDRESS VARCHAR2(50) POSTAL_CODE VARCHAR2(12) CUSTOMER_PHONE VARCHAR2(20)
The CUSTOMER_ID column is the primary key for the table.
Which statement returns the city address and the number of customers in the cities Los Angeles or San Francisco?
|
| Option A | A. SELECT city_address, COUNT(customer_id)
FROM customers
WHERE city_address IN ('Los Angeles', 'San Francisco') GROUP BY city_address, customer_id;
|
| Option B | B. SELECT city_address, COUNT(customer_id)
FROM customers
GROUP BY city_address IN ('Los Angeles', 'San Francisco');
|
| Option C | C. SELECT city_address, COUNT(*)
FROM customers
WHERE city_address IN ('Los Angeles', 'San Francisco') GROUP BY city_address;
|
| Option D | D. SELECT city_address, COUNT(*)
FROM customers
WHERE city_address IN ('Los Angeles', 'San Francisco');
|
| Correct Answer | C |