网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
A Power 770 customer needs to add additional I/O adapters. There is no room for the cards， so an I/O drawer must be added. What resource will help identify supported I/O drawers and the maximum number of drawers permitted per loop？（）
- A、I/O Planning Guide
- B、Power Systems data sheet
- C、Power Systems Facts and Features
- D、Run FLRT to recommend I/O features
参考答案
更多 “ A Power 770 customer needs to add additional I/O adapters. There is no room for the cards， so an I/O drawer must be added. What resource will help identify supported I/O drawers and the maximum number of drawers permitted per loop？（）A、I/O Planning GuideB、Power Systems data sheetC、Power Systems Facts and FeaturesD、Run FLRT to recommend I/O features” 相关考题
考题
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
考题
AcustomerplanstoconsolidateseveralsystemsontoPOWER7.Theirimmediaterequirementistohavea singlePower770,andtheywillbuyasecondPower770atalaterstage.Theywanttokeeptheirexisting threePOWER5570sandthreePOWER6520swhichareallmanagedbyanHMC(7310-CR3).Whichof thesestatementsistrueandwouldminimizethecost?（）A.AllthemachinescanbeconnectedtotheexistingHMC,aslongasitisupdatedtocodelevel7.7.1or laterB.ThePower770requiresanHMC(7042-CR5orlater),sotheymustbuyone.Allofthesystemscanbe managedbythisnewHMCC.TheyshouldbuyanewHMCforthePower770system,andleavethePOWER5andPOWER6based systemsconnectedtotheexistingoneD.ThePower770requiresanHMC,sotheyshouldconnectthePower770totheHMCandconvertthe POWER5andPOWER6basedserverstoIVM
考题
AnITdirectorneedstodeploy3partitions,eachusingdedicatedinternalbootdisk.Whichsystemwillsupportthecustomerrequirementusingtheleastamountofrackspace?()
A.Power770serversB.Power750serversC.Power755serversD.Power720servers
考题
WhichofthefollowingprovideforhighersystemavailabilityonasingleCECPower770orPower780?()
A.RedundantsystemclockB.RedundantserviceprocessorC.POWER7coresincluderedundantL3cachesD.MainmemoryDIMMscontainanextraDRAMchipforimprovedredundancy
考题
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
考题
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;
考题
A customer wants to migrate their existing compute-intensive POWER6 570 to a Power 770. Which of their existing I/O adapters can be migrated to Power 770 enclosures?（）A、PCIe adaptersB、PCI-X adaptersC、PCI-X andPCIe adaptersD、PCI, PCI-X andPCIe adapters
考题
A customer plans to consolidate several systems onto POWER7. Their immediate requirement is to have a single Power 770, and they will buy a second Power 770 at a later stage. They want to keep their existing three POWER5 570s and three POWER6 520s which are all managed by an HMC (7310-CR3). Which of these statements is true and would minimize the cost?（）A、All the machines can be connected to the existing HMC, as long as it is updated to code level 7.7.1 or laterB、The Power 770 requires an HMC (7042-CR5 or later), so they must buy one. All of the systems can be managed by this new HMCC、They should buy a new HMC for the Power 770 system, and leave the POWER5 and POWER6 based systems connected to the existing oneD、The Power 770 requires an HMC, so they should connect the Power 770 to the HMC and convert the POWER5 and POWER6 based servers to IVM
考题
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.
考题
An IT director needs to deploy 3 partitions， each using dedicated internal boot disk. Which system will support the customer requirement using the least amount of rack space？（）A、Power 770 serversB、Power 750 serversC、Power 755 serversD、Power 720 servers
考题
单选题在Mary的方案中已经存在“客户”表。应使用哪条语句来为所有数据库用户创建一个“客户”表的同义词（）A
CREATE PUBLIC SYNONYM cust ON mary.客户B
CREATE PUBLIC SYNONYM cust FOR mary.客户C
CREATE SYNONYM cust ON mary.客户FORPUBLICD
CREATE 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?（）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;
考题
单选题Which of the following items in a single enclosure Power 770 improves Reliability, Availability, and Serviceability?（）A
Redundant system clocksB
Redundant service processorsC
eDRAM chips have redundant L3 cacheD
Main memory DIMMs contain a redundant DRAM chip
考题
单选题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?（）A
p_where_clause B
:p_where_clause C
WHERE CUST_ID=P_CUST_ID or cust_name=:p_cust_name or cust_phone=:p_cust_phone D
Where cust_ID=p_custid cust_name=p_cust_name or cust_phone=p_cust_phone
考题
单选题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;
考题
单选题Which of the following provide for higher system availability on a single CEC Power 770 or Power 780?（）A
Redundant system clockB
Redundant service processorC
POWER7 cores include redundant L3 cachesD
Main memory DIMMs contain an extra DRAM chip for improved redundancy
考题
单选题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');
考题
多选题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?（）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;
考题
单选题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?（）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?（）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');
热门标签
最新试卷