第1题:
Examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables.EMPLOYEESNOT NULL,EMPLOYEE_ID NUMBERPrimary KeyVARCHAR2EMP_NAME(30)VARCHAR2JOB_ID(20)SALARY NUMBERReferencesMGR_ID NUMBEREMPLOYEE_IDcolumnDEPARTMENT_ID NUMBER Foreign key toDEPARTMENT_IDcolumn of theDEPARTMENTStableDEPARTMENTSNOT NULL, PrimaryDEPARTMENT_ID NUMBERKeyVARCHAR2DEPARTMENT_NAME(30)References NGR_IDMGR_ID NUMBERcolumn ofthe EMPLOYEES tableForeign key toLOCATION_ID NUMBERLOCATION_IDcolumn of theLOCATIONS tableLOCATIONSNOT NULL, PrimaryLOCATION_ID NUMBERKeyVARCHAR2CITY|30)Which two SQL statements produce the name, department name, and the city of all the employees who earn more then 10000?()
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;
第2题:
When shoring a damaged bulkhead,effort should be taken to spread the pressure over the ______.
A.maximum possible area
B.minimum possible area
C.nearest watertight door
D.nearest longitudinal girder
第3题:
第4题:
第5题:
The only city on the western coast which has a population of more than one million is()
第6题:
CEA的抗原决定簇中具有较高特异性的是()
第7题:
Gold序列与M序列相比,下面说法正确的是()
第8题:
incinerating offshore
discharging when at least 12 nautical miles from nearest land
grinding to less than 1 and discharging at least 12 nautical miles from nearest land
grinding to less than 1 and discharging at least 25 nautical miles from nearest land
第9题:
5 nautical miles from nearest land
12 nautical miles from nearest land
25 nautical miles from nearest land
None of the above
第10题:
the tanker is within 50 nautical miles from the nearest land
the tanker is no more than 50 nautical miles from the nearest land
the tanker is more than 50 nautical miles from the nearest land
the tanker is not more than 50 nautical miles from the nearest land
第11题:
第12题:
Darwin
Perth
the Gold Coast
Brisbane
第13题:
A.Gold码序列的自相关特性优于M序列
B.Gold码序列的互相关特性优于M序列
C.M序列的自相关特性优于Gold序列
D.M序列的互相关特性优于Gold序列
第14题:
Vessels to which Annex V to MARPOL 73/78 applies may discharge garbage containing plastics ______.
A.5 nautical miles from nearest land
B.12 nautical miles from nearest land
C.25 nautical miles from nearest land
D.None of the above
第15题:
第16题:
The only city on the western coast which has a population of more than one million is()
ADarwin
BPerth
Cthe Gold Coast
DBrisbane
第17题:
CEA的抗原决定簇中具有交叉反应的是()
第18题:
You enabled the flashback logging feature, but you have not specified the location of the flash recovery area. Which location would be used as the default location for the flash recovery area?()
第19题:
A commonly used abbreviation such as NYC is used
The name is spelled out
The geographical coordinates are used
The radio station call sign for the nearest marine radio station is used
第20题:
第21题:
Cisco WCS Base and Cisco WCS Location both indicate rogue AP location only in a Rogue AP Alarm text file
Cisco WCS Base and Cisco WCS Location both indicate rogue AP location in a map at the most probable location that is calculated by two or more APs
Cisco WCS Base identifies the general location of rogue APs based on the signal strength received by the nearest managed Cisco APs, whereas Cisco WCS Location adds high-accuracy location tracking to within a few meters of the rogue AP
Cisco WCS Base does not have this feature, whereas Cisco WCS Location can indicate rogue AP location in a map at the most probable location that is calculated by two or more APs
Cisco WCS Base does not have this feature, whereas Cisco WCS Location can indicate rogue AP location in a map beside the nearest associated AP
第22题:
SELECT emp_name, department_name, city FROM employees e JOIN departments d USING (department_id) JOIN locations 1 USING (location_id) WHERE salary > 10000;
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;
SELECT emp_name, department_name, city FROM employees e, departments d, locations 1 WHERE salary > 10000;
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;
SELECT emp_name, department_name, city FROM employees e NATURAL JOIN departments, locations WHERE salary > 10000;
第23题:
at current price at the nearest main bunkering port
at current price at the port of redelivery if it is not available to obtain the current price at the nearest main bunkering port
at current price at the nearest main bunkering port if it is cheaper than that at the port of redelivery
at current price at the port of redelivery if it is obtainable,even the price is higher at the nearest main bunkering port