Which two statements are true about sequences created in a single instance database? (Choose two.)
The EMPLOYEES table contains these columns:EMPLOYEE_ID NUMBER(4)ENAME VARCHAR2 (25)JOB_ID VARCHAR2(10)Which SQL statement will return the ENAME, length of the ENAME, and the numeric position of the letter "a" in the ENAME column, for those employees whoseENAME ends with a the letter "n"?
The ORDERS TABLE belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to the user HR.Which statement would create a synonym ORD so that HR can execute the following query successfully?SELECT * FROM ord;
Which four are valid Oracle constraint types? (Choose four.)
Evaluate this SQL statement:SELECT e.emp_name, d.dept_name -FROM employees e -JOIN departments d -USING (department_id)WHERE d.department_id NOT IN (10,40)ORDER BY dept_name;The statement fails when executed. Which change fixes the error?
Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? (Choose three.)
