网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
The international number，location and/or name，geographical co-ordinates，characteristics and intensity，elevation in metres，range in sea miles and description of structure of a light can be found in（）.
A
Ocean Passages for the World
B
Admiralty List of Radio Signals
C
IALA Maritime Buoyage System
D
Admiralty List of Lights and Fog Signals
参考答案
参考解析
解析：
暂无解析
更多 “单选题The international number，location and/or name，geographical co-ordinates，characteristics and intensity，elevation in metres，range in sea miles and description of structure of a light can be found in（）.A Ocean Passages for the WorldB Admiralty List of Radio SignalsC IALA Maritime Buoyage SystemD Admiralty List of Lights and Fog Signals” 相关考题
考题
The most traditional definition of a human community was a group of people larger than a family that interact. A community may include people who have at least one common point of interest. In the past, community members lived relatively close to one another in one geographical location: in the same village, town, or city. Nowadays, however, the word community can mean a national, an international, or even an online group of interacting individuals. Therefore, a new definition of community might be a group of people that recognize that they have something in common.
考题
The compass error of a magnetic compass that has no deviation is ______.A.zeroB.equal to variationC.eliminated by adjusting the compassD.constant at any geographical location
考题
Examine the structure of the EMPLOYEES table:Column name Data type RemarksEMPLOYEE_ID NUMBER NOT NULL, Primary KeyLAST_NAME VARCNAR2(30)FIRST_NAME VARCNAR2(30)JOB_ID NUMBERSAL NUMBERMGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBERYou need to create an index called NAME_IDX on the first name and last name fields of the EMPLOYEES table. Which SQL statement would you use to perform this task? （）A. CREATE INDEX NAME _IDX (first_name, last_name);B. CREATE INDEX NAME _IDX (first_name, AND last_name)C. CREATE INDEX NAME_IDX ON (First_name, last_name);D. CREATE INDEX NAME_IDX ON employees (First_name, AND last_name);E. CREATE INDEX NAME_IDX ON employees (First_name, last_name);F. CREATE INDEX NAME_IDX FOR employees (First_name, last_name);
考题
Examine the structure of the EMPLOYEES and DEPARTMENTS tables:EMPLOYEESEMPLOYEE_ID NUMBERDEPARTMENT_ID NUMBERMANAGER_ID NUMBERLAST_NAME VARCHAR2(25)DEPARTMENTSDEPARTMENT_ID NUMBERMANAGER_ID NUMBERDEPARTMENT_NAME VARCHAR2(35)LOCATION_ID NUMBERYou want to create a report displaying employee last names, department names, and locations. Which query should you use to create an equi-join?（）A. SELECT last_name, department_name, location_id FROM employees , department ;B. SELECT employees.last_name, departments.department_name, departments.location_id FROM employees e, departments D WHERE e.department_id = d.department_id;C. SELECT e.last_name, d.department_name, d.location_id FROM employees e, departments D WHERE manager_id = manager_id;D. SELECT e.last_name, d.department_name, d.location_id FROM employees e, departments D WHERE e.department_id = d.department_id;
考题
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;
考题
The UN number of a dangerous cargo in package can be found in ________ ．A.International Maritime Dangerous Goods Carried by SeaB.International Code for the Construction and Equipment of Ships Carrying Liquefied Gases in BulkC.International Convention for the Safety of Life at SeaD.International Code for the Construction and Equipment of Ships Carrying Dangerous Chemicals in Bulk
考题
There are some reasons for the increasing of the Australia’s economy，except( ) A.its open investment environment
B.business friendly regulatory approach
C.its trade and economic links with emerging economies
D.its unique geographical location in northern hemisphere
考题
According to its geographical location，which one can be used to represent Australia？( ) A.The Land Down Under
B.Uncle Sam
C.John Bull
D.Polar Bear
考题
A home user wants to setup a wireless network. Which of the following would be the MOST important consideration?（）A、Operating system type of the connected PCsB、Location of the wireless routerC、Number of PCs that will access the networkD、Number of available Ethernet ports on the router
考题
Which statement is true about vishing？（）A、Influencing users to forward a call to a toll number （for example， a long distance or international number）B、Influencing users to provide personal information over a web pageC、Using an inside facilitator to intentionally forward a call to a toll number （for example， a long distance orinternational number）D、Influencing users to provide personal information over the phone
考题
When performing incomplete recovery using UNTIL SEQUENCE with RMAN， which two pieces of information are required？（）A、Thread number.B、Log Sequence number.C、Control file sequence number.D、Name of the last archived log.
考题
Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) Which statement produces the number of different departments that have employees with last name Smith?（）A、SELECT COUNT(*) FROM employees WHERE last_name='Smith';B、SELECT COUNT(dept_id) FROM employees WHERE last_name='Smith';C、SELECT DISTINCT(COUNT(dept_id)) FROM employees WHERE last_name='Smith';D、SELECT COUNT(DISTINCT dept_id) FROM employees WHERE last_name='Smith';E、SELECT UNIQUE(dept_id) FROM employees WHERE last_name='Smith';
考题
Examine the structure of the EMPLOYEES table: Column name Data type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key LAST_NAME VARCNAR2(30) FIRST_NAME VARCNAR2(30) JOB_ID NUMBER SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER You need to create an index called NAME_IDX on the first name and last name fields of the EMPLOYEES table. Which SQL statement would you use to perform this task? （）A、CREATE INDEX NAME _IDX (first_name, last_name);B、CREATE INDEX NAME _IDX (first_name, AND last_name)C、CREATE INDEX NAME_IDX ON (First_name, last_name);D、CREATE INDEX NAME_IDX ON employees (First_name, AND last_name);E、CREATE INDEX NAME_IDX ON employees (First_name, last_name);F、CREATE INDEX NAME_IDX FOR employees (First_name, last_name);
考题
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?（）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;
考题
Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEES EMPLOYEE_ID NUMBER DEPARTMENT_ID NUMBER MANAGER_ID NUMBER LAST_NAME VARCHAR2(25) DEPARTMENTS DEPARTMENT_ID NUMBER MANAGER_ID NUMBER DEPARTMENT_NAME VARCHAR2(35) LOCATION_ID NUMBER You want to create a report displaying employee last names, department names, and locations. Which query should you use?（）A、SELECT e.last_name, d. department_name, d.location_id FROM employees e NATURAL JOIN departments D USING department_id ;B、SELECT last_name, department_name, location_id FROM employees NATURAL JOIN departments WHERE e.department_id =d.department_id;C、SELECT e.last_name, d.department_name, d.location_id FROM employees e NATURAL JOIN departments d;D、SELECT e.last_name, d.department_name, d.location_id FROM employees e JOIN departments d USING (department_id );
考题
When performing a database duplication， which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location？（） A、 log_file_name_convertB、 convert_log_file_nameC、 file_name_convert_logD、 redo_log_file_name_convertE、 logfile_convert_directory
考题
单选题Under the International Code of Signals how are geographical locations such as New York City transmitted?（）A
A commonly used abbreviation such as NYC is usedB
The name is spelled outC
The geographical coordinates are usedD
The radio station call sign for the nearest marine radio station is used
考题
单选题Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEES EMPLOYEE_ID NUMBER DEPARTMENT_ID NUMBER MANAGER_ID NUMBER LAST_NAME VARCHAR2(25) DEPARTMENTS DEPARTMENT_ID NUMBER MANAGER_ID NUMBER DEPARTMENT_NAME VARCHAR2(35) LOCATION_ID NUMBER You want to create a report displaying employee last names, department names, and locations. Which query should you use to create an equi-join?（）A
SELECT last_name, department_name, location_id FROM employees , department ;B
SELECT employees.last_name, departments.department_name, departments.location_id FROM employees e, departments D WHERE e.department_id = d.department_id;C
SELECT e.last_name, d.department_name, d.location_id FROM employees e, departments D WHERE manager_id = manager_id;D
SELECT e.last_name, d.department_name, d.location_id FROM employees e, departments D WHERE e.department_id = d.department_id;
考题
单选题Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) Which statement produces the number of different departments that have employees with last name Smith? （）A
SELECT COUNT (*) FROM employees WHERE last _name='smith';B
SELECT COUNT (dept_id) FROM employees WHERE last _name='smith';C
SELECT DISTINCT (COUNT (dept_id) FROM employees WHERE last _name='smith';D
SELECT COUNT (DISTINCT dept_id) FROM employees WHERE last _name='smith';E
SELECT UNIQE (dept_id) FROM employees WHERE last _name='smith';
考题
多选题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?（）ASELECT emp_name, department_name, city FROM employees e JOIN departments d USING (department_id) JOIN locations 1 USING (location_id) WHERE salary 10000;BSELECT 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;CSELECT emp_name, department_name, city FROM employees e, departments d, locations 1 WHERE salary 10000;DSELECT 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;ESELECT emp_name, department_name, city FROM employees e NATURAL JOIN departments, locations WHERE salary 10000;
考题
单选题Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEES EMPLOYEE_ID NUMBER DEPARTMENT_ID NUMBER MANAGER_ID NUMBER LAST_NAME VARCHAR2(25) DEPARTMENTS DEPARTMENT_ID NUMBER MANAGER_ID NUMBER DEPARTMENT_NAME VARCHAR2(35) LOCATION_ID NUMBER You want to create a report displaying employee last names, department names, and locations. Which query should you use?（）A
SELECT e.last_name, d. department_name, d.location_id FROM employees e NATURAL JOIN departments D USING department_id ;B
SELECT last_name, department_name, location_id FROM employees NATURAL JOIN departments WHERE e.department_id =d.department_id;C
SELECT e.last_name, d.department_name, d.location_id FROM employees e NATURAL JOIN departments d;D
SELECT e.last_name, d.department_name, d.location_id FROM employees e JOIN departments d USING (department_id );
考题
单选题The number of international students at our university ______ steadily, but a number of universities in the state ______ international student enrollment decline.A
has grown； has seenB
have grown；has seenC
have grown；have seenD
has grown；have seen
考题
单选题Examine the structure of the EMPLOYEES table: Column name Data type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key LAST_NAME VARCNAR2(30) FIRST_NAME VARCNAR2(30) JOB_ID NUMBER SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER You need to create an index called NAME_IDX on the first name and last name fields of the EMPLOYEES table. Which SQL statement would you use to perform this task?（）A
CREATE INDEX NAME _IDX (first_name, last_name);B
CREATE INDEX NAME _IDX (first_name, AND last_name)C
CREATE INDEX NAME_IDX ON (First_name, last_name);D
CREATE INDEX NAME_IDX ON employees (First_name, AND last_name);E
CREATE INDEX NAME_IDX ON employees (First_name, last_name);F
CREATE INDEX NAME_IDX FOR employees (First_name, last_name);
考题
单选题The compass error of a magnetic compass that has no deviation is（）.A
zeroB
equal to variationC
eliminated by adjusting the compassD
constant at any geographical location
考题
单选题Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables. EMPLOYEES NOT NULL, Primary EMPLOYEE_ID NUMBER 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, DEPARTMENT_ID NUMBER Primary Key VARCHAR2 DEPARTMENT_NAME |30| References MGR_ID column MGR_ID NUMBER of the EMPLOYEES table TAX MIN_SALARY NUMBER MAX_SALARY NUMBER TAX_PERCENT NUMBER For which situation would you use a nonequijoin query?（）A
To find the tax percentage for each of the employees.B
To list the name, job id, and manager name for all the employees.C
To find the name, salary, and department name of employees who are not working with Smith.D
To find the number of employees working for the Administrative department and earning less then 4000.E
To display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned.
考题
在Oracle 中，下列语句中哪些可以合法地创建一个函数？ (1.0分) [多选]
A. CREATE FUNCTION func_name(cdcode NUMBER) RETURN CHAR IS DECLARE dis_cd CHAR(15);
BEGIN .. END; B. CREATE FUNCTION func_name(cdcode NUMBER) RETURN CHAR IS dis_cd CHAR(15);
BEGIN .. END; C. CREATE FUNCTION func_name(cdcode NUMBER) IS
BEGIN .. END; D. CREATE FUNCTION func_name(cdcode NUMBER) RETURN CHAR IS
BEGIN .. END; E. CREATE FUNCTION func_name(cdcode NUMBER) RETURN CHAR IS DECLARE dis_cd STRING (15);
BEGIN .. END;
热门标签
最新试卷
