Examine the description of the EMPLOYERS table:

Examine these requirements:
Disable the manager ID and salary of the lowest paid employees for that manager.
Exclude anyone whose manager is not known.
Exclude any managers where the minimum salary is 6000 or less.
Sort the output by minimum salary with the highest salary shown first.
Which statement will do this?

• A.SELECT manager_id, MIN(salary)
  FROM employees
  WHERE manager_id IS NOT NULL
  AND MIN(salary) > 6000
  GROUP BY manager_id
  ORDER BY MlN (salary) DESC;
• B.SELECT manager_id, MTN(salary)
  FROM employees
  WHERE manager_ id IS NOT NULL
  GROUP BY manager_id
  HAVING MlN (salary) > 6000
  ORDER BV MlN (salary);
• C.SELECT managar_id, MIN (salary)
  FROM employees
  HAVING MIN(salary) > 6000
  WHERE manager_id IS NOT NULL
  GROUP BY manager_id
  ORDER BY MTN(salary) DESC;
• D.SELECT manager_id, HTN(salary)
  FROM employees
  WHERE manager_id IS NOT NULL
  HAVING MIN (salary) > 6000
  GROUP BY manager_id
  ORDEU BY MIN (salary) DESC;

Comment: *

Name: *

Email: *

Verification: *

You want to display 5 percent of the rows from the sales table for products with the lowestAMOUNT_SOLD and also want to include the rows that have the sameAMOUNT_SOLDeven if this causes the output to exceed 5 percent of the rows.
Which query willprovide the required result?

• A.SELECT prod_id, cust_id, amount_sold FROM sales ORDER BY amount__sold FETCH FIRST 5 PERCENT ROWS ONLY;
• B.SELECT prod_id, cust_id, amount_sold FROM sales ORDER BY amount_sold FETCH FIRST 5 PERCENT ROWS ONLY WITH TIES;
• C.SELECT prod_ id, cust_id, amount_sold FROM sales ORDER BY araount_sold FETCH FIRST 5 PERCENT ROWS WITH TIES ONLY;
• D.SELECT prod_id, cust_id, amount_sold FROM sales ORDER BY amount_sold FETCH FIRST 5 PERCENT ROWS WITH TIES;

Comment: *

Name: *

Email: *

Verification: *

Evaluate the following CRTEATE TABLE commands:
CREATE_TABLE orders
(ord_no NUMBER (2) CONSTRAINT ord_pk PRIMARY KEY,
ord_date DATE,
cust_id NUMBER (4) );
CREATE TABLE ord_items
(ord _no NUMBER (2),
item_no NUMBER(3),
qty NUMBER (3) CHECK (qty BETWEEEN 100 AND 200),
expiry_date date CHECK (expiry_date> SYSDATE),
CONSTRAINT it_pk PRIMARY KEY (ord_no, item_no),
CONSTARAINT ord_fk FOREIGN KEY (ord_no) REFERENCES orders (ord_no) );
The above command fails when executed. What could be the reason?

• A.The BETWEEN clause cannot be used for the CHECK constraint.
• B.ORD_NO and ITEM_NO cannot be used as a composite primary key because ORD_NO is also the FOREIGN KEY.
• C.SYSDATE cannot be used with the CHECK constraint.
• D.The CHECK constraint cannot be placed on columns having the DATE data type.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true reading subquenes?

• A.The subquery and main query must retrieve date from the same table.
• B.Only one column or expression can be compared between the subquery and main query.
• C.Multiple columns or expressions can be compared between the subquery and main query.
• D.A subquery can have more than one main query
• E.The subquery and main query can retrieve data from different tables.
• F.A Main query can have many subqueries.

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the descriptions of the DEPTand LOCATIONStables.

You want to update the CITYcolumn of the DEPTtable for all the rows with the corresponding value in the CITYcolumn of the LOCATIONStable for each department.
Which SQL statement would you execute to accomplish the task?
UPDATE dept d

• A.SET city = ANY (SELECT city
  FROM locations l)
  UPDATE dept d
• B.SET city = ALL (SELECT city
  FROM locations l
  WHERE d.location_id = l.location_id);
  UPDATE dept d
• C.SET city = (SELECT city
  FROM locations l)
  WHERE d.location_id = l.location_id;
  UPDATE dept d
• D.SET city = (SELECT city
  FROM locations l
  WHERE d.location_id = l.location_id);

Comment: *

Name: *

Email: *

Verification: *