单选题Defining employee “customer” segments meansA offering some employees more and the other less.B relating the customers to the employees’ benefits.C varying benefits according to different employees.D dividing employees into different groups.

题目
单选题
Defining employee “customer” segments means
A

offering some employees more and the other less.

B

relating the customers to the employees’ benefits.

C

varying benefits according to different employees.

D

dividing employees into different groups.


相似考题
参考答案和解析
正确答案: B
解析:
把define employee “customer”segments定位在文中第四段第四行。该段首句为中心句,提到“…employers should tailor their investment in benefits to the preferences of their employees…”,即“雇主应该根据员工的不同喜好来进行福利投资”。可以推断该短语意思应该为“把员工划分为不同的需求群体,故选项D符合题意。
更多“单选题Defining employee “customer” segments meansA offering some employees more and the other less.B relating the customers to the employees’ benefits.C varying benefits according to different employees.D dividing employees into different groups.”相关问题
  • 第1题:

    Click the Exhibit button to examine the data of the EMPLOYEES table.Which statement lists the ID, name, and salary of the employee, and the ID and name of the employee‘s manager, for all the employees who have a manager and earn more than 4000?()

    A.SELECT employee_id "Emp_id", emp_name "Employee", salary, employee_id "Mgr_id", emp_name "Manager" FROM employees WHERE salary > 4000;

    B.SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary, m.employee_id "Mgr_id", m.emp_name "Manager" FROM employees e JOIN employees m WHERE e.mgr_id = m.mgr_id AND e.salary > 4000;

    C.SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary, m.employee_id "Mgr_id", m.emp_name "Manager" FROM employees e JOIN employees m ON (e.mgr_id = m.employee_id) AND e.salary > 4000;

    D.SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary, m.mgr_id "Mgr_id", m.emp_name "Manager" FROM employees e SELF JOIN employees m WHERE e.mgr_id = m.employee_id AND e.salary > 4000;

    E.SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary, m.mgr_id "Mgr_id" m.emp_name "Manager" FROM employees e JOIN employees m USING (e.employee_id = m.employee_id) AND e.salary > 4000;


    参考答案:C

  • 第2题:

    The passage is mainly about__________.

    A.what has brought about less working time
    B.why employees want to make more money
    C.why employees have less leisure time
    D.what a good employee should be like

    答案:C
    解析:
    通过对全文的通读和理解,可知本文一直在围绕着为什么现在工作的人的业余时间那么少。

  • 第3题:

    资料:Placing the right type of workers in close proximity to each other can generate up to a 15 percent increase in organizational performance,according to the study from Cornerstone On Demand,a provider of cloud-based learning and talent-management software,and researchers at Harvard Business School in Massachusetts. For businesses with 2,000 employees, this translates into an additional $1 million in profit each year,the study said.
    For the study,researchers examined data from a two-year period of more than 2,000 employees working at a large technology company with locations in the U.S. and Europe. The study’s authors separated workers into three different categories based on the work they produced:
    Productive: These employees are very productive,but don’t always produce quality work.
    Quality:These workers produce work of superior quality,but aren’t always productive.
    Generalists: These employees are average in terms of both productivity and quality.
    The researchers defined productivity by how long it takes an employee to finish a task,and effectiveness by how often employees need to ask a co-worker for help completing a task.

    What might be discussed later?

    A.The reason for better performances
    B.The impact of seating employees close to each other
    C.The findings of seating different categories of people
    D.All above

    答案:C
    解析:
    本题考查的是推理判断。
    【关键词】discussed;later
    【主题句】最后1自然段The researchers defined productivity by how long it takes an employee to finish a task,and effectiveness by how often employees need to ask a co-worker for help completing a task.研究人员通过员工完成一项任务需要多长时间来定义工作效率,通过员工为完成任务每隔多长时间向同事寻求帮助来定义工作有效性。
    【解析】本题的问题是“接下来可能会讨论什么”。 A选项“更好表现的原因”;B选项“员工就近落座的影响”;C选项“不同类别的员工座位的发现”;D选项“以上都是”。通读全文,文章开头处由一项研究引入,说明合适的坐位安排会使组织绩效提高,继而介绍研究背景,将员工划分为三种类型。接下来,应该是会具体讲述哪些员工坐在一起绩效更好的关于不同类别员工座位的发现,因此C选项更符合题意。A选项过于笼统,且应当跟在第1自然段之后进行论述,而B选项在第1自然段进行过讨论,因此C选项正确。

  • 第4题:

    资料:Gone are the days of “one-size-fits-all” employee benefits programs and here come newly designed and fully customized voluntary benefits. Voluntary benefits are on longer looked at as just a few “extras”, and are now becoming part of a comprehensive benefits package. Lot's take a look at how voluntary benefits have become more customized to meet the requirements of a more particular health care consumer.
    Voluntary Benefits Bolster Recruitment and Retention Efforts
    It gives employees a chance to select extras that the standard health care plan doesn't offer, which can be highly attractive to today's consumers Employers can also use voluntary benefits to round out their health care plans with a menu of items that cover everything from family vision care to pet insurance. This helps companies to address the specific heath and financial needs of candidates, to help the stretch their future paychecks even further.
    The Advantages of Offering Voluntary Employee Benefits
    In terms of being adaptable to the needs of employees, there are very few benefits that are like voluntary plans. Voluntary plans cover many of the gaps that traditional health benefits do not cover. For example, a health care plan may require dental services for minors, but not for adults. The voluntary dental program can cover things like routine cleanings and other preventative measures that help support good oral health.

    Customizing Voluntary Benefit Plans
    There are several areas where voluntary benefit plans exceed the customization options of other types of wellness and financial benefits. This is a continual trend that we will see more of. Financial wellness benefits can include budgeting software, company matched savings plans, employee purchase programs, discount cards, credit union access, and even short term financing to help employees who otherwise cannot get credit to purchase things they need. Some companies offer support for buying of leasing vehicles, pay off college loans, arrange for special discounts and deals on home rentals and purchases, and even provide access to tuition for college expenses.

    It can be inferred from the passage that, comparing with the traditional health benefits, voluntary plans______

    A.incur less cost by the company to offer benefit programs.
    B.cover many of the gaps that traditional health benefits do not cover.
    C.help employees who are dealing with tough personal and career matters.
    D.encourage employees to stay with their companies for longer periods of time.

    答案:B
    解析:
    本题考查的是细节理解。
    【关键词】comparing with the traditional health benefits
    【主题句】第3自然段Voluntary plans cover many of the gaps that traditional health benefits do not cover. 自愿计划覆盖了许多传统健康福利不能涵盖的缺口。
    【解析】本题的问题是“从文章中推断出,与传统健康福利相比,自愿计划______”。A选项“公司提供福利项目花费较少”,B选项“覆盖了许多传统健康福利不能涵盖的缺口”,C选项“对那些正在与个人和职业事务艰难博弈的员工有帮助”,D选项“鼓励员工为所属公司工作更长时间”。根据主题句可知,选项B正确。

  • 第5题:

    资料:Gone are the days of “one-size-fits-all” employee benefits programs and here come newly designed and fully customized voluntary benefits. Voluntary benefits are on longer looked at as just a few “extras”, and are now becoming part of a comprehensive benefits package. Lot's take a look at how voluntary benefits have become more customized to meet the requirements of a more particular health care consumer.
    Voluntary Benefits Bolster Recruitment and Retention Efforts
    It gives employees a chance to select extras that the standard health care plan doesn't offer, which can be highly attractive to today's consumers Employers can also use voluntary benefits to round out their health care plans with a menu of items that cover everything from family vision care to pet insurance. This helps companies to address the specific heath and financial needs of candidates, to help the stretch their future paychecks even further.
    The Advantages of Offering Voluntary Employee Benefits
    In terms of being adaptable to the needs of employees, there are very few benefits that are like voluntary plans. Voluntary plans cover many of the gaps that traditional health benefits do not cover. For example, a health care plan may require dental services for minors, but not for adults. The voluntary dental program can cover things like routine cleanings and other preventative measures that help support good oral health.

    Customizing Voluntary Benefit Plans
    There are several areas where voluntary benefit plans exceed the customization options of other types of wellness and financial benefits. This is a continual trend that we will see more of. Financial wellness benefits can include budgeting software, company matched savings plans, employee purchase programs, discount cards, credit union access, and even short term financing to help employees who otherwise cannot get credit to purchase things they need. Some companies offer support for buying of leasing vehicles, pay off college loans, arrange for special discounts and deals on home rentals and purchases, and even provide access to tuition for college expenses.

    Which of the following titles would best describe the content of the passage?

    A.Voluntary Employee Benefits surpasses the traditional health benefit.
    B.Voluntary Employee Benefits are becoming more customized.
    C.The Advantages of Offering Voluntary Employee Benefits.
    D.Voluntary Employee Benefits and health care consumers.

    答案:B
    解析:
    本题考查的是主旨大意。
    【关键词】titles; best describe the content of the passage
    【主题句】第1自然段Lot's take a look at how voluntary benefits have become more customized to meet the requirements of a more particular health care consumer.让我们看一看自愿福利是如何变得更加个性化定制以迎合健康保健客户的更特殊需求的。
    【解析】本题的问题是“下列哪个题目最好地形容了文章内容”。A选项“自愿员工福利超越了传统健康福利”,B选项“自愿员工福利正在变得更加个性化定制”,C选项“提供自愿员工福利的优点”,D选项“自愿员工福利与健康保健客户”。根据主题句可知,选项B正确。

  • 第6题:

    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

  • 第7题:

    Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE NEW_EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2 (60) Which DELETE statement is valid?()

    • A、DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);
    • B、DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_ employees);
    • C、DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = 'carrey');
    • D、DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = 'carrey');

    正确答案:C

  • 第8题:

    Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE NEW_EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2(60) Which DELETE statement is valid?()

    • A、DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);
    • B、DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_employees);
    • C、DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name ='Carrey');
    • D、DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE last_name ='Carrey');

    正确答案:C

  • 第9题:

    单选题
    According to this passage, which of the following statements is FALSE?
    A

    Many employees don’t like a conservative dress code.

    B

    Comfortable clothes make employees more productive.

    C

    A casual clothes code is welcomed by young employees.

    D

    All the employers in the U. S. are for casual office wear.


    正确答案: D
    解析:
    信息题。A选项“许多员工不喜欢保守的着装规定”和原文第三段“85 percent of employers said that they believe that casual dress improves employee morale”内容相符;B选项“舒适的着装能提高员工的工作效率”体现在原文中“... people seem happier and more productive when they are wearing comfortable clothes”;C选项“休闲的着装规定很受年轻雇员的欢迎”和原文“A lot of young people don’t want to dress up for work”相符;D选项“美国所有的雇主都支持休闲着装的原则”和原文85%不符,答案为D选项。

  • 第10题:

    单选题
    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
    解析: 暂无解析

  • 第11题:

    单选题
    In the passage, the following advantages of casual office wear are mentioned EXCEPT _____.
    A

    saving employees’ money

    B

    making employees more attractive

    C

    improving employees’ motivation

    D

    making employees happier


    正确答案: D
    解析:
    信息题。A选项“节省员工的开销”和原文第三段“casual dress code helps them save money”相符;B选项“让员工看起来更加有吸引力”未在文中提及;C选项“提升员工的动力”和原文“casual dress improves employee morale”相符;D选项“让员工心情更愉悦”体现在原文“people seem happier and more productive when they are wearing comfortable clothes”。

  • 第12题:

    单选题
    When preparing benefit changes, companies should
    A

    treat employees as customers.

    B

    stress the benefits of the changes.

    C

    talk employees into accepting the changes.

    D

    act quickly according to the reactions of employees.


    正确答案: D
    解析:
    该题问的是“准备进行福利改动的时候,公司应该怎么做”。文中第五段第二句指出“Companies should approach them with the same caution that consumers get...”,与选项A意思相符。

  • 第13题:

    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

  • 第14题:

    资料:Placing the right type of workers in close proximity to each other can generate up to a 15 percent increase in organizational performance,according to the study from Cornerstone On Demand,a provider of cloud-based learning and talent-management software,and researchers at Harvard Business School in Massachusetts. For businesses with 2,000 employees, this translates into an additional $1 million in profit each year,the study said.
    For the study,researchers examined data from a two-year period of more than 2,000 employees working at a large technology company with locations in the U.S. and Europe. The study’s authors separated workers into three different categories based on the work they produced:
    Productive: These employees are very productive,but don’t always produce quality work.
    Quality:These workers produce work of superior quality,but aren’t always productive.
    Generalists: These employees are average in terms of both productivity and quality.
    The researchers defined productivity by how long it takes an employee to finish a task,and effectiveness by how often employees need to ask a co-worker for help completing a task.

    What is NOT true about the categories of the workers?

    A.There is no particular order of these categories
    B.Generalists are those who are neither productive nor effective
    C.The frequency employees need to ask a co-worker for help completing a task is recorded as effectiveness
    D.Productive workers are those who finish a task quickly

    答案:B
    解析:
    本题考查的是细节理解。
    【关键词】NOT true about the categories of the workers
    【主题句】第3自然段Productive: These employees are very productive,but don’t always produce quality work.
    Quality:These workers produce work of superior quality,but aren’t always productive.
    Generalists: These employees are average in terms of both productivity and quality.
    The researchers defined productivity by how long it takes an employee to finish a task,and effectiveness by how often employees need to ask a co-worker for help completing a task.
    高产出:这些员工非常有生产力,但并不总是产出高质量的工作。
    高质量:这些工人生产的工作质量很高,但并不总是高效率的。
    通才:这些员工的生产力和质量都很平均。
    研究人员通过员工完成一项任务需要多长时间来定义工作效率,通过员工为完成任务每隔多长时间向同事寻求帮助来定义工作有效性。
    【解析】本题的问题是“关于员工类别,哪一项不正确?”A选项“这些类别没有特定的顺序”;B选项“通才是那些既没有生产力又没有效率的人”;C选项“员工要求同事帮助完成任务的频率记录为有效性”;D选项“高产出工人是那些快速完成任务的人”。根据题目中关键词找到主题句,通才是生产力和质量平均的人,而非不具备生产力和效率的人,故选B。

  • 第15题:

    资料:Gone are the days of “one-size-fits-all” employee benefits programs and here come newly designed and fully customized voluntary benefits. Voluntary benefits are on longer looked at as just a few “extras”, and are now becoming part of a comprehensive benefits package. Lot's take a look at how voluntary benefits have become more customized to meet the requirements of a more particular health care consumer.
    Voluntary Benefits Bolster Recruitment and Retention Efforts
    It gives employees a chance to select extras that the standard health care plan doesn't offer, which can be highly attractive to today's consumers Employers can also use voluntary benefits to round out their health care plans with a menu of items that cover everything from family vision care to pet insurance. This helps companies to address the specific heath and financial needs of candidates, to help the stretch their future paychecks even further.
    The Advantages of Offering Voluntary Employee Benefits
    In terms of being adaptable to the needs of employees, there are very few benefits that are like voluntary plans. Voluntary plans cover many of the gaps that traditional health benefits do not cover. For example, a health care plan may require dental services for minors, but not for adults. The voluntary dental program can cover things like routine cleanings and other preventative measures that help support good oral health.

    Customizing Voluntary Benefit Plans
    There are several areas where voluntary benefit plans exceed the customization options of other types of wellness and financial benefits. This is a continual trend that we will see more of. Financial wellness benefits can include budgeting software, company matched savings plans, employee purchase programs, discount cards, credit union access, and even short term financing to help employees who otherwise cannot get credit to purchase things they need. Some companies offer support for buying of leasing vehicles, pay off college loans, arrange for special discounts and deals on home rentals and purchases, and even provide access to tuition for college expenses.

    According to the passage, which is probably NOT included in the financial wellness benefits?

    A.Long term financing to help employees.
    B.Employee purchase programs and discount cards.
    C.Pay off college loans.
    D.Budgeting software and company matched savings plans.

    答案:A
    解析:
    本题考查的是细节理解。
    【关键词】NOT included;financial wellness benefits
    【主题句】第4自然段Financial wellness benefits can include budgeting software, company matched savings plans, employee purchase programs, discount cards, credit union access, and even short term financing to help employees who otherwise cannot get credit to purchase things they need. Some companies offer support for buying of leasing vehicles, pay off college loans, arrange for special discounts and deals on home rentals and purchases, and even provide access to tuition for college expenses.财政健康福利可以包括预算软件、公司匹配储蓄计划、员工购买项目、折扣卡、储蓄互助途径,甚至是帮助信用不足、不能贷款购买所需商品的员工的短期融资。一些公司提供支持帮助购买或租赁汽车、还清助学贷款、协调特殊折扣和处理租赁及购买房屋,甚至帮助联系解决大学学费的途径。
    【解析】本题的问题是“根据文章,下列哪一项很可能不包括在财政健康福利中?”。A选项“帮助员工的长期融资”,B选项“员工购买项目和折扣卡”,C选项“还清助学贷款”,D选项“预算软件和公司匹配储蓄计划”。根据主题句可知,提供的是短期融资,而不是长期。

  • 第16题:

    资料:Gone are the days of “one-size-fits-all” employee benefits programs and here come newly designed and fully customized voluntary benefits. Voluntary benefits are on longer looked at as just a few “extras”, and are now becoming part of a comprehensive benefits package. Lot's take a look at how voluntary benefits have become more customized to meet the requirements of a more particular health care consumer.
    Voluntary Benefits Bolster Recruitment and Retention Efforts
    It gives employees a chance to select extras that the standard health care plan doesn't offer, which can be highly attractive to today's consumers Employers can also use voluntary benefits to round out their health care plans with a menu of items that cover everything from family vision care to pet insurance. This helps companies to address the specific heath and financial needs of candidates, to help the stretch their future paychecks even further.
    The Advantages of Offering Voluntary Employee Benefits
    In terms of being adaptable to the needs of employees, there are very few benefits that are like voluntary plans. Voluntary plans cover many of the gaps that traditional health benefits do not cover. For example, a health care plan may require dental services for minors, but not for adults. The voluntary dental program can cover things like routine cleanings and other preventative measures that help support good oral health.

    Customizing Voluntary Benefit Plans
    There are several areas where voluntary benefit plans exceed the customization options of other types of wellness and financial benefits. This is a continual trend that we will see more of. Financial wellness benefits can include budgeting software, company matched savings plans, employee purchase programs, discount cards, credit union access, and even short term financing to help employees who otherwise cannot get credit to purchase things they need. Some companies offer support for buying of leasing vehicles, pay off college loans, arrange for special discounts and deals on home rentals and purchases, and even provide access to tuition for college expenses.

    The author views the voluntary employee benefits as______

    A.Revolutionary.
    B.Reliable.
    C.Salutary.
    D.Unassailable.

    答案:A
    解析:
    本题考查的是态度理解。
    【关键词】author views;voluntary employee benefits
    【主题句】第1自然段Gone are the days of “one-size-fits-all” employee benefits programs and here come newly designed and fully customized voluntary benefits. “一刀切”员工福利计划的日子已经一去不复返了,现在呈现的是全新设计的、完全为客户定制的自愿福利。
    【解析】本题的问题是“作者认为自愿员工福利是______”。A选项“革命性的”,B选项“值得信赖的”,C选项“有益的”,D选项“不容置疑的”。根据主题句,自愿员工福利取代了传统福利,具备下文所说的诸多好处,具有划时代的意义。

  • 第17题:

    In which scenario would TOP N analysis be the best solution? ()

    • A、You want to identify the most senior employee in the company.
    • B、You want to find the manager supervising the largest number of employees.
    • C、You want to identify the person who makes the highest salary for all employees.
    • D、You want to rank the top three sales representatives who have sold the maximum number of products.

    正确答案:D

  • 第18题:

    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

  • 第19题:

    You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform?()

    • A、MERGE
    • B、INSERT
    • C、UPDATE
    • D、ADD
    • E、ENTER
    • F、You cannot enter the phone numbers for the existing employee records.

    正确答案:C

  • 第20题:

    单选题
    According to the second paragraph, it is important for companies to
    A

    meet changing demands of employees.

    B

    check benefits as closely as they do with other investments.

    C

    put more emphasis on talent investments.

    D

    cut back on the investments in benefits.


    正确答案: C
    解析:
    该段第三句提到的“Such investments are increasingly important…”与选项C中的 put more emphasis on talent investments相对应。故选C。

  • 第21题:

    单选题
    Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE NEW_EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2 (60) Which DELETE statement is valid?()
    A

    DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);

    B

    DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_ employees);

    C

    DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = 'carrey');

    D

    DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = 'carrey');


    正确答案: C
    解析: 暂无解析

  • 第22题:

    单选题
    Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2 (25) LAST_NAME VARCHAR2 (25) HIRE_DATE DATE NEW EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2 (60) Which DELETE statement is valid? ()
    A

    DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);

    B

    DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_ employees);

    C

    DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = ('Carrey')'

    D

    DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE last_ name = ('Carrey')'


    正确答案: A
    解析: 暂无解析

  • 第23题:

    单选题
    You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform? ()
    A

    MERGE

    B

    INSERT

    C

    UPDATE

    D

    ADD

    E

    ENTER

    F

    You cannot enter the phone numbers for the existing employee records.


    正确答案: A
    解析: 暂无解析