A dynamically learned MAC address is saved in the startup-configuration file.
A dynamically learned MAC address is saved in the running-configuration file.
A dynamically learned MAC address is saved in the VLAN database.
Statically configured MAC addresses are saved in the startup-configuration file if frames from that address are received.
Statically configured MAC addresses are saved in the running-configuration file if frames from that address are received.
第1题：
The PRODUCTS table has these columns:PRODUCT_ID NUMBER(4)PRODUCT_NAME VARCHAR2(45)PRICE NUMBER(8,2)Evaluate this SQL statement:SELECT *FROM PRODUCTSORDER BY price, product _ name;What is true about the SQL statement? （）
A. The results are not sorted.
B. The results are sorted numerically.
C. The results are sorted alphabetically.
D. The results are sorted numerically and then alphabetically.
第2题：
A. From the Advisor Central home page, select the tuning task from the Advisor Tasks section.
B. From Advisor Central, choose SQL Advisors, SQL Tuning Advisors, Manual Tuning Task Results.
C. From Advisor Central, choose SQL Advisors, Manual SQL Tuning Advisors, Tuning Task Results.
D. Either B or C
第3题：
Your network contains a server named Server1 that runs Windows Server 2008 R2.You need to ensure that an administrator is notified by e-mail if the Event Viewer logs any error.What should you do from the Event Viewer console?（）
A. Create a custom view, and then click the Filter Current Custom View action.
B. Create a custom view, and then click the Attach Task to This Custom View action.
C. From the System log, click the Filter Current Log action.
D. From the System log, select an Error event, and then click the Attach Task to This Event action.
第4题：
与“SELECT*FROM教师表INTO DBF A”等价的语句是
A．SELECT*FROM教师表TO DBF A
B．SELECT*FROM教师表TO TABLE A
C．SELECT*FROM教师表INTO TABLE A
D．SELECT*FROM教师表INTO A
第5题：
The EMP table has these columns:ENAME VARCHAR2(35)SALARY NUMBER(8,2)HIRE_DATE DATEManagement wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? （）
A. SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE >5;
B. SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE >5;
C. SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 >5;
D. SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 >5;
第6题：
Evaluate this SQL statement:SELECT ename, sal, 12* sal+100 FROM emp;The SAL column stores the monthly salary of the employee. Which change must be made to the abovesyntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"? （）
A. No change is required to achieve the desired results.
B. SELECT ename, sal, 12* (sal+100) FROM emp;
C. SELECT ename, sal, (12* sal)+100 FROM emp;
D. SELECT ename, sal +100,*12 FROM emp;
第7题：
A. /SQL*Plus commands cannot be abbreviated.
B. /SQL*Plus commands are accesses from a browser.
C. /SQL*Plus commands are used to manipulate data in tables.
D. /SQL*Plus commands manipulate table definitions in the database.
E. /SQL*Plus is the Oracle proprietary interface for executing SQL statements.
第8题：
You have configured a Ezonexam switch as shown below:
Ezonexam3(config-if) switchport port-security
Ezonexam3(config-if) switchport port-security mac-address sticky
Select the action below that results from executing these commands.
A. A dynamically learned MAC address is saved in the VLAN database.
B. A dynamically learned MAC address is saved in the startup-configuration file.
C. Statically configured MAC addresses are saved in the startup-configuration file if frames from that address are received.
D. A dynamically learned MAC address is saved in the running-configuration file.
E. Statically configured MAC addresses are saved in the running-configuration file if frames from that address are received.
F. None of the above
第9题：
The EMP table contains these columns:LAST NAME VARCHAR2(25)SALARY NUMBER(6,2)DEPARTMENT_ID NUMBER(6)You need to display the employees who have not been assigned to any department. You write the SELECT statement:SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMPWHERE DEPARMENT_ID = NULL;What is true about this SQL statement? （）
A. The SQL statement displays the desired results.
B. The column in the WHERE clause should be changed to display the desired results.
C. The operator in the WHERE clause should be changed to display the desired results.
D. The WHERE clause should be changed to use an outer join to display the desired results.
第10题：
（ 30 ）与 “ SELECT * FROM 教师表 INTO DBF A ” 等价的语句是
A ） SELECT * FROM 教师表 TO DBF A
B ） SELECT * FROM 教师表 TO TABLE A
C ） SELECT * FROM 教师表 INTO TABLE A
D ） SELECT * FROM 教师表 INTO A
