搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单项选择题】

On receiving the order “Lower away”, lower the anchor（） it is clear of the hawse pipe.

A、A.until

B、B.till

C、C.as

D、D.when

查看正确答案
更多“On receiving the order “Lower away”, lower the anchor（） it is clear of the hawse pipe.”相关的问题
第1题
[多选题] On your Oracle Database, you issue the following commands to create indexes: SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which two statements are true?（）

A、Only the ORD_CUSTOMER_IX1 index created.  B、Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.  C、Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.  D、The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.  E、Both the indexes are created and used by the optimizer for queries on the ORDERS table.  F、Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.  

点击查看答案
第2题
[多选题] On your Oracle 12c database, you Issue the following commands to create indexes SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id); Which two statement are correct?（）

A、Both the indexes are created; however, only the ORD_COSTOMER index is visible.  B、The optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan.  C、Only the ORD_CUSTOMER_IX1 index is created.  D、Only the ORD_CUSTOMER_IX2 index is created.  E、Both the indexes are updated when a new row is inserted, updated, or deleted In the orders table.  

点击查看答案
第3题
[单选题] Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables. Which SQL statement retrieves the order ID, customer ID, and order total for the orders that are placed on the same day that Martin placed his orders?（）

A、SELECT ord_id, cust_id, ord_total FROM orders, customers WHERE cust_name='Martin' AND ord_date IN ('18-JUL-2000','21-JUL-2000');  B、SELECT ord_id, cust_id, ord_total FROM orders WHERE ord_date IN (SELECT ord_date FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = 'Martin'));  C、SELECT ord_id, cust_id, ord_total FROM orders WHERE ord_date IN (SELECT ord_date FROM orders, customers WHERE cust_name = 'Martin');  D、SELECT ord_id, cust_id, ord_total FROMorders WHERE cust_id IN (SELECT cust_id FROM customers WHERE cust_name = 'Martin');  

点击查看答案
第4题
[] 接待来船拜访人员。（）

A、A. Receiving the person who comes on board to do their business.  B、B. Receiving the persons who comes on board to visit.  C、C. Receiving the persons who comes on board to do the job.  D、D. Receiving the persons who comes on board to look around the ship.  

点击查看答案
第5题
[单选题] The main tasks for sailors on duty are, first of all,（）the persons who come on board to do their business.

A、received  B、receives  C、receiving  D、receive  

点击查看答案
第6题
[单选题] Examine the data from the ORDERS and CUSTOMERS table. ORDERS ORD_ID ORD_DATE CUST_ID ORD_TOTAL 100 12-JAN-2000 15 10000 09-MAR- 101 40 8000 09-MAR- 102 35 12500 15-MAR- 103 15 12000 104 25-JUN-2000 15 6000 105 18-JUL-2000 20 5000 106 18-JUL-2000 35 7000 107 21-JUL-2000 20 6500 04-AUG- 108 10 8000 CUSTOMERS CUST_ID CUST_NAME CITY 10 Smith Los Angeles 15 Bob San Francisco 20 Martin Chicago 25 Mary New York 30 Rina Chicago 35 Smith New York 40 Linda New York Which SQL statement retrieves the order ID, customer ID, and order total for the orders that are placed on the same day that Martin places his orders?（）

A、SELECT ord_id, cust_id, ord_total FROM orders, customers WHERE cust_name='Mating' AND ord _ date IN ('18-JUL-2000','21-JUL-2000');  B、SELECT ord_id, cust_id, ord_total FROM orders Where ord_date IN (SELECT ord_date FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = 'MARTIN'));  C、SELECT ord_id, cust_id, ord_total FROM orders Where ord_date IN (SELECT ord_date FROM orders, customers Where cust _ name = 'Martin');  D、SELECT ord_id, cust_id, ord_total FROM orders WHERE cust_id IN (SELECT cust_id FROM customers WHERE cust name = 'Martin');  

点击查看答案
第7题
[单选题] 接待来船办理业务的人员。（）

A、Receive the PSC inspector who wants to see our captain.  B、Receive the visitors who come on board to look around the ship.  C、Receive the persons who come on board to do their business.  D、Receive the ship chandler who wants to come to our ship.  

点击查看答案
第8题
[单选题] What is the action that a GMDSS Radio Operator should take when a DSC distress alert is received? （）

A、No action is necessary，as the DSC control unit will automatically switch to the NBDP follow-on communications frequency  B、The operator should immediately set continuous watch on the radiotelephone frequency that is associated with the frequency band on which the distress alert was received  C、The Operator should immediately set continuous watch on VHF channel 70  D、The Operator should immediately set continuous watch on the NBDP frequency that is associated with the frequency band on which the distress alert was received  

点击查看答案
第9题
[单选题] An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command: SQL>CREATE INDEX ord_custname_ix ON orders(custname); The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause. You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.Which is the most efficient method of performing this task?（）

A、disabling the index  B、making the index invisible  C、making the index unusable  D、using the MONITORING USAGE clause for the index  

点击查看答案
第10题
[单选题] Examine the data from the ORDERS and CUSTOMERS tables. ORDERS ORD_ID ORD_DATE CUST_ID 12-JAN- 100 15 10000 09-MAR- 101 40 8000 09-MAR- 102 35 12500 15-MAR- 103 15 12000 25-JUN- 104 15 6000 18-JUL- 105 20 5000 106 18-JUL- 35 7000 21-JUL- 107 20 6500 04-AUG- 109 10 8000 CUSTOMERS CUST_ID CUST_NAME CITY 10 Smith Los Angeles 15 Bob San Francisco 20 Martin Chicago 25 Mary New York 30 Rina Chicago 35 Smith New York 40 Lind New York Evaluate the SQL statement: SELECT * FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = 'Smith'); What is the result when the query is executed?（）

A、ORD_ID ORD_DATE CUST_ID ORD_TOTAL 09-MAR- 102 35 12500 18-JUL- 106 35 7000 04-AUG- 108 10 8000  B、ORD_ID ORD_DATE CUST_ID ORD_TOTAL 09-MAR- 102 35 12500 18-JUL- 106 35 7000  C、ORD_ID ORD_DATE CUST_ID ORD_TOTAL 04-AUG- 108 10 8000  D、The query fails because the subquery returns more than one row.  E、The query fails because the outer query and the inner query are using different tables.  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服