In the video form. the OrderDate field (Which shows When the video may be ordered)is calculated based on the Date field (Which displays the release date ). The order date is 30 days prior to  the release date. Which one the following formulas will calcula

第1题：

第2题：

第3题：

Based on which two conditions can master Preventive Maintenance （PM） schedules be created？（）

• A、 elapsed time since the target start date or completion date of previous work generated by PM  
• B、 difference between completion date of previous work and system date is equal to Lead Time  
• C、 elapsed time since the target start date or completion date of the latest work orders for the asset
• D、 metered equipment usage since the target start date or completion date of previous work generated by PM
• E、 metered equipment usage since the target start date or completion date of the latest work order for the asset

第4题：

When attempting to boot a PC, the POST process completes without error. The PC then displays,‘non system disk or disk error’. Which of the following would MOST likely cause the issue?（）

• A、Out-of-date BIOS
• B、Invalid motherboard jumper settings
• C、Failing power supply
• D、Floppy disk in the drive

第5题：

jim has created a field hint for the address field. Users tell him this text disappears when they click in the address field. which one of the following is most likely reason?（）

• A、 the address field is computed 
• B、 jim should have used a text popup       
• C、 jim stored the field hint in the database    
• D、 field hint only display when the user has not clicked in the field （field hint）

第6题：

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

第7题：

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

第8题：

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

第9题：

第10题：

第11题：

第12题：

第13题：

第14题：

Which of the following require physical CD/DVD media to be ordered and received prior to patching and/or upgrading IPCC Express 4.0?（）

• A、Major Release  
• B、Minor Release  
• C、Maintenance Release  
• D、Service Release  
• E、Engineering Special

第15题：

which one of the following should maria do to display the release date in a text column?（）

• A、used the number and time format options 
• B、used the @date to text functions to convert time to text 
• C、concatenated the date types using mathematical operators 
• D、used the @text functions to convert time and number data to text in text columns 

第16题：

Which of the following local files is used to run the date command on the remote machine "Earth" using the following rexec command without request for a password？ rexec Earth date（）。

• A、~/ .rhosts
• B、$HOME/.netrc
• C、/etc/hosts.equiv
• D、/etc/security/user

第17题：

kristin wants to build an action which exits the video form. the action will be avaiable only when the user is reading the document ,which one of the following accomplish this ? （）

• A、@ command([back])    
• B、@ command([fileexit])   
• C、@ command([gotoview])     
• D、@ command([fileclosewindow])

第18题：

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

第19题：

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

第20题：

第21题：

第22题：

第23题：