A customer is acquiring a new IBM System Storage TS3500 Tape Library and requested to reuse four HP LTO-3 drives installed in a Sun L700 tape library to take advantage of the IBM multipath architecture.<br /> What action should the storage specialist take?（）<p> A customer is acquiring a new IBM System Storage TS3500 Tape Library and requested to reuse four HP LTO-3 drives installed in a Sun L700 tape library to take advantage of the IBM multipath architecture.<br /> What action should the storage specialist take?（）</p>..

第1题

[单选题] How does DB2 protect the integrity of indexes when data is updated?（）

A、Locks are acquired on the data. B、Locks are acquired on index keys. C、Locks are acquired on index pages. D、Locks are acquired on index pointers.

点击查看答案

第2题

[简答题] According to Krashen, there is only one way for human to acquire language. What is it?

点击查看答案

第3题

[单选题] 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;

点击查看答案

第4题

[单选题] 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;

点击查看答案

第5题

[单选题] 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;

点击查看答案

第6题

[单选题] The CUSTOMERS table has these columns: Which statement finds the rows in the CUSTOMERS table that do not have a postal code?（）

A、SELECT customer_id, customer_name FROM customers WHERE postal_code CONTAINS NULL; B、SELECT customer_id, customer_name FROM customers WHERE postal_code = '________'; C、SELECT customer_id, customer_name FROM customers WHERE postal_code IS NULL; D、SELECT customer_id, customer_name FROM customers WHERE postal code IS NVL; E、SELECT customer_id, customer_name FROM customers WHERE postal_code = NULL;

点击查看答案

第7题

[] Which of the following is a typical data warehouse query?（）

A、A.What is this customers address? B、B.Does this customer have any unpaid bills? C、C.What is the balance in this customers account? D、D.What are the total sales for each of the last 6 months?

点击查看答案

第8题

[多选题] The CUSTOMERS table has these columns: The CUSTOMER_ID column is the primary key for the table.Which two statements find the number of customers? （）

A、SELECT TOTAL(*) FROM customers; B、SELECT COUNT(*) FROM customers; C、SELECT TOTAL(customer_id) FROM customers; D、SELECT COUNT(customer_id) FROM customers; E、SELECT COUNT(customers) FROM customers; F、SELECT TOTAL(customer_name) FROM customers;

点击查看答案

第9题

[单选题] The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4) NOT NULL CUSTOMER_NAME VARCHAR2(100) NOT NULL STREET_ADDRESS VARCHAR2(150) CITY_ADDRESS VARCHAR2(50) STATE_ADDRESS VARCHAR2(50) PROVINCE_ADDRESS VARCHAR2(50) COUNTRY_ADDRESS VARCHAR2(50) POSTAL_CODE VARCHAR2(12) CUSTOMER_PHONE VARCHAR2(20) Which statement finds the rows in the CUSTOMERS table that do not have a postal code?（）

A、SELECT customer_id, customer_name FROM customers WHERE postal_code CONTAINS NULL; B、SELECT customer_id, customer_name FROM customers WHER postal_code = ' ___________'; C、SELECT customer_id, customer_name FROM customers WHERE postal _ code IS NULL; D、SELECT customer_id, customer_name FROM customers WHERE postal code IS NVL; E、SELECT customer_id, customer_name FROM customers WHERE postal_code = NULL;

点击查看答案

第10题

[单选题] The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4) NOT NULL CUSTOMER_NAME VARCHAR2(100) NOT NULL STREET_ADDRESS VARCHAR2(150) CITY_ADDRESS VARCHAR2(50) STATE_ADDRESS VARCHAR2(50) PROVINCE_ADDRESS VARCHAR2(50) COUNTRY_ADDRESS VARCHAR2(50) POSTAL_CODE VARCHAR2(12) CUSTOMER_PHONE VARCHAR2(20) Which statement finds the rows in the CUSTOMERS table that do not have a postal code? （）

A、SELECT customer_id, customer_name FROM customers WHERE postal_code CONTAINS NULL; B、SELECT customer_id, customer_name FROM customers WHER postal_code = ' ___________'; C、SELECT customer_id, customer_name FROM customers WHERE postal _ code IS NULL; D、SELECT customer_id, customer_name FROM customers WHERE postal code IS NVL; E、SELECT customer_id, customer_name FROM customers WHERE postal_code = NULL;

点击查看答案

请使用微信扫码支付