首页/ 题库 / [多选题]Examine the structur的答案

Examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. EMPLOYEES NOT NULL, EMPLOYEE_ID NUMBER Primary Key VARCHAR2 EMP_NAME (30) VARCHAR2 JOB_ID (20) SALARY NUMBER References MGR_ID NUMBER EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table DEPARTMENTS NOT NULL, Primary DEPARTMENT_ID NUMBER Key VARCHAR2 DEPARTMENT_NAME (30) References NGR_ID MGR_ID NUMBER column of the EMPLOYEES table Foreign key to LOCATION_ID NUMBER LOCATION_ID column of the LOCATIONS table LOCATIONS NOT NULL, Primary LOCATION_ID NUMBER Key VARCHAR2 CITY |30) Which two SQL statements produce the name, department name, and the city of all the employees who earn more then 10000?()

多选题
2022-01-18 16:49
A、SELECT emp_name, department_name, city FROM employees e JOIN departments d USING (department_id) JOIN locations 1 USING (location_id) WHERE salary > 10000;
B、SELECT emp_name, department_name, city FROM employees e, departments d, locations 1 JOIN ON (e.department_id = d.department id) AND (d.location_id =1.location_id) AND salary > 10000;
C、SELECT emp_name, department_name, city FROM employees e, departments d, locations 1 WHERE salary > 10000;
D、SELECT emp_name, department_name, city FROM employees e, departments d, locations 1 WHERE e.department_id = d.department_id AND d.location_id = 1.location_id AND salary > 10000;
E、SELECT emp_name, department_name, city FROM employees e NATURAL JOIN departments, locations WHERE salary > 10000;
查看答案

正确答案
A | D

试题解析

感兴趣题目
The carrier is liable for loss of or damage to the goods or delay in delivery caused by fire,()the claimant proves that the fire arose from fault or neglect on the part of the carrier,his servants or agents.
The()enables water to be blow down or emptied from the boilerIt may be used when partially or completely emptying the boiler.
The guard, fencing or shielding for moving parts or machinery can be removed for repair only when the machinery it belongs to()
The merchant undertakes that no claim or allegation shall be made against any servant,agent or subcontractor of the carrier which()to impose upon any of them or any liability whatsoever in connection with the goods.
Although the Shipowner may be responsible for the loss or damage to the goods,his liability may be limited()the terms of the contract or the statute.
()shall be liable for loss of and damage to the Vessel and/or goods arising or resulting from inaccuracies in stating the description,quantity,weight,measurement or contents.
Every deliberate act of wrongdoing by the master or any of the crew against the ship or cargo,without the authorization or privity of the Shipowner or his agent,is().
(), or drum is used for hauling in or letting out the wires or ropes which will fasten the ship to the shore.
A salvor may be()the whole or part of the payment due under Salvage Convention to the extent that the salvage operations have become necessary or more difficult because of fault or neglect on his part or if the salvor has been guilty of fraud or other dishonest conduct.
The () is used for hauling in or letting out the wires or ropes.
The()may examine or re-examine the goods or take samples from them straightaway in the absence of the consignee or the consignor whenever it considers this necessary.
Should it appear that war or blockade would prevent the vessel from safely reaching the port of destination and / or discharging the goods thereat,the Carrier().
相关题目

A campus emergency ______ occur at any time of the day or night, weekend, or holiday, with little or no warning.

A cabinet or space containing the controls or valves for the fixed firefighting system must be().
A cabinet or space containing the controls or valves for the fixed firefighting system must be().
Following a collision or accident,the Master of each vessel involved must render assistance to persons affected by the collision or accident().
Now almost all the parents want their children to learn the piano or the violin, _____ their children are willing or not.( )
1_____education is the instruction that occurs when the instructor and students are separated by distance or time,or both
Goods of an inflammable,explosive or dangerous nature to the shipment whereof the carrier,master or agent of the carrier,has not consented,with knowledge of their nature and character,may at any time before discharge,()at any place or destroyed or rendered innocuous by the carrier without compensation.
In the northern hemisphere, the largest waves or swells created by a typhoon or hurricane will be located().
()any case or suspected case of quarantinable disease,or any case of eruptive disease or any death be discovered,the local quarantine officer must be notified immediately.
Should any case or suspected case of quarantinable disease,or any case of eruptive disease or any death be discovered,the local Quarantine Officer must be()immediately.
When a vessel sees the other ahead or nearly ahead,by night she could see the masthead lights of the other in a line or nearly in a line or both side lights,()shall be deemed to exist.
Masters are()solely responsible for all damages or accidents of whatever kind resulting from the navigating or handling of their vessels by day or by night.
The Urgency Signal()indicates that the station calling has a very urgent message to transmit concerning the safety of a ship or aircraft,or of some person on board or within sight.
If the state of the goods at the time they were handed over to the consignee has been the subjectof a joint survey or inspection by the parties,notice in writing()be given of loss or damage ascertained during such survey or inspection.
()means any person by whom or in whose name or on whose behalf a contract of carriage of goods by sea has been concluded with a carrier,or any person by whom or in whose name or on whose behalf the goods are actually delivered to the carrier in relation to the contract of carriage of goods by sea.
If he is a common carrier,he is absolutely responsible to the owner of the goods carried ()any loss or damage to them unless caused by an Act of God or the Queen’s enemies,or the inherent vice in the goods themselves,or the negligence of the owner of the goods,or a general average sacrifice.
During loading or discharging,where the delay is due to the Shipowner’s fault,or that of his servants or agents acting within their authority,the time actually delayed is to be()in calculating lay days.
The court may reduce or deny remuneration if it appears that the salvors have by their fault ()or have been guilty of theft,receiving stolen goods,or other acts of fraud.
Owners are to be responsible for loss of or damage to the goods or delay in delivery of the goods only in case the loss,damage or delay has been caused by the improper or negligent stowage of the goods.This means that().
Where a container,pallet or similar article of transport is used to consolidate goods,the number of packages or units enumerated in the bill of lading as packed in such article of transport()to be the number of packages or units in calculating the amount beyond which the carrier or the ship is not reliable.
广告位招租WX:84302438

免费的网站请分享给朋友吧