The acceptance letter must contain the order number and date as well as other information concerning the execution of the order.()

第1题：

第2题：

You want to configure switch R1 to propagate VLAN information across the Company network  using VTP. What must be configured on a Cisco switch in order to advertise VLAN information？（）

• A、VTP mode
• B、VTP password
• C、VTP revision number
• D、VTP pruning
• E、VTP domain name
• F、None of the other alternatives apply

第3题：

The （）is out of order. We must have someone to repair it at once.

• A、stevedore
• B、foreman
• C、derrick
• D、docker

第4题：

Which four are correct guidelines for naming database tables?（）

• A、Must begin with either a number or a letter.
• B、Must be 1-30 characters long.
• C、Should not be an Oracle Server reserved word.
• D、Must contain only A-Z, a-z, 0-+, _, *, and #.
• E、Must contain only A-Z, a-z, 0-9, _, $, and #.
• F、Must begin with a letter.

第5题：

Examine the SQL statements that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL STATUS VARCHARD2(10) CHECK (status IN ('CREDIT','CASH')), PROD_ID_NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order id, order date)); For which columns would an index be automatically created when you execute the aboveSQL statement? （）

• A、SER_NO
• B、ORDER_ID
• C、STATUS
• D、PROD_ID
• E、ORD_TOTAL
• F、Composite index on ORDER_ID and ORDER_DATE

第6题：

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 );

第7题：

Examine the SQL statement that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN ('CREDIT', 'CASH')), PROD_ID NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order_id, order_date)); For which columns would an index be automatically created when you execute the above SQL statement? （）

• A、SER_NO
• B、ORDER_ID
• C、STATUS
• D、PROD_ID
• E、ORD_TOTAL
• F、composite index on ORDER_ID and ORDER_DATE

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Write a memo in about 50 words. You received a letter from a British customer complaining of the late delivery of their Order No.366.Then you looked into the matter and found it was the fault of your dispatch department.Write a short memo to your assistant, Jack Zhou. ·Ask him to visit your dispatch department and urge them to dispatch the order. ·Specify the goods, quality, and the deadline for dispatch. ·Add any relevant information you can think of.
To: Jack Zhou
From:(your name)
Subject: Order No.366
Date: 19 April，2013
I received a letter from a customer in Britain who complained about the late delivery of their Order No.366 for 100 sets of Model DX fax machines.The delay is due to the negligence of our dispatch department.Could you go to the dispatch department and tell them to send
the order before the end of this month? Thanks!
略

第14题：

In the data model you created this query: SELECT ID_no, description, price, quantity, manufacturer_ID FROM inventory Next you click and drag the manufacturer_ID column out of and above the default group. You needed to sort the child group by ID_number. How could you accomplish this task? （）

• A、Add an order by clause to the query. 
• B、In the data model double click the ID_number column and alter the break order. 
• C、In the layout model double click the ID_number filed and later the print direction. 
• D、Default the layout, choose a master/detail report style and select ID_number as the break order.

第15题：

Examine the SQL statement that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN ('CREDIT', 'CASH')), PROD_ID NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order_id, order_date)); For which columns would an index be automatically created when you execute the above SQL statement? （）

• A、SER_NO
• B、ORDER_ID
• C、STATUS
• D、PROD_ID
• E、ORD_TOTAL
• F、composite index on ORDER_ID and ORDER_DATE

第16题：

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);

第17题：

You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing.  What information is captured as part of this process？（）

• A、 the SQL text
• B、 the execution plan
• C、 the execution context
• D、 the execution frequency
• E、 the system change number （SCN）

第18题：

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);

第19题：

You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process?（）

• A、the SQL text SQL
• B、the execution plan
• C、the execution context
• D、the execution frequency
• E、the system change number (SCN)

第20题：

第21题：

第22题：

第23题：