220-702
单选题A technician wants to prevent employees from installing software on company computers. In which of the following groups should the employee accounts be placed?（）rsA Power UsersB UsersC GuestsD Administrato
题目
Power Users
Users
Guests
Administrato
相似问题和答案
第1题：
A. SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department _ id);
B. SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);
C. SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);
D. SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);
E. SELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);
F. SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));
第2题：
A. Event Viewer
B. System File Checker
C. MSCONFIG
D. Task Manager
第3题：
A. SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department _ id);
B. SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);
C. SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);
D. SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);
E. SELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);
F. SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));
第4题：
A technician purchases a new 120 GB IDE hard disk to use in an old server as a swap drive. After adding the drive to the server， the technician discovers that the operating system does not detect the drive. After rebooting the server， the technician notices the drive is missing from POST and comes to the conclusion that the BIOS needs to be updated. The technician downloads the latest version of the BIOS update from the manufacturer website. Which action should the technician take next？（）
- A、 backup the BIOS configuration to use later
- B、 install the BIOS update from a command prompt
- C、 create a bootable floppy and copy the BIOS update tools to the floppy
- D、 read the manufacturer’s guidelines and recommendations on installing the update
正确答案:D
第5题：
A technician wants to prevent employees from installing software on company computers. In which of the following groups should the employee accounts be placed?（）rs
- A、Power Users
- B、Users
- C、Guests
- D、Administrato
正确答案:B
第6题：
A.SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id);
B.SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);
C.SELECT distinct department_id FROM employees WHERE salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);
D.SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);
E.SELECT last_name FROM employees WHERE salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department_id);
F.SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));
第7题：
An administrator is setting up a network and would like to prevent users from having the ability toplug their PC into the network to receive an IP address.Which of the following addressing schemes should the technician use?（）
A.NAT
B.Dynamic
C.Subnetting
D.Static
第8题：
Observe the structure of the table employees:The table contains 8475 records.One of the employees wants to know the names of all employees of the company. For this, he fires the following query:SELECT * FROM EMPLOYEES ORDER BY emp_fname;Since the operation performed on executing the query cannot fit into memory, it requires disk space to complete the operation.Which of the following types of segments will Oracle allocate to complete the operation and to provide the required result?（）
A. Rollback segment
B. Temporary segment
C. Data segment
D. Index segment
第9题：
下面哪条语句可以取出薪水最高的前三个人：（）
- A、SELECT * FROM （SELECT * FROM EMPLOYEES ORDER BY SALARY ）；
- B、SELECT * FROM （SELECT * FROM EMPLOYEES ORDER BY SALARY ） WHERE ROWNUM<=3；
- C、SELECT * FROM （SELECT * FROM EMPLOYEES ORDER BY SALARY DESC） WHERE ROWNUM<=3；
- D、SELECT * FROM EMPLOYEES WHERE ROWNUM<=3 ORDER BY SALARY DESC；
正确答案:C
第10题：
A network administrator wants to control which user hosts can access the network based on their MAC address. What will prevent workstations with unauthorized MAC addresses from connecting to the network through a switch?（）
- A、BPDU
- B、Port security
- C、RSTP
- D、STP
- E、VTP
- F、Blocking mode
正确答案:B