-
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'
-
Which of following is used to periodically multicast by DIS on a LAN to ensure IS-IS link state databaseaccuracy？（）
A . LSP
B . PSNP
C . ISH
D . CSNP
E . IIH
-
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.
-
New employee orientation is the process a company use for showing a new employee around of the organization.
-
Some companies have a team-based culture with employee participation on all levels, while others have a more traditional and formal management style.
-
There has been a sharp ______ in profits this year, so some companies have dismissed many employees.
-
The______comprises the European Central bank and the national central banks of those countries that have adopted the Euro.
-
The company of 3M got ideas of Post-it notes from its employees.
-
Suggestion systems are an important part of employee recognition programs.
-
Why are the eight coins of euro different in composition, weight, thickness, and milling？
A．Because each nation wants to keep its characteristics.
B．Because they are designed by different artists from 8 countries.
C．Because it will enable the blind to distinguish between them easily.
D．Because Denmark and other countries want to have their own coins.
-
A．It dropped due to the weakness of the Euro zone economies and the inexperience of the Europe an Central Bank in dealing with the international markets.
B．People in most European countries refused to use Euro instead of their own currency.
C．Counterfeiters made a lot of fake notes since people were not familiar with the new currency.
D．Some countries are not ready for the Euro. They stopped using Euro in daily purchasing.
-
听力原文： The dollar dipped against the euro and the yen on Monday in the wake of weak U. S. jobs data, although the euro remained vulnerable due to worries about the political and economic outlook of the European Union.
The greenback was sold off after weak U.S. jobs figures on Friday but the euro remained close to 8-month lows after France and the Netherlands rejected the EU constitution in referendums last week.
"It's been one-way news in favor of the dollar apart from Friday's job data... We're seeing a bit of a move back today but it's not that convincing. Such is the weight of bad news on the euro," said Ian Gunner, head of foreign exchange research at Mellon Bank.
U.S. jobs growth in May was the worst in 21 months, data showed on Friday, coming after figures last week showed manufacturing activity was the slowest in almost two years.
By 0750 GMT, the euro stood at $1.2266 against the dollar, up a quarter of a percent from late New York levels on Friday and a cent above last week's 8-month low of $1.2157. The euro was little changed against the yen.
The dollar was also down a quarter of a percent against the yen at 107.29 yen.
Eurozone finance ministers meet in Luxembourg on Monday and Tuesday in the face of uncertainty over further European political and monetary integration following the two "no" votes.
Rejection of the charter at the referendums, along with the region's poor growth prospects, helped push the euro down almost 3 percent against the dollar last week.
Britain's foreign secretary was expected to announce on Monday the country was shelving plans for a referendum on the EU constitution, one step short of publicly declaring it dead.
The euro wobbled after European Central Bank Chief Economist Otmar Issing was quoted as saying that policy strategy does not rule out an interest rate cut.
A cut in rates would further underscore the dollar's interest rate advantage over the euro. U.S. rates stand at 3.0 percent compared to 2.0 percent in the euro zone.
According to the news item, ______.
A．both the dollar and the euro were strong
B．both the dollar and the euro were weak
C．the dollar was strong while the euro was weak
D．the dollar was weak while the euro was strong
-
听力原文：W: Today, we invite Mr. Sonderim to talk something about the Euro. Mr, Sonderim, could you tell us the origin of the Euro？
M: Well, the 1992 Maastricht Treaty proposed a single currency between the European Union. The participating countries decided on the name "Euro' at a summit in Madrid in 1995 and the currency was launched on January 1, 1999.
W: What is it worth？
M: When the Euro was launched in 1999, one Euro was worth 1.17 US dollars or 71 British pence. However, the weakness of the Euro zone economies compared with that of the United States, combined with the inexperience of the European Central Bank in dealing with the international markets, has meant that since its launch the value of the Euro had declined significantly. In December 2001, one Euro was worth little more than 89 cents or 63 pennies, a 20 percent drop on its initial value.
W: Do you think it will affect the daily life of ordinary people？
M: I suppose so. For example, one of the major headaches for participating countries has been the con version of public telephones, vending machines, and shopping trolleys to accept Euro coins. Al though a conversion process has been in full swing since before 1999, there are reports that some countries are not ready for the Euro.
W: So what does it look like？
M: There are seven notes designed by the Austrian artist Robert Kalina. The designs show the "seven ages" of European development, with windows and gateways on the front, and bridges on the back. In addition, there are eight coins designed by the Belgian artist Luc Luycx. All Euro coins are round, but have differences in composition, weight, thickness, and milling to ensure that the blind can easily distinguish between them. On the front there is a European design, common to all coins, and on the back a "national" design from the central bank of issue. Despite the "national identities'', all coins can be spent throughout the Euro zone regardless of their origin.
(36)
A．1992
B．1995
C．1999
D．2001
-
Then, some employees only【C9】______ a reading knowledge of English,
A.needed
B.need
C.needs
-
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.
-
For some employers, the policy of lifelong employment is particularly important because it means that they can put money and effort into their staff (职员) training and make them loyal to the company. What they do is to select young people who have potential (潜能) and who can be trained, they then give the young people the kinds of skills that will make them suitable employees for the company. In other words, they adjust their training to their particular needs.
One recently employed graduate says that she is receiving a great deal of valuable training from the company. "This means that I will be a loyal employee, " she says, " And it also means that the company will want to keep me. I am an important investment for them. So the policy is a good one because it benefits both the employer and the employee. "
Recently, however, attitudes towards lifelong employment are beginning to change. Employees are slowly beginning to accept the idea that lifelong employment is not always in their best interest and that changing firms can have career advantages.
The purpose of lifelong employment is to______.
A．adjust the needs of the company to its employees
B．make employees loyal to their company
C．select the best skilled young employees
D．keep the skilled staff satisfied
-
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 expected rate of change in the nominal dollar/euro exchange rate is best described as
A．the expected rate of change in the real dollar/euro exchange rate minus the U．S．-Europe expected inflation differencE．
B．the expected rate of change in the real dollar/euro exchange rate plus the U．S．-Europe real interest rate differencE．
C．the expected rate of change in the real dollar/euro exchange rate plus the U．S．-Europe expected inflation differencE．
D．the expected rate of change in the real dollar/euro exchange rate minus the U．S．-Europe real interest rate differencE．
E．the expected rate of change in the real dollar/euro exchange rate plus the European expected inflation．
-
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.
