One of your customers has decided to deploy location-based services in addition to existingwireless services. The customer requires that the additional access points to be deployed in monitor-onlymode. The most likely reason for this requirement is that the customer has which of these existingwireless devices？（）A、Data CollectionB、802.11b/g VoIPC、802.11b and g clientsD、RFID tags
One of your customers has decided to deploy location-based services in addition to existingwireless services. The customer requires that the additional access points to be deployed in monitor-onlymode. The most likely reason for this requirement is that the customer has which of these existingwireless devices？（）
- A、Data Collection
- B、802.11b/g VoIP
- C、802.11b and g clients
- D、RFID tags
相关考题：
We’d like to have a ________ talk with your security officer of your corps.A.one by oneB.side-by-sideC.face-to-faceD.in turn
–How long will your holiday take? –____________________. (A) About one month(B) It starts on the 15th of March(C) It took one month(D) About on April 15
Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value?() A. ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;B. ALTER TABLE customers MODIFY CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;C. ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn NOT NULL;D. ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn IS NOT NULL;E. ALTER TABLE customers MODIFY name CONSTRAINT cust_name_nn NOT NULL;F. ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name NOT NULL;
YouneedtogeneratealistofallcustomerlastnameswiththeircreditlimitsfromtheCUSTOMERStable.Thosecustomerswhodonothaveacreditlimitshouldappearlastinthelist.Whichtwoquerieswouldachievetherequiredresult?() A.SELECTcust_last_name,cust_credit_limitFROMcustomersORDERBYcust_credit_limitDESCB.SELECTcust_last_name,cust_credit_limitFROMcustomersORDERBYcust_credit_limitC.SELECTcust_last_name,cust_credit_limitFROMcustomersORDERBYcust_credit_limitNULLSLASTD.SELECTcust_last_name,cust_credit_limitFROMcustomersORDERBYcust_last_name,cust_credit_limitNULLSLAST
Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables.Evaluate the SQL statement:SELECT *FROM ordersWHERE cust_id = (SELECT cust_idFROM customersWHERE cust_name = ‘Smith‘);What is the result when the query is executed?（）A.AB.BC.CD.DE.E
If there were only one question left ,what would it most probably be?A.What was your childhood dream?B.What is your biggest achievement?C.What is your parents view of you?D.What was your handest expenrience in the war?
One potential danger is（）the information could be used by others to your disadvantage.AthatBwhatCitDwhich
You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address. The CUSTOMERS table has these columns: CUST_ID NUMBER(4) NOT NULL CUST_NAME VARCHAR2(100) NOT NULL CUST_ADDRESS VARCHAR2(150) CUST_PHONE VARCHAR2(20) Which SELECT statement accomplishes this task?（）A、SELECT* FROM customers;B、SELECT name, address FROM customers;C、SELECT id, name, address, phone FROM customers;D、SELECT cust_name, cust_address FROM customers;E、SELECT cust_id, cust_name, cust_address, cust_phone FROM customers;
You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）A、One tablespace has only one datafileB、Many tablespaces can share one datafileC、One tablespace can have many datafilesD、One datafile can contain many tablespaces
You need to ensure that the Cust_CalcData column is implemented appropriately. What should you do?（）A、Specify that the Cust_CalcData column must be implemented as a computed column of the table. B、Specify that the Cust_CalcData column must be indexed using a non-clustered index.C、Specify that the Cust_CalcData column must be implemented as a column that uses a user-defined data type.D、Specify that the Cust_CalcData column must be updated by a SQL Server Agent job that runs nightly.
单选题在Mary的方案中已经存在“客户”表。应使用哪条语句来为所有数据库用户创建一个“客户”表的同义词（）ACREATE PUBLIC SYNONYM cust ON mary.客户BCREATE PUBLIC SYNONYM cust FOR mary.客户CCREATE SYNONYM cust ON mary.客户FORPUBLICDCREATE SYNONYM cust ON mary.客户；GRANT SELECT ON cust TO PUBLIC
单选题You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address. The CUSTOMERS table has these columns: CUST_ID NUMBER(4) NOT NULL CUST_NAME VARCHAR2(100) NOT NULL CUST_ADDRESS VARCHAR2(150) CUST_PHONE VARCHAR2(20) Which SELECT statement accomplishes this task?（）ASELECT* FROM customers;BSELECT name, address FROM customers;CSELECT id, name, address, phone FROM customers;DSELECT cust_name, cust_address FROM customers;ESELECT cust_id, cust_name, cust_address, cust_phone FROM customers;
单选题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?（）AORD_ID ORD_DATE CUST_ID ORD_TOTAL 09-MAR- 102 35 12500 18-JUL- 106 35 7000 04-AUG- 108 10 8000BORD_ID ORD_DATE CUST_ID ORD_TOTAL 09-MAR- 102 35 12500 18-JUL- 106 35 7000CORD_ID ORD_DATE CUST_ID ORD_TOTAL 04-AUG- 108 10 8000DThe query fails because the subquery returns more than one row.EThe query fails because the outer query and the inner query are using different tables.
问答题Practice 3 Your TV set broke down only one week after it was brought. Write a letter of complaint to the store where your TV set was bought. 1) to express what is wrong with your TV set 2) to make your request (change for a new one, or return the broken one... ) 3) to urge the store to give an early reply You should write approximately 100 words. Do not sign your own name at the end of your letter. Use “Wang Lin” instead. You do not need to write your address and the date.
单选题The accounts receivable department requested an accounts status to allow users to enter either a customer name, customer number, customer phone number and then display the customer out standing balance. You want to restrict the data retrieved based on values entered by the users. Which where clause would you write in the query to select statement to accomplish this task?（）Ap_where_clause B:p_where_clause CWHERE CUST_ID=P_CUST_ID or cust_name=:p_cust_name or cust_phone=:p_cust_phone DWhere cust_ID=p_custid cust_name=p_cust_name or cust_phone=p_cust_phone
单选题Your vessel is approaching a bend. You hear a prolonged blast from around the bend. You should （）.Aback your enginesBstop your engines and driftCanswer with one prolonged blastDsound the danger signal
单选题You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address. The CUSTOMERS table has these columns: Which SELECT statement accomplishes this task?（）A SELECT* FROM customers;B SELECT name, address FROM customers;C SELECT id, name, address, phone FROM customers;D SELECT cust_name, cust_address FROM customers;E SELECT cust_id, cust_name, cust_address, cust_phone FROM customers;
单选题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?（）ASELECT ord_id, cust_id, ord_total FROM orders, customers WHERE cust_name='Mating' AND ord _ date IN ('18-JUL-2000','21-JUL-2000');BSELECT 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'));CSELECT ord_id, cust_id, ord_total FROM orders Where ord_date IN (SELECT ord_date FROM orders, customers Where cust _ name = 'Martin');DSELECT ord_id, cust_id, ord_total FROM orders WHERE cust_id IN (SELECT cust_id FROM customers WHERE cust name = 'Martin');
多选题You need to generate a list of all customer last names with their credit limits from the CUSTOMERS table. Those customers who do not have a credit limit should appear last in the list. Which two queries would achieve the required result?（）ASELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit DESCBSELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limitCSELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit NULLS LASTDSELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_last_name, cust_credit_limit NULLSLAST
单选题Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value?（）AALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;BALTER TABLE customers MODIFY CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;CALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn NOT NULL;DALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn IS NOT NULL;EALTER TABLE customers MODIFY name CONSTRAINT cust_name_nn NOT NULL;FALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name NOT NULL;
单选题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');
单选题You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address. The CUSTOMERS table has these columns: CUST_ID NUMBER(4) NOT NULL CUST_NAME VARCHAR2(100) NOT NULL CUST_ADDRESS VARCHAR2(150) CUST_PHONE VARCHAR2(20) Which SELECT statement accomplishes this task?（）ASELECT* FROM customers;BSELECT name, address FROM customers;CSELECT id, name, address, phone FROM customers;DSELECT cust_name, cust_address FROM customers;ESELECT cust_id, cust_name, cust_address, cust_phone FROM customers;
单选题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?（）ASELECT ord_id, cust_id, ord_total FROM orders, customers WHERE cust_name='Mating' AND ord _ date IN ('18-JUL-2000','21-JUL-2000');BSELECT 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'));CSELECT ord_id, cust_id, ord_total FROM orders Where ord_date IN (SELECT ord_date FROM orders, customers Where cust _ name = 'Martin');DSELECT ord_id, cust_id, ord_total FROM orders WHERE cust_id IN (SELECT cust_id FROM customers WHERE cust name = 'Martin');
单选题No one would believe your account of what had happened. Your story is quite _____AcredulousBcredibleCincredibleDincredulous
单选题When jumping into water upon which there is an oil-fire，you should（）.Abreak the water surface with your hands when diving head-firstBuse your hands to hold your knees to your chestCcover your eyes with one hand while pinching your nose shut and covering your mouth with the otherDenter the water at the bow or stern on the windward side of the vessel