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 doyou use?
You own a table called EMPLOYEES with this table structure:EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2(25)LAST_NAME VARCHAR2(25)HIRE_DATE DATEWhat happens when you execute this DELETE statement?DELETE employees;
You need to create a table named ORDERS that contains four columns:1. an ORDER_ID column of number data type2. a CUSTOMER_ID column of number data type3. an ORDER_STATUS column that contains a character data type4. a DATE_ORDERED column to contain the date the order was placedWhen a row is […]
Evaluate this SQL statement:SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAMEFROM EMPLOYEES e, DEPARTMENTS dWHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID;In the statement, which capabilities of a SELECT statement are performed?
Which three are DATETIME data types that can be used when specifying column definitions?(Choose three.)
Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?
Examine the structure of the EMPLOYEES table:EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2(25)LAST_NAME VARCHAR2(25)Which three statements insert a row into the table? (Choose three.)
Which SELECT statement should you use to extract the year from the system date and display itin the format "1998"?
Which two statements about sequences are true? (Choose two.)
In which two cases would you use an outer join? (Choose two.)