The EMPLOYEES table contains these columns:
EMPLOYEE_ID NUMBER(4)
LAST_NAME VARCHAR2 (25)
JOB_ID VARCHAR2(10)
You want to search for strings that contain 'SA_' in the JOB_ID column. Which SQL statement do you use?

• A. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE
  '%SA\_' ESCAPE '\';
• B. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE
  '%SA_';
• C. SELECT employee_id, last_name, job_id FROM employees WHERE job_id = '%SA_';
• D. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE
  '%SA_' ESCAPE "\";

Examine the description of the CUSTOMERS table:

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?

• A. SELECT city_address, COUNT(*)FROM. customersWHERE city_address IN ( 'Los Angeles', 'San Fransisco');
• B. SELECT city_address, COUNT(customer_id)FROM. customersWHERE city_address IN ( 'Los Angeles', 'San Fransisco')GROUP BY. city_address, customer_id;
• C. SELECT city_address, COUNT (customer_id)FROM . customersGROUP BY
  city_address IN ( 'Los Angeles', 'San Fransisco');
• D. SELECT city_address, COUNT (*)FROM. customersWHERE city address IN ( 'Los Angeles', 'San Fransisco')GROUP BY city_address;

You need to create a table for a banking application. One of the columns in the table has the following requirements:
1) You want a column in the table to store the duration of the credit period.
2) The data in the column should be stored in a format such that it can be easily added and subtracted with date data type without using conversion functions.
3) The maximum period of the credit provision in the application is 30 days.
4) The interest has to be calculated for the number of days an individual has taken a credit for.
Which data type would you use for such a column in the table?

• A. INTERVAL DAY TO SECOND
• B. TIMESTAMP
• C. DATE
• D. INTERVAL YEAR TO MONTH
• E. NUMBER

Examine the structure of the EMPLOYEES and DEPARTMENTS tables:

You want to create a report displaying employee last names, department names, and locations. Which query should you use to create an equi-join?

• A. SELECT last_name, department_name, location_id FROM employees , departments ;
• B. SELECT employees.last_name, departments.department_name,
  departments.location_id FROM employees e, departments D WHERE e.department_id
  = d.department_id;
• C. SELECT e.last_name, d.department_name, d.location_id FROM employees e, departments D WHERE e.department_id =d.department_id;
• D. SELECT e.last_name, d.department_name, d.location_id FROM employees e, departments D WHERE manager_id =manager_id;