[单项选择] You have a very large table that your users access frequently.  Which of the following advisors will recommend any indexes to improve the performance of queries against this table？（）  
A.  The Automatic Memory Manager （AMM）
B.  The SQL Tuning Advisor
C.  The Segment Advisor
D.  The SQL Access Advisor

[单项选择]在下列查询语句中，与SELECT TAB1．* FROM TAB1 WHERE InStr([简历]，"篮球")<>0 功能相同的语句是
A. SELECT TAB1．* FROM TAB1 WHERE TAB1．简历Like "篮球"
B. SELECT TAB1．* FROM TAB1 WHERE TAB1．简历Like "*篮球"
C. SELECT TAB1．* FROM TAB1 WHERE TAB1．简历Like "*篮球*"
D. SELECT TAB1．* FROM TAB1 WHERE TAB1．简历Like "篮球*"

[单项选择]若定义TAB DW 1，2，3，4，执行MOV AX，TAB[2]指令后，AX寄存器中的数据是 ( )。
A. 0200H
B. 0002H
C. 0403H
D. 3

[单项选择]为窗体上的控件设置“Tab”键顺序时，应设置控件属性表的哪一项标签的“Tab键次序”选项( )。
A. 格式
B. 数据
C. 事件
D. 其他

[多项选择] 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

[多项选择]Which two statements are correct about routing tables in JUNOS?（）
A. There are separate tables for IPv4 and IPv6 called inet.0 and inet6.0 respectively.
B. They only contain the best possible route to each destination.
C. All running protocols can populate the routing tables at the same time.
D. Routes with the highest preference value are placed as active routes in the routing table.

[单项选择] Examine the data from the ORDERS and CUSTOMERS tables. ORDERS ORD_ID ORD_DATE CUST_ID 12-JAN- 100 15 10000 09-MAR- 101 40 8000 09-MAR- 102 35 12500 15-MAR- 103 15 12000 25-JUN- 104 15 6000 18-JUL- 105 20 5000 106 18-JUL- 35 7000 21-JUL- 107 20 6500 04-AUG- 109 10 8000 CUSTOMERS CUST_ID CUST_NAME CITY 10 Smith Los Angeles 15 Bob San Francisco 20 Martin Chicago 25 Mary New York 30 Rina Chicago 35 Smith New York 40 Lind New York Evaluate the SQL statement: SELECT * FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = 'Smith'); What is the result when the query is executed?（）
A. ORD_ID ORD_DATE CUST_ID ORD_TOTAL 09-MAR- 102 35 12500 18-JUL- 106 35 7000 04-AUG- 108 10 8000
B. ORD_ID ORD_DATE CUST_ID ORD_TOTAL 09-MAR- 102 35 12500 18-JUL- 106 35 7000
C. ORD_ID ORD_DATE CUST_ID ORD_TOTAL 04-AUG- 108 10 8000
D. The query fails because the subquery returns more than one row.
E. The query fails because the outer query and the inner query are using different tables.

[单项选择]The following triggers were defined for table TAB1 in the order shown:CREATE TRIGGER trig_a AFTER UPDATE ON tab1 FOR EACH ROW UPDATE sale_tab SET sale_date = CURRENT DATE; CREATE TRIGGER trig_b AFTER UPDATE ON tab1 FOR EACH STATEMENT UPDATE invoice_tab SET invoice_date = CURRENT DATE; CREATE TRIGGER trig_c AFTER UPDATE ON tab1 FOR EACH ROW UPDATE shipping_tab SET ship_date = CURRENT DATE; CREATE TRIGGER trig_d AFTER UPDATE ON tab1 FOR EACH STATEMENT UPDATE billing_tab SETbilling_date = CURRENT DATE;If an event occurs that causes all of them to activate, which trigger will be activated first?（）
A. TRIG_A
B. TRIG_B
C. TRIG_C
D. TRIG_D

[单项选择] Given the following statements: CREATE TABLE tab1 (col1 INT); CREATE TABLE tab2 (col1 INT); CREATE TRIGGER trig1 AFTER UPDATE ON tab1 REFERENCING NEW AS new1 FOR EACH ROW MODE DB2SQL INSERT INTO tab2 VALUES(new1.col1); INSERT INTO tab1 VALUES(2),(3); What is the result of the following query? SELECT count(*) FROM tab2;（）
A. 3
B. 2
C. 1
D. 0

[单项选择]To my great surprise the food was still on the table, ______. ( )
A. not to be touched
B. untouched
C. untouching
D. no touch

[单项选择]Customer: Would it be possible to move to that table in the shadeWaiter: ______, madam, but I'll see what I can do.

[单项选择]微型计算机键盘上的Tab键是( )。
A. 退格键
B. 控制键
C. 交替换档键
D. 制表定位键

[单项选择]微型计算机键盘上的Tab键称为( )。
A. 退格键
B. 控制键
C. 换档键
D. 制表键

[单项选择] Examine the data in the EMPLOYEES and EMP_HIST tables: EMPLOYEES NAME DEPT_ID MGR_ID JOB_ID SALARY EMPLOYEE_ID 101 Smith 20 120 SA_REP 4000 102 Martin 10 105 CLERK 2500 103 Chris 20 120 IT_ADMIN 4200 104 John 30 108 HR_CLERK 2500 105 Diana 30 108 IT_ADMIN 5000 106 Smith 40 110 AD_ASST 3000 108 Jennifer 30 110 HR_DIR 6500 110 Bob 40 EX_DIR 8000 120 Ravi 20 110 SA_DIR 6500 EMP HIST EMPLOYEE_ID NAME JOB_ID SALARY 101 Smith SA_CLERK 2000 103 Chris IT_CLERK 2200 104 John HR_CLERK 2000 106 Smith AD_ASST 3000 108 Jennifer HR_MGR 4500 The EMP_HIST table is updated at the end of every year. The employee ID, name, job ID, and salary of each existing employee are modified with the latest data. New employee details are added to the table. Which statement accomplishes this task?（）
A. UPDATE emp_hist SET employee_id, name, job_id, salary = (SELECT employee_id, name, job_id, salary FROM employees) WHERE employee_id IN (SELECT employee_id FROM employees);
B. MERGE INTO emp_hist eh USING employees e ON (eh.employee_id = e.employee_id) WHEN MATCHED THEN UPDATE SET eh.name = e.name, eh.job_id = e.job_id, eh.salary = e.salary WHEN NOT MATCHED THEN INSERT VALUES (e.employee id, e.name, job id, e.salary);
C. MERGE INTO emp_hist eh USING employees e ON (eh.employee_id = e.employee_id) WHEN MATCHED THEN UPDATE emp hist SET eh.name = e.name, eh.job_id = e.job_id, eh.salary = e.salary WHEN NOT MATCHED THEN INSERT INTO emp_hist VALUES (e.employees_id, e.name, e.job_id, e.salary);
D. MERGE INTO emp_hist eh USING employees e WHEN MATCHED THEN UPDATE emp_hist SET eh.name = e.name, eh.job_id = e.job_id, eh.salary = e.salary WHEN NOT MATCHED THEN INSERT INTO emp_hist VALUES (e.employees_id, e.name, e.job_id, e.salary);

[判断题]出现“Resuming from disk，Press TAB to show POST screen”，某些主板的BIOS提供了Suspend to disk（挂起到硬盘）的功能，当使用者以Suspend to disk的方式来关机时，那么在下次开机时就会显示此提示消息。（）

[单项选择]Which J-Web tab do you use to add licenses to the device?（）
A. "Configure"
B. "Troubleshoot"
C. "Monitor"
D. "Maintain"