单选题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 

第1题：

The most important customer a technician has is:（）

• A、the customer standing right in front of them.
• B、the customer who owes the company the most money.
• C、the customer calling on the phone.
• D、the customer they have an appointment with in an hour.

第2题：

评估以下CREATETABLE语句的执行结果： CREATET ABLE customers （customer_id NUMBER，customer_name VARCHAR2（25）， address VARCHAR 2（25）， city VARCHAR 2（25）， region VARCHAR 2（25）， postal_code VARCHAR 2（11）， CONSTRAINT customer_id_un UNIQUE（customer_id）， CONSTRAINTcustomer_name_nnNOTNULL（customer_name））； 为什么执行时此语句会失败（）

• A、NUMBER数据类型要求精度值
• B、UNIQUE约束条件必须在列级定义
• C、CREATETABLE语句不定义PRIMARYKEY
• D、不能在表级定义NOTNULL约束条件

第3题：

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) The CUSTOMER_ID column is the primary key for the table. Which two statements find the number of customers? （）

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

第4题：

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;

第5题：

You need to create a table named ORDERS that contains four columns: 1.an ORDER_ID column of number data type 2.a CUSTOMER_ID column of number data type 3.an ORDER_STATUS column that contains a character data type 4.a DATE_ORDERED column to contain the date the order was placed When a row is inserted into the table, if no value is provided for the status of the order, the value PENDING should be used instead. Which statement accomplishes this?（）

• A、CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status NUMBER(10) DEFAULT 'PENDING', date_ordered DATE );
• B、CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) = 'PENDING', date_ordered DATE );
• C、CREATE OR REPLACE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered DATE );
• D、CREATE OR REPLACE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) = 'PENDING', date_ordered DATE );
• E、CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered DATE );
• F、CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered VARCHAR2 );

第6题：

You are developing a Windows Forms application that contains a DataGridView control. The DataGridView capture the customer's name, address, and phone number. You have been asked to provide data validation in a DataGridView to prevent users from leaving the.. You need to ensure that users cannot tab out of the name field without entering data What should you do ?（）

• A、 Validate the name field in the CellValidating event. Set e.Cancel = true if the name field is
• B、 Validate the name field in the CellErrorTextChanged event. Get e.RowIndex if the name field ..
• C、 Validate the name field in the CellEnter event. Set the focus on the name field if the name ...
• D、 Validate the name field in the CancelRowEdit event. Set the focus on the name field if the name ...

第7题：

You need to design a hosting service option for customers who want to access their databases by using their own Active Directory domain accounts. What should you do？（）

• A、Design a hosting service option that duplicates each customer’s domain user account as SQL Serverlogin account.
• B、Design a hosting service option that provides VPN-based connectivity from each customer’s network tothe SQL Server computer that hosts that customer’s daabase or databases.
• C、Design a hosting service option that provides a dedicated server to each customer.Join that server to that customer’s Active Directory domain
• D、Design a hosting service option that configures a unique instance of SQL Server 2005 for each customer.Configure that instance to use Integrated Windows authentication.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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

第14题：

What information, in addition to model number and serial number, is necessary to perform featureactivation for the IBM System Storage DS8000?（）

• A、Machine signature
• B、Customer number
• C、Site location
• D、Customer contact number

第15题：

Which statement accomplish this? （）

• A、CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);
• B、CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);
• C、CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);
• D、CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);
• E、CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);
• F、CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE DEFAULT SYSDATE);

第16题：

You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform?（）

• A、MERGE
• B、INSERT
• C、UPDATE
• D、ADD
• E、ENTER
• F、You cannot enter the phone numbers for the existing employee records.

第17题：

You need to create a table named ORDERS that contain four columns: 1. an ORDER_ID column of number data type 2. aCUSTOMER_ID column of number data type 3. an ORDER_STATUS column that contains a character data type 4. aDATE_ORDERED column to contain the date the order was placed. When a row is inserted into the table, if no value is provided when the order was placed, today's date should be used instead. Which statement accomplishes this?（）

• A、CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);
• B、CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);
• C、CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);
• D、CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);
• E、CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);
• F、CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE DEFAULT SYSDATE);

第18题：

You need to design an access control strategy for the Contact Info and the Order History folders. What should you do？（）

• A、Create a domain local group named Customer Relations in the northwindtraders.com domain. Add the Sales group and the Sales Managers groups to the Customer Relations group. Add the Customer Relationships group to the Customer Information folder. Assign the appropriate permissions. Add the accounts for the sales department users in Boston to the Boston Customer Relationship group. Add the Boston Customer Relationships group to the Customer Relations group. Disable inheritance on the Payment folder
• B、Create a domain local group named Customer Relations in the boston.northwindtraders.com domain. Add the Customer Relations group to the Customer Information folder. Assign the appropriate permissions. Add the Boston Customer Relations group to the Customer Relations group. Disable permission inheritance on the Payment folder
• C、Create a domain local group named Customer Relations in the boston.northwindtraders.com domain. Add the Customer Relations group to the Order History folder. Assign the appropriate permissions. Add the Boston Customer Relations group to the Customer Relations group. Disable permission inheritance on the Payment folder
• D、Create a domain local group named Customer Relations in the boston.northwindtraders.com domain. Add the Customer Relations group to the Customer Information folder. Assign the appropriate permissions. Add the Boston Customer Relations group to the Customer **MISSING**

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：