Evaluate the SQL statement: 1 SELECT a.emp_name, a.sal, a.dept_id, b.maxsal 2 FROM employees a, 3 (SELECT dept_id, MAX(sal) maxsal 4. FROM employees 5 GROUP BY dept_id) b 6 WHERE a.dept_id = b.dept_id 7 AND a. asl < b. maxsal; What is the result of the statement? ()
Evaluate these two SQL statements:SELECT last_name, salary, hire_dateFROM EMPLOYEES ORDRE BY salary DESC; SELECT last_name, salary, hire_dateFROM EMPOLYEES ORDER BY 2 DESC; What is true about them?()
Evaluate the following statements: What are the two consequences of the above statements?()
Evaluate the following SQL statements that are issued in the given order: What would be the status of the foreign key EMP_MGR_FK?()
Evaluate the following command: SQL>ALTER SYSTEM SET db_securefile = 'IGNORE'; What is the impact of this setting on the usage of SecureFiles?()
Evaluate the following function code: Which statement is true regarding the above function? ()
Given: 11.<% java.util.Map map = new java.util.HashMap(); 12.request.setAttribute("map", map); 13.map.put("a", "b"); 14.map.put("b", "c"); 15.map.put("c", "d"); %> 16.<%-- insert code here --%> Which three EL expressions, inserted at line 16, are valid and evaluate to "d"?()
Evaluate the following statements: CREATE TABLE purchase_orders (po_id NUMBER(4), po_date TIMESTAMP, supplier_id NUMBER(6), po_total NUMBER(8,2), CONSTRAINT order_pk PRIMARY KEY(po_id)) PARTITION BY RANGE(po_date) (PARTITION Q1 VALUES LESS THAN (TO_DATE(?1-apr-2007?d-mon-yyyy?), PARTITION Q2 VALUES LESS THAN (TO_DATE(?1-jul-2007?d-mon-yyyy?), PARTITION Q3 VALUES LESS THAN(TO_DATE(?1-oct - 2007?d-mon-yyyy?), PARTITION Q4 VALUES LESS THAN (TO_DATE(?1-jan-2008?d-mon-yyyy?)); CREATE TABLE purchase_order_items (po_id NUMBER(4) NOT NULL, product_id NUMBER(6) NOT NULL, unit_price NUMBER(8,2), quantity NUMBER(8), CONSTRAINT po_items_fk FOREIGN KEY (po_id) REFERENCES purchase_orders(po_id)) PARTITION BY REFERENCE(po_items_fk); What are the two consequences of the above statements?()
Evaluate these two SQL statements: What is true about them?()
Evaluate the set of SQL statements: What is true about the set?()