A customer is considering the purchase of an XIV system to leverage thin provisioning. They are concerned that their application will use all available space during formatting, which will remove any thin provisioning benefits.<br /> What should the storage specialist discuss with the customer?（）..

第1题

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

点击查看答案

第2题

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

点击查看答案

第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题

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

点击查看答案

第5题

[] 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?

点击查看答案

第6题

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

点击查看答案

第7题

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

点击查看答案

第8题

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

点击查看答案

第9题

[单选题] When dealing with customers on the phone that are not very comfortable with technology, which of the following techniques would be MOST helpful to ensure that effective communication is taking place?（）

A、Frequently paraphrase what the caller is saying. B、Repeat what is being said multiple times so that the customer can understand exactly what to do. C、Speak very slowly when replying to the customer. D、Tell the customer to send an email stating exactly what the problem is so that the communication between the two parties is clear.

点击查看答案

第10题

[单选题] A customer with an EMC Clariion CX700 storage installation is considering a new IBM TotalStorage DS4500 solution. Which of the following is an advantage of the IBM DS4500 solution？（）

A、Host port speed of 2Gb/s B、Three-year hardware warranty C、Heterogeneous Operating System support D、Storage Manager software comes standard with DS4000 controllers

点击查看答案

请使用微信扫码支付