网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
HR department Annual Dinner Tickets on sale from tomorrow Advance purchase essential
A
The ticket for this event is free.
B
You must have tickets for this event.
C
Tickets are now on sale for this event.
参考答案
参考解析
解析：
题意：人事部门年度聚餐明天开始售票，必须提前购票。由此可知选项A“此票免费”和选项C“现在正在卖票”均不合题意。
题意：人事部门年度聚餐明天开始售票，必须提前购票。由此可知选项A“此票免费”和选项C“现在正在卖票”均不合题意。
更多 “单选题HR department Annual Dinner Tickets on sale from tomorrow Advance purchase essentialA The ticket for this event is free.B You must have tickets for this event.C Tickets are now on sale for this event.” 相关考题
考题
The sale is __ for tomorrow, but the shoppers are already lining up in a long queue.
A.decidedB.plannedC.scheduledD.appointed
考题
A sale of treasury stock may result in a decrease in paid－in－capital. All decreases should be charged to the Paid－In－Capital from Sale of Treasury account.()
此题为判断题(对，错)。
考题
What can you infer from the text about the dinner party?
A、It's a pleasure going to a dinner party.B、Dinner parties help you get to know other people.C、You can have unusual foods at dinner parties.D、Guests seldom enjoy the party.
考题
Which term means “the amount of money which a business obtains (in a year) from customers by selling goods or services”?
A、Annual incomeB、operation profitC、annual turnoverD、net profit
考题
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);
考题
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));
考题
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);
考题
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));
考题
Click the Exhibit button and 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 AVG(SALARY));
考题
根据以下内容，回答211-214题。
Summer Travel Sale
North Sun Airlines is proud to bring you its annual Summer Travel Sale! As usual, fights be-tween selected cities in the U.S. and Canada are on sale for as low as $44 each way. Fares this low can't last long, so visit our website or call a customer service operator and book your tickets today!
Prices below apply to travel beginning May 21st,2006. Travel must be completed by October lst,2006. Tickets must be purchased by May 1st to be eligible for the sale.
Sample One-way Summer Sales Fares
Minneapolis to Winnipeg $44
Pittsburgh to Toronto $64
Sacramento to Victoria $64
Omaha to Denver$94
Detroit to Ottawa $94
Cleveland to Toronto $94
Toronto to Dallas $94
Columbus to Quebec City$104
Philadelphia to Ottawa$104
San Jose to San Antonio$114
What is true about North Sun Airlines?A.It offers worldwide flights
B.It is based in the United States
C.It holds a sale every summer
D.It sells cheap round-trip tickets
考题
Questions 99-101 refer to the following letter.
March 3,2006
Asa Mitchell
7690 Cardinal Hill #34
Melbourne, Victoria
Dear Mr. Mitchell,
I have the great privilege of inviting you to the sixteenth annual Fight Cancer Foundation(FCF) celebrator dinner and fundraiser on the evening of March 21. We have had tremendous success over the last year in collecting donations and forwarding them to organizations committed (1)___________ a cure for cancer. Come help us celebrate that success!
This will be a black-tie event, and all of FCF's board members and executives will be (2)____________ Dinner, drinks, and musical entertainment will be provided. Ordinarily, tickets to this event cost $100 per person. However, as a regular and generous contributor to our worthy cause, you will receive two tickets absolutely (3)____________All guests will of course have the opportunity to make additional donations at the dinner. We at the Fight Cancer Foundation thank you for your support,and we hope you can join us on March 21st.
Sincerely,
Valerie Sobetzki
第(1)处应填_________A.to finding
B.finding
C.to find
D.find
考题
NOTICE TO ALL EMPLOYEES: 14th ANNUAL CONFERENCE OF IT PROFESSIONALS
CVD Inc. will be sending one employee from the IT Department to this conference, which will take place
over a weekend in the spring at the Royal Embassy Hotel in Cambridge, Massachusetts. This years'
conference topic is ”Information Technology and Human Resources: Bridging the Gap”. Interested
employees should send an e-mail to Ashwin Jain at ajain@cvd.com, stating why they believe they should
be sent on the conference and how they would use what they learned there to better the company upon
their return. If a suitable candidate is not found in the IT Department by January 15th, employees from
Human Resources (HR) with strong computer skills will be invited to apply.
From:
To:
Subject: Conference
Ashwin,
I am writing to notify you of my interest in attending the 14th Annual Conference of IT Professionals. As
soon as I saw the posting yesterday afternoon, I knew that I wanted to apply.
While I realize that I have not been with CVD Inc. for as long as many others in my department, I think
my unique mix of skills and experience makes me the ideal person to attend. For the first half of my
professional career, I worked as a Human Resources Manager for a software development firm. I am
familiar with strategic management principles, HR policy administration, and organizational change and
development trends. I frequently facilitated workshops and training sessions and am very comfortable
presenting to a group.
When I decided five years ago to realize a dream and pursue an education in computer programming
(which had previously been just a hobby), I knew that I wanted to work for a great company like CVD
Inc. I love my job here but I do sometimes miss the human element of HR work. That's why I think that
attending this conference would be an ideal situation for both myself and the company. Who better to
absorb and circulate the information than someone who has had her feet in both worlds?
Thank you for considering me for this opportunity,
Louise Campineau
IT Department
CVD Inc.
What is the main purpose of the conference?A. Bringing human resources and technology closer together
B. How to apply for human resource jobs
C. Examining how IT and HR affect bridge-building
D. Examining how HR should look at bridge technology
考题
Examine the data in the EMPLOYEES and DEPARTMENTS tables: EMPLOYEES EMP_NAME DEPT_ID MGR_ID JOB_ID SALARY EMPLOYEE_ID 101 Smith 20 120 SA_REP 4000 102 Martin 10 105 CLERK 2500 103 Chris 20 120 IT_ADMIN 4200 104 John 30 108 HR_CLERK 2500 105 Diana 30 108 IT_ADMIN 5000 106 Smith 40 110 AD_ASST 3000 108 Jennifer 30 110 HR_DIR 6500 110 Bob 40 EX_DIR 8000 120 Ravi 20 110 SA*DIR 6500 DEPARTMENTS DEPARTMENT_ID DEPARTMENT_NAME 10 Admin 20 Education 30 IT 40 Human Resources Also examine the SQL statements that create the EMPLOYEES and DEPARTMENTS tables: CREATE TABLE departments (department_id NUMBER PRIMARY KEY, department _ name VARCHAR2(30)); CREATE TABLE employees (EMPLOYEE_ID NUMBER PRIMARY KEY, EMP_NAME VARCHAR2(20), DEPT_ID NUMBER REFERENCES departments(department_id), MGR_ID NUMBER REFERENCES employees(employee id), MGR_ID NUMBER REFERENCES employees(employee id), JOB_ID VARCHAR2(15). SALARY NUMBER); ON the EMPLOYEES, On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. DEPT_ID is foreign key to DEPARTMENT_ID column of the DEPARTMENTS table. On the DEPARTMENTS table, DEPARTMENT_ID is the primary key. Examine this DELETE statement: DELETE FROM departments WHERE department id = 40; What happens when you execute the DELETE statement?（）A、Only the row with department ID 40 is deleted in the DEPARTMENTS table.B、The statement fails because there are child records in the EMPLOYEES table with department ID 40.C、The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 110 and 106 are deleted from the EMPLOYEES table.D、The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 106 and 110 and the employees working under employee 110 are deleted from the EMPLOYEES table.E、The row with department ID 40 is deleted in the DEPARTMENTS table. Also all the rows in the EMPLOYEES table are deleted.F、The statement fails because there are no columns specifies in the DELETE clause of the DELETE statement.
考题
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));
考题
多选题Examine the data in the EMPLOYEES table: Which three subqueries work? （）ASELECT * FROM employees where salary (SELECT MIN(salary) FROM employees GROUP BY department _ id);BSELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);CSELECT distinct department_id FROM employees Where salary ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);DSELECT department_id FROM employees WHERE SALARY ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);ESELECT last_name FROM employees Where salary ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);FSELECT department_id FROM employees WHERE salary ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));
考题
单选题Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?（）A
SELECT ename, salary*12 ‘Annual Salary’ FROM employees;B
SELECT ename, salary*12 “Annual Salary” FROM employees;C
SELECT ename, salary*12 AS Annual Salary FROM employees;D
SELECT ename, salary*12 AS INITCAP(“ANNUAL SALARY”) FROM employees
考题
单选题Examine the structure of the EMP_DEPT_VU view: Column Name Type Remarks EMPLOYEE_ID NUMBER From the EMPLOYEES table EMP_NAME VARCHAR2(30) From the EMPLOYEES table JOB_ID VARCHAR2(20) From the EMPLOYEES table SALARY NUMBER From the EMPLOYEES table DEPARTMENT_ID NUMBER From the DEPARTMENTS table DEPT_NAME VARCHAR2(30) From the DEPARTMENTS table Which SQL statement produces an error?（）A
SELECT * FROM emp_dept_vu;B
SELECT department_id, SUM(salary) FROM emp_dept_vu GROUP BY department _ id;C
SELECT department_id, job_id, AVG(salary) FROM emp_dept_vu GROUP BY department _ id, job_id;D
SELECT job_id, SUM(salary) FROM emp_dept_vu WHERE department_id IN (10,20) GROUP BY job_id HAVING SUM (salary) 20000E
None of the statements produce an error; all are valid.
考题
单选题Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEESColumn name Data type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2 (30) JOB_ID VARCHAR2 (20) SALARY NUMBER MGR_ID NUMBER References EMPLOYEE_ID COLUMN DEPARTMENT ID NUMBER Foreign key to DEPARTMENT ID column of the DEPARTMENTS table DEPARTMENTSColumn name Data type Remarks DEPARTMENT_ID NUMBER NOT NULL, Primary Key DEPARTMENT_NAME VARCHAR2(30) MGR_ID NUMBER References MGR_ID column of the EMPLOYEES table Evaluate this SQL statement: SELECT employee_id, e.department_id, department_name, salary FROM employees e, departments d WHERE e. department_id = d.department_id; Which SQL statement is equivalent to the above SQL statement? （）A
SELECT employee_id, department_id, department_name, salary FROM employees WHERE department_id IN (SELECT department_id FROM departments);B
SELECT employee_id, department_id, department_name, salary FROM employees NATURAL JOIN departments;C
SELECT employee_id, d.department_id, department_name, salary FROM employees e JOIN departments d ON e.department _ id = d. department_id;D
SELECT employee_id, department_id, department_name, Salary FROM employees JOIN departments USING (e.department_id, d.department_id);
考题
单选题You need to configure Active Directory to implement the new password policy for the HR department. What should you do？（）A
Create a new child domain named hr.ad.margiestravel.com in the existing forest. Move the resources from the HR OU to this new domain. Add the appropriate security settings in the Default Domain Policy for this new domain.B
Add the appropriate security settings to the current Default Domain Policy.C
Add the appropriate security settings to the local security policy of SQL1.D
Set the SQL server check_policy and check_expiration options to On when creating all user accounts.
考题
单选题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);
考题
单选题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 dD
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);
考题
单选题Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEESColumn name Data type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2 (30) JOB_ID VARCHAR2 (20) SALARY NUMBER MGR_ID NUMBER References EMPLOYEE_ID COLUMN DEPARTMENT ID NUMBER Foreign key to DEPARTMENT ID column of the DEPARTMENTS table DEPARTMENTSColumn name Data type Remarks DEPARTMENT_ID NUMBER NOT NULL, Primary Key DEPARTMENT_NAME VARCHAR2(30) MGR_ID NUMBER References MGR_ID column of the EMPLOYEES table Evaluate this SQL statement: SELECT employee_id, e.department_id, department_name, salary FROM employees e, departments d WHERE e. department_id = d.department_id; Which SQL statement is equivalent to the above SQL statement?（）A
SELECT employee_id, department_id, department_name, salary FROM employees WHERE department_id IN (SELECT department_id FROM departments);B
SELECT employee_id, department_id, department_name, salary FROM employees NATURAL JOIN departments;C
SELECT employee_id, d.department_id, department_name, salary FROM employees e JOIN departments d ON e.department _ id = d. department_id;D
SELECT employee_id, department_id, department_name, Salary FROM employees JOIN departments USING (e.department_id, d.department_id);
考题
单选题_____before we depart the day after tomorrow, we should have a wonderful dinner party.A
Had they arrivedB
Were they arrivingC
Would they arriveD
Were they to arrive
热门标签
最新试卷
