-
Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:
https://assets.asklib.com/images/image2/2018080115371724654.jpg
Which UPDATE statement is valid?()
A .https://assets.asklib.com/images/image2/2018080115372627375.jpg
B .https://assets.asklib.com/images/image2/2018080115372921481.jpg
C .https://assets.asklib.com/images/image2/2018080115373261310.jpg
D .https://assets.asklib.com/images/image2/2018080115373612285.jpg
-
Examine the description of the EMPLOYEES table:
https://assets.asklib.com/images/image2/2018080110341576486.jpg
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'
-
The ()of employees in this company has doubled.
A . sum
B . amount
C . number
-
User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to?()
A . null lock on the row being updated
B . null lock on the table containing the row
C . ROW SHARE lock for the row being updated
D . ROW EXCLUSIVE lock for the row being updated
E . shared row-exclusive lock for the row being updated
F . a shareable table lock for the table containing the row
G . exclusive table-level lock for the table containing the row
-
If employees working from home, the managers can review employee’s job performance based on their process instead of the result of their work.
-
In accordance with the class, which of the following the NOT the benefit of the employee training and development?
-
In the column of “Comments” of the appraisal form the appraiser may jot down the employee’s ______.
-
New employee orientation is the process a company use for showing a new employee around of the organization.
-
According to the class, which of the following is NOT the effect of the employee training and development?
-
The procedure of new employee orientation will be the same in different organizations.
-
What is the problem with the employee of the fast food restaurant?
-
The more the decision-making power of lower-level employees, the more decentralized the organization is.
-
From the organizational chart, we can see the appointed task of employees, line of authority and decision responsibility.
-
The company of 3M got ideas of Post-it notes from its employees.
-
Both employees and the boss may feel confused of the job sharer’s responsibility sometimes.
-
What is the attitude of the employees in Honeyday Resorts toward Shadow Day?
A.Indifferent
B.Enthusiastic
C.Curious
D.Confused
-
Click the Exhibit button to examine the structures of the EMPLOYEES and TAX tables.You need to find the percentage tax applicable for each employee. Which SQL statement would you use?()
<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135988/ea49d0916fc0345195a85a9b2816cb50.jpg' />
A.SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t ON e.salary BETWEEN t.min_salary AND t.max_salary;
B.SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t WHERE e.salary > t.min_salary AND < t.max_salary;
C.SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t ON (MIN(e.salary) = t.min_salary AND MAX(e.salary) = t.max_salary);
D.You cannot find the information because there is nocommon column between the two tables.
-
Examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables.Which two SQL statements produce the name, department name, and the city of all the employees who earn more then 10000?()
<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/24b8b2127f6e518cc48ee2eb3e995f55.jpg' />
A.<img src='https://img2.soutiyun.com/ask/uploadfile/2019-02-04/9c9ecd3bc18e9e5ea56864899f6fd379.jpg' />
B.<img src='https://img2.soutiyun.com/ask/uploadfile/2019-02-04/ce2012a411732ad75a4283de3ff8e2ef.jpg' />
C.<img src='https://img2.soutiyun.com/ask/uploadfile/2019-02-04/07b2ad486cb8e688542e91608c75a123.jpg' />
D.<img src='https://img2.soutiyun.com/ask/uploadfile/2019-02-04/a73cb726d1955a9d3c0133877ce50fd8.jpg' />
-
Scott McDonald fired one of his employees because the employee
A.didn"t accomplish his job well.
B.drove too fast.
C.covered up his illness.
D.cheated when he asked for leave.
-
How do employees contribute to the profitability under the corporate culture of Compaq Computers?
-
Only five of the firm's employees are______; all the other 19 were temporary.
A.permanent
B.persistent
C.perspective
D.pessimistic
-
The company was reportedly going bankrupt and this would result in the()of thousands of employees.
A.layoff
B.setout
C.layout
D.setoff
-
The Zest Industries had a total of 600 employees whore signed in 2019, the total amount of employees was6000, with 5500 full time employees.Please calculate the voluntary separation rate of Zest Industries in 2019_______
A.0.05
B.0.08
C.0.1
D.0.109
-
Responsibilities of the employees:
(1) Business manager: be responsible for ____ within specific countries
-
Examine the data of the EMPLOYEES table.EMPLOYEES (EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID)Evaluate this SQL statement:What is its output?()
<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/6bce46904716f2e8357f4849d2a3423d.jpg' />
<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/c5c76fa6bab26c6735c868df586306cf.jpg' />
A.<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/0f921b8c15106e9d6cc8e36a50134106.jpg' />
B.<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/d072515564553d90b433296aa71e021a.jpg' />
C.<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/b4721c6b94a9b61c92cdbe82aabc3ae1.jpg' />
D.<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135449/b27c35e83798de4bbbccaef22fa31b48.jpg' />
E. The SQL statement produces an error.