-
Examine the data in the EMPLOYEES table: LAST_NAME DEPARTMENT_ID SALARY Getz 10 3000 Davis 20 1500 Bill 20 2200 Davis 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))
-
I tried()the book in a few days, but actually I couldn't, just because of too much work for me.
A . finish
B . finishing
C . to have finished
D . finished
-
I (work) _______ in the Human Resources Department for five months since I joined the company.
-
If I work in a small factory, it is not for me to gain much experience.
-
Man: Can you come over for dinner tonight?Woman: I’m up to my ears in work, so I’ll have to take a rain check.Question: What does the woman mean?
-
The word ‘bank’ is the tail in the sentence‘I used to work at a bank’.
-
Usually, I (work)_______ as a secretary at ABT, but this summer I (study)_______ French at a language school in Paris. That is why I am in Paris.
-
I'm tired of traveling in and out to work every day in the rush hour. I'dlike to buy a cottage in the country and ___________.
-
Michael works in the Technical support department.
-
After some work with a coloured pencil I succeeded in making my first drawing. In this sentence, what is the underlined part called?
-
To effectively implement the marketing concept, the marketing department in an organisation needs to work with _________.
-
I work in________ IT Department of________large bank.
A. the,a
B. a, the
C.a,a
-
My grandfather had always taken a __________ interest in nay work, and I had an equal admiration for the stories of his time.
A.splendid
B.weighty
C.vague
D.keen
-
听力原文:M: Good morning, Dr. Smith. My name is Peter. I am a freshman in your department. There are a few things that I am not quite sure of and I do need your advice.
W: Thank you very much for your trust, Peter. As your academic advisor I will try my best to help you.
M: Thanks. It's about my major...
W: Well, what's the matter?
M: I used to major in English, but now I have made up my mind to switch to Applied Linguistics, concentrating on Teaching English as a Foreign Language.
W: So you want to switch majors?
M: Yes. But I wonder if it is possible.
W: Well, usually we allow it, as long as you have enough credits.
M: That's good news for me. I'm not interested in literature and that sort of thing. I want to be a real teacher, Professor. But I'm worried about the make-up credits.
W: You usually do have to make up some credits when you switch majors. Are you OK on credits?
M: Not too many. I'll have to add about 12 credits as far as I can. figure from my transcript. Would you please let me know how many credits are required to get a master's degree?
W: Usually thirty-six credits are needed, ff you take five courses per term, you'll have enough credits after just two semesters. Usually each course is worth three credits. To get the six remaining credits you either prepare a thesis or take two more courses.
M: Is there anything else besides the 36 credits for the master's?
W: You have to have an oral defense.
M: I see.I really appreciate your help,Professor.
W: Glad I can help.Good luck.Peter.
(23)
A.A literature professor.
B.An academic advisor.
C.Dean of the English Department.
D.A Doctor of Applied Linguistics.
-
听力原文:W: I certainly would like to buy the brown suit I saw in the department store, but I don't have enough money.
M: Well, if you would budget your money more carefully, you would be able to buy it.
Q: How does the man feel about the woman?
(9)
A.She should be. careful about her money.
B.She should buy the brown suit.
C.She should find another job to make more money.
D.She shouldn't buy the brown suit.
-
听力原文:M: It's so cold today. I cannot work any longer. I really hope there's a heater in this room.
W: So do I. I think I will freeze if I stay longer.
What are they talking about?
A.The heater of this room.
B.The cold weather.
C.Long working hours.
-
Too Late to Regret it When I was a junior, I met a second-year student in my department. He wasn't tall or good-looking, but he was very nice, attractive and athletic. He had something that I admired very much. He was natural, warm, and sincere.
I disregarded (不顾) my parents' disapproval. We were very happy together. He picked me up from my dorm every morning, and after class we would sit alongside the stream that ran through campus, or sunbathe (晒太阳) on the lawn. At night he would walk me back to my dorm. He came from a poor family, but in order to make me happy, he borrowed money from his friend to buy presents and meals for me. Our fellow students looked up to him as a role model, and the girls envied (妒忌) me. He wasn't a local, but wanted to stay here after graduation. I thought we had a future together.
However, when I got a part-time job during the summer vacation, people began giving me a lot of pressure, saying that a pretty, intelligent girl like me should find a better guy to spend time with. This was also what my family thought. He spent the summer in his hometown, so I was all by myself. When he got back, I began finding fault with him. But his big heart and warmth soon drove all unpleasant thoughts away. However, I had no idea how badly I had hurt him and that things would get worse.
I had a good part4ime job off campus that paid pretty well. With my good performance at school, I also got admission to graduate school at one of China's best universities. He, on the other hand, did not do so well at school or at work. I had to worry about his living expenses, job and scores.
Almost all my colleagues and friends advised me to break up with him. Then we had a quarrel last June. He was in great pain, and my cold words and bad moods started turning him away.
Graduation time was drawing near, and he said he wanted to go back to his hometown. He said that he couldn't put up with me anymore. I was shocked and looked at him in despair.
True love happens only once, but I found it out too late.
第36题:When did the author fall in love with the boy?
A.When she was a junior.
B.After she had a quarrel with him.
C.When she was a second-year student.
D.After she found a part-time job.
-
I would prefer shopping online to shopping in a department store because________________________(它更加方便和省时).
-
I watched people in the final moments before their___ ones arrive or depart.
A.loving
B.love
C.loved
D.being loved
-
—I'm so tired, helping the family with the work in the field. —Why not take a rest, then? —______.
A.Because I have no time
B.Maybe I should
C.Sorry, I can't tell you about it
D.I don't know it
-
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));
-
听力原文:W:I need a cart his weekend, but mine has broken down in an accident when I drove to work yesterday morning.
M:I'm sorry to hear that, but you can always rent one if you have a license.
Q:What does the man mean?
(14)
A.She can use his car.
B.She can borrow someone else's car.
C.She must get her car fixed.
D.She can't borrow his car.
-
I was interested in school work: otherwise I______ mad.
A.should go
B.would have gone
C.had gone
D.would go
-
You are a network administrator for your company. The network consists of a single Active Directorydomain.A user named Mary works in the information technology security department. Mary is a member of theITSecurity global group. Mary reports that no one in the ITSecurity global group can access the securitylog from the console of a computer named Server1.You need to grant the ITSecurity global group the minimum rights necessary to view the security log onServer1.How should you modify the local security policy?()
A. Assign the Generate security audits user right to the ITSecurity global group.
B. Assign the Manage auditing and security logs user right to the ITSecurity global group.
C. Assign the Allow logon through Terminal Services user right to the ITSecurity global group.
D. Assign the Act as part of the operating system user right to the ITSecurity global group.