20. Among employees __________, the support for the change is zero. A. at length B. at last C. at large D. at best

题目

相似考题

1.A program can best be described as:AA grouping of related activities which last two years or moreBThe first major subdivision of a projectCA grouping of projects, similar in nature, which support a product or product line and have no definable end pointDA product lineEAnother name for a project

2.Examine the structure of the EMPLOYEES table:Column name Data type RemarksEMPLOYEE_ID NUMBER NOT NULL, Primary KeyLAST_NAME VARCNAR2(30)FIRST_NAME VARCNAR2(30)JOB_ID NUMBERSAL NUMBERMGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBERYou need to create an index called NAME_IDX on the first name and last name fields of the EMPLOYEES table. Which SQL statement would you use to perform this task? （）A. CREATE INDEX NAME _IDX (first_name, last_name);B. CREATE INDEX NAME _IDX (first_name, AND last_name)C. CREATE INDEX NAME_IDX ON (First_name, last_name);D. CREATE INDEX NAME_IDX ON employees (First_name, AND last_name);E. CREATE INDEX NAME_IDX ON employees (First_name, last_name);F. CREATE INDEX NAME_IDX FOR employees (First_name, last_name);

3.Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2(25)LAST_NAME VARCHAR2(25)DEPARTMENT_ID NUMBERSALARY NUMBERWhat is the correct syntax for an inline view? （）A. SELECT a.last_name, a.salary, a.department_id, b.maxsal FROM employees a, (SELECT department_id, max(salary)maxsal FROM employees GROUP BY department_id) b WHERE a.department_id = b.department_id AND a.salary < b.maxsal;B. SELECT a.last name, a.salary, a.department_id FROM employees a WHERE a.department_id IN (SELECT department_id FROM employees b GROUP BY department_id having salary = (SELECT max(salary) from employees))C. SELECT a.last_name, a.salary, a.department_id FROM employees a WHERE a.salary = (SELECT max(salary) FROM employees b WHERE a.department _ id = b.department _ id);D. SELECT a.last_name, a.salary, a.department_id FROM employees a WHERE (a.department_id, a.salary) IN (SELECT department_id, a.salary) IN (SELECT department_id max(salary) FROM employees b GROUP BY department_id ORDER BY department _ id);

4.149 A program can best be described as:A. A grouping of related activities which last two years or moreB. The first major subdivision of a projectC. A grouping of projects, similar in nature, which support a product or product line and have no definable end pointD. A product lineE. Another name for a project

更多“20. Among employees __________, the support for the change is zero. A. at length B. at last C. at large D. at best”相关问题

第1题：

The EMPLOYEE tables has these columns:LAST_NAME VARCHAR2(35)SALARY NUMBER(8,2)COMMISSION_PCT NUMBER(5,2)You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, a zero must be displayed against the calculated column.Which SQL statement displays the desired results? （）
A. SELECT last_name, (salary * 12) * commission_pct FROM EMPLOYEES;
B. SELECT last_name, (salary * 12) * IFNULL(commission_pct, 0) FROM EMPLOYEES;
C. SELECT last_name, (salary * 12) * NVL2(commission_pct, 0) FROM EMPLOYEES;
D. SELECT last_name, (salary * 12) * NVL(commission_pct, 0) FROM EMPLOYEES;

参考答案：D
第2题：

Examine the data in the EMPLOYEES table:Which three subqueries work? ()

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

参考答案：C, D, E
第3题：

Examine the structure of the EMPLOYEES and DEPARTMENTS tables:EMPLOYEESEMPLOYEE_ID NUMBERDEPARTMENT_ID NUMBERMANAGER_ID NUMBERLAST_NAME VARCHAR2(25)DEPARTMENTSDEPARTMENT_ID NUMBERMANAGER_ID NUMBERDEPARTMENT_NAME VARCHAR2(35)LOCATION_ID NUMBERYou want to create a report displaying employee last names, department names, and locations. Which query should you use to create an equi-join?（）
A. SELECT last_name, department_name, location_id FROM employees , department ;
B. SELECT employees.last_name, departments.department_name, departments.location_id FROM employees e, departments D WHERE e.department_id = d.department_id;
C. SELECT e.last_name, d.department_name, d.location_id FROM employees e, departments D WHERE manager_id = manager_id;
D. SELECT e.last_name, d.department_name, d.location_id FROM employees e, departments D WHERE e.department_id = d.department_id;

参考答案：D
第4题：

Examine the data in the EMPLOYEES table:LAST_NAME DEPARTMENT_ID SALARYGetz 10 3000Davis 20 1500Bill 20 2200Davis 30 5000...Which three subqueries work? ()

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

参考答案：C, D, E
第5题：

Which of the following is the BEST support channel for server software and hardware?()

A. Online troubleshooting tools
B. Service Level Agreement (SLA)
C. Vendor website
D. Support forums

参考答案：C
第6题：

_______________
A. work B. last C. exist D. change

正确答案：C
第7题：

Yesterday the officers voted _____to offer large bonuses to high-performing employees.

A. commonly
B. increasingly
C. critically
D. unanimously

答案：D
解析：
第8题：

您要对EMPLOYEES表的FIRST_NAME和LAST_NAME列创建一个组合索引。以下哪条语句将完成此任务（）
- A、CREATE INDEXfl_idx ON employees（first_name last_name）
- B、CREATE INDEXfl_idx ON employees（first_name），employees（last_name）
- C、CREATE INDEXfl_idx ON employees（first_name，last_name）
- D、CREATE INDEXfl_idx ON employees（first_name）；CREATE INDEXfl_idx ON employees（last_name）
正确答案:C
第9题：

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements inserts a row into the table? （）
- A、INSERT INTO employees VALUES (NULL, 'JOHN','Smith');
- B、INSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith');
- C、INSERT INTO employees VALUES ('1000','JOHN','NULL');
- D、INSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith');
- E、INSERT INTO employees (employee_id) VALUES (1000);
- F、INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',");
正确答案:C,E,F
第10题：

Which three statements inserts a row into the table?（）
- A、INSERT INTO employees VALUES ( NULL, ‘John’,‘Smith’);
- B、INSERT INTO employees( first_name, last_name) VALUES(‘John’,‘Smith’);
- C、INSERT INTO employees VALUES (‘1000’,‘John’,NULL);
- D、INSERT INTO employees(first_name,last_name, employee_id) VALUES ( 1000, ‘John’,‘Smith’);
- E、INSERT INTO employees (employee_id) VALUES (1000);
- F、INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, ‘John’,‘’);
正确答案:C,E,F
第11题：

The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMBER(4) ENAME VARCHAR2 (25) JOB_ID VARCHAR2(10) Which SQL statement will return the ENAME, length of the ENAME, and the numeric position of the letter "a" in the ENAME column, for those employees whose ENAME ends with a the letter "n"?（）
- A、SELECT ENAME, LENGTH(ENAME), INSTR(ENAME, 'a') FROM EMPLOYEES WHERE SUBSTR (ENAME, -1,1) = 'n';
- B、SELECT ENAME, LENGTH(ENAME), INSTR(ENAME, ,-1,1) FROM EMPLOYEES WHERE SUBSTR (ENAME, -1,1) = 'n';
- C、SELECT ENAME, LENGTH(ENAME), SUBSTR(ENAME, -1,1) FROM EMPLOYEES WHERE INSTR (ENAME, 1,1) = 'n';
- D、SELECT ENAME, LENGTH(ENAME), SUBSTR(ENAME, -1,1) FROM EMPLOYEES WHERE INSTR (ENAME, -1,1) = 'n';
正确答案:A
第12题：

单选题
The Testking network is implementing dialup services for their remote employees.Testking uses several different Layer 3 protocols on the network. Authentication ofthe users connecting to the network is required for security. Additionally, some employees will be dialing long distance and will need callback support.Which protocol is the best choice for these remote access services?（）
A
802.1
B
Framerelay
C
HDLC
D
PPP
E
SLIP
F
PAP

正确答案： C
解析：暂无解析
第13题：

Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns:LAST NAME VARCNAR2(35) NOT NULLSALARY NUMBER(9,2) NOT NULLCOMMISION_PCT NUMBER(4,2)Which statement ensures that a value is displayed in the calculated columns for all employees? （）
A. SELECT last_name, 12*salary* commission_pct FROM emp;
B. SELECT last_name, 12*salary* (commission_pct,0) FROM emp;
C. SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;
D. SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;

参考答案：C
第14题：

ExhibitExamine the data in the EMPLOYEES and DEPARTMENTS tables.You want to retrieve all employees‘ last names, along with their manager‘s last names and their department names. Which query would you use?（）
A. SELECT last_name, manager_id, department_name FROM employees e FULL OUTER JOIN department d ON (e.department_id = d.department_id);
B. SELECT e.last_name, m.last_name, department_name FROM employees e LEFT OUTER JOIN employees m on ( e.managaer_id = m.employee_id) LEFT OUTER JOIN department d ON (e.department_id = d.department_id);
C. SELECT e.last_name, m.last_name, department_name FROM employees e RIGT OUTER JOIN employees m on ( e.manager_id = m.employee_id) FULL OUTER JOIN department d ON (e.department_id = d.department_id);
D. SELECT e.last_name, m.last_name, department_name FROM employees e LEFT OUTER JOIN employees m on ( e.manager_id = m.employee_id) RIGT OUTER JOIN department d ON (e.department_id = d.department_id);
E. SELECT e.last_name, m.last_name, department_name FROM employees e RIGHT OUTER JOIN employees m on ( e.manager_id = m.employee_id) RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id)
F. SELECT last_name, manager_id, department_name FROM employees e JOIN department d ON (e.department_id = d.department_id);

参考答案：B
第15题：

The EMPLOYEES table contains these columns:EMPLOYEE_ID NUMBER(4)LAST_NAME VARCHAR2 (25)JOB_ID VARCHAR2(10)You want to search for strings that contain ‘SA_‘ in the JOB_ID column. Which SQL statement do you use?（）
A. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE ‘%SA\_%‘ESCAPE‘\‘;
B. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE ‘%SA_‘;
C. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE ‘%SA_‘ESCAPE‘\‘;
D. SELECT employee_id, last_name, job_id FROM employees WHERE job_id ‘%SA_‘;

参考答案：A
第16题：

Examine the data in the EMPLOYEES and DEPARTMENTS tables.EMPLOYEESLAST_NAME DEPARTMENT_ID SALARYGetz 10 3000Davis 20 1500Bill 20 2200Davis 30 5000Kochhar 5000DEPARTMENTSDEPARTMENT_ID DEPARTMENT_NAME10 Sales20 Marketing30 Accounts40 AdministrationYou want to retrieve all employees, whether or not they have matching departments in the departments table.Which query would you use?（）
A. SELECT last_name, department_name FROM employees , departments(+);
B. SELECT last_name, department_name FROM employees JOIN departments(+);
C. SELECT last_name, department_name ON (e. department_ id = d. departments_id); FROM employees(+) e JOIN departments d
D. SELECT last_name, department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);
E. SELECT last_name, department_name FROM employees(+) , departments ON (e. department _ id = d. department _id);
F. SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e. department _ id = d. department _id);

参考答案：F
第17题：

The Testking network is implementing dialup services for their remote employees.Testking uses several different Layer 3 protocols on the network. Authentication ofthe users connecting to the network is required for security. Additionally, some employees will be dialing long distance and will need callback support.Which protocol is the best choice for these remote access services?（）
A.802.1
B.Framerelay
C.HDLC
D.PPP
E.SLIP
F.PAP

参考答案：D
第18题：

In the last but one paragraph，the writer indicates that the“white-haired boy”________．
A．is loved by all people
B．is not very popular among ordinary people
C．is easy to get along with
D．is too hard on the employees

正确答案：B
这段文字说出了普通人对得宠者的忿忿不平的心情。
第19题：

阅读下述摘要，请简要分析该研究的基本问题、研究思路、主要研究结论以及研究意义。

Title: Perceived Supervisor Support: Contributions to Perceived OrganizationalSupport and Employee Retention Authors: Esenberger, Robert; et al. Journal of Applied Psychology, 2002. Abstract: three studies investigated the relationships among employees' perception of supervisor support( PSS), perceived organizational support( POS),and employee turn over. Study l found,with 314 employees drawn from a variety of organizations, that PSS was positively related to temporal change in POS, suggesting that PSS leads to POS. Study 2 established, with 300 retail sales employees, that the PSS - POS relationship increased with perceived supervisor status in the organization. Study 3found, with 493 retail sales employees, evidence consistent with the view that POS completely mediated a negative relationship between PSS and employee turnover. These studies suggest that supervisors to the extent that they are identified with the organization, contribute to POS and, ultimately, to job retention.

答案：
解析：
研究的基本问题：员工知觉到的上级支持对员工知觉到的组织支持和员工存留的影响。研究思路：本研究用逐层递进的三个子研究证明了上级支持、组织支持和员工存留之间的关系；第一个研究是实验研究，第二个研究是相关研究，第三个仍然是相关研究，但做出了一个中介效应，进一步理清了三者之间的关系。主要研究结论：上级支持的感知直接影响组织支持的感知；随着上级地位的提高，上级支持和组织支持之间关系变得更加紧密；上级支持影响了组织支持，最终影响了员工离职意愿，上级支持和离职意愿呈现负相关。研究意义：该研究用实验方法论证了上级支持和组织支持之间的因果关系，明确了上级支持对于员工去留的影响；为进一步研究组织内部各种因素之间的关系指出了一条更加清晰的思路和方法。
第20题：

Examine the data in the EMPLOYEES and DEPARTMENTS tables. EMPLOYEES LAST_NAME DEPARTMENT_ID SALARY Getz 10 3000 Davis 20 1500 Bill 20 2200 Davis 30 5000 Kochhar 5000 DEPARTMENTS DEPARTMENT_ID DEPARTMENT_NAME 10 Sales 20 Marketing 30 Accounts 40 Administration You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use?（）
- A、SELECT last_name, department_name FROM employees , departments(+);
- B、SELECT last_name, department_name FROM employees JOIN departments(+);
- C、SELECT last_name, department_name ON (e. department_ id = d. departments_id); FROM employees(+) e JOIN departments d
- D、SELECT last_name, department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);
- E、SELECT last_name, department_name FROM employees(+) , departments ON (e. department _ id = d. department _id);
- F、SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e. department _ id = d. department _id);
正确答案:F
第21题：

Click the Exhibit button and examine the data in the EMPLOYEES and DEPARTMENTS tables.You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use?（）
- A、SELECT last_name, department_name FROM employees NATURAL JOIN departments;
- B、SELECT last_name, department_name FROM employees JOIN departments ;
- C、SELECT last_name, department_name FROM employees e JOIN departments d ON (e.department_id = d.department_id);
- D、SELECT last_name, department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);
- E、SELECT last_name, department_name FROM employees FULL JOIN departments ON (e.department_id = d.department_id);
- F、SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e.department_id = d.department_id);
正确答案:F
第22题：

Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) Which statement produces the number of different departments that have employees with last name Smith?（）
- A、SELECT COUNT(*) FROM employees WHERE last_name='Smith';
- B、SELECT COUNT(dept_id) FROM employees WHERE last_name='Smith';
- C、SELECT DISTINCT(COUNT(dept_id)) FROM employees WHERE last_name='Smith';
- D、SELECT COUNT(DISTINCT dept_id) FROM employees WHERE last_name='Smith';
- E、SELECT UNIQUE(dept_id) FROM employees WHERE last_name='Smith';
正确答案:D
第23题：

You work as the enterprise exchange administrator at Company.com.The Company.com network consists of a single Active Directory domain named Company.com.Company.com has an Exchange Server 2010 organization.Company.com contains a mail-enabled group named TestGr1.You have received complaints from the employees not residing inside the company， that their e-mail messages sent to TestGr1@contoso.com produce a non-delivery report （NDR）.You need to adhere to the problem.What should you do？（）
- A、The best option is to change the authentication settings for the Client Receive connector.
- B、The best option is to change the moderation settings for TestGr1.
- C、The best option is to change the remote IP address range for the Client Receive connector.
- D、The best option is to change the message delivery restrictions for TestGr1.
正确答案:D

20. Among employees __________, the support for the change is zero. A. at length B. at last C. at large D. at best

题目

相似考题

更多“20. Among employees __________, the support for the change is zero. A. at length B. at last C. at large D. at best”相关问题

相关内容