更多“A:The senior managers need the results from last month strai”相关问题
  • 第1题:

    The EMP table contains these columns:LAST NAME VARCHAR2(25)SALARY NUMBER(6,2)DEPARTMENT_ID NUMBER(6)You need to display the employees who have not been assigned to any department. You write the SELECT statement:SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMPWHERE DEPARMENT_ID = NULL;What is true about this SQL statement? ()

    A. The SQL statement displays the desired results.

    B. The column in the WHERE clause should be changed to display the desired results.

    C. The operator in the WHERE clause should be changed to display the desired results.

    D. The WHERE clause should be changed to use an outer join to display the desired results.


    参考答案:C

  • 第2题:

    Sales of new homes this month are down 2% from last month, ( ) 6% from a year ago.

    A. too

    B. and

    C. as well

    D. along with

    答案:B
    解析:

  • 第3题:

    A:The senior managers need the results from last month straight away, so I can't stop to talk. I've got to hurry. B:()

    A Stay longer

    B Go slowly

    C Ok, see you later


    C

  • 第4题:

    “Shipment is to be made in the second half of a month.” means shipment to be made from ().

    • A、the 1st to the 10th
    • B、the 11th to the 20th
    • C、the 1st to the 15th
    • D、the 16th to the last day of such month

    正确答案:D

  • 第5题:

    单选题
    You need to display the last names of those employees who have the letter "A" as the second character in their names.Which SQL statement displays the required results?()
    A

    SELECT last_name FROM EMP WHERE last_ name LIKE '_A%';

    B

    SELECT last_name FROM EMP WHERE last name ='*A%'

    C

    SELECT last_name FROM EMP WHERE last name ='_A%';

    D

    SELECT last_name FROM EMP WHERE last name LIKE '*A%'


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

  • 第6题:

    单选题
    It is said that the agreement _____ between the two companies last month will become effective from May 1st.
    A

    to sign

    B

    to be signed

    C

    signed

    D

    signing


    正确答案: A
    解析:
    句意为:据说上个月两家公司签订的协议将会在5月1日生效。sign和agreement之间为动宾关系,因此用过去分词。signed…last month短语做后置定语修饰agreement。

  • 第7题:

    单选题
    Evaluate these two SQL statements: SELECT last_name, salary, hire_dateFROM EMPLOYEES ORDRE BY salary DESC; SELECT last_name, salary, hire_dateFROM EMPOLYEES ORDER BY 2 DESC; What is true about them? ()
    A

    The two statements produce identical results.

    B

    The second statement returns a syntax error.

    C

    There is no need to specify DESC because the results are sorted in descending order by default.

    D

    The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.


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

  • 第8题:

    单选题
    Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member, which is not a member of the current group. How would you recover from the loss of the redo log member?()
    A

    SMON would automatically restore the lost file.

    B

    You would need to restore the whole database from the last backup.

    C

    You would need to restore the file from the last full database backup.

    D

    You would need to use flashback technology to restore the lost redo log member.

    E

    You would need to use Recovery Manager (RMAN) to restore the lost redo log member.

    F

    You would need to restore the missing log file by copying one of the remaining files from the same group.


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

  • 第9题:

    单选题
    Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY 2 DESC; What is true about them?()
    A

    The two statements produce identical results.

    B

    The second statement returns a syntax error.

    C

    There is no need to specify DESC because the results are sorted in descending order by default.

    D

    The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.


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

  • 第10题:

    单选题
    The EMP table contains these columns: LAST NAME VARCHAR2(25) SALARY NUMBER(6,2) DEPARTMENT_ID NUMBER(6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARMENT_ID = NULL; What is true about this SQL statement?()
    A

    The SQL statement displays the desired results.

    B

    The column in the WHERE clause should be changed to display the desired results.

    C

    The operator in the WHERE clause should be changed to display the desired results.

    D

    The WHERE clause should be changed to use an outer join to display the desired results.


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

  • 第11题:

    单选题
    The EMPLOYEE tables has these columns: LAST_NAME VARCHAR2(35) SALARY NUMBER(8,2) COMMISSION_PCT NUMBER(5,2) You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, a zero must be displayed against the calculated column. Which SQL statement displays the desired results?()
    A

    SELECT last_name, (salary * 12) * commission_pct FROM EMPLOYEES;

    B

    SELECT last_name, (salary * 12) * IFNULL(commission_pct, 0) FROM EMPLOYEES;

    C

    SELECT last_name, (salary * 12) * NVL2(commission_pct, 0) FROM EMPLOYEES;

    D

    SELECT last_name, (salary * 12) * NVL(commission_pct, 0) FROM EMPLOYEES;


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

  • 第12题:

    单选题
    “Shipment is to be made in the second half of a month.” means shipment to be made from ().
    A

    the 1st to the 10th

    B

    the 11th to the 20th

    C

    the 1st to the 15th

    D

    the 16th to the last day of such month


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

  • 第13题:

    It is said that the agreement __________ between the two companies last month will become effective from May 1st.

    A. to sign
    B. to be signed
    C. signed
    D. signing

    答案:C
    解析:
    考查时态语态。signed…month短语做后置定语修饰agreement。sign和agreeinent之间为动宾关系,因此用过去分词。句意为“据说上个月两家公司签订的协议将会在5月1日生效”。故选C。

  • 第14题:

    资料:HS ensures there is a clear career path for any employee, from any background. Three key levels in Harrods are the sales employee, department managers and senior managers. At each level, employees can benefit from the development programs in order to build a career.
    James is a sales Associate and one of HS first Sales Degree students. When an injure prevented him from following his previously chosen career in contemporary dance, he applied to HS. He has never looked back. HS training has given him transferable skills. He has been able to work within more than one department, providing the same high levels of experience.

    What are the three key levels in HS?

    A.the sales employees, department managers and senior managers.
    B.the sales employees,sales assistants and department managers.
    C.the senior managers,department managers and sales employees.
    D.not mentioned.

    答案:A
    解析:
    本题考查的是细节理解。
    【关键词】what three key levels; HS
    【主题句】第1自然段Three key levels in Harrods are the sales employee, department managers and senior managers. 哈罗德百货公司的三个关键级别是销售人员、部门经理和高级经理。
    【解析】本题的问题是“HS的三个关键级别是什么?”。根据主题句可知,HS的三个关键级别是销售人员、部门经理和高级经理,故选A。

  • 第15题:

    A:The senior managers need the results from last month straight away, so I can't stop to talk. I've got to hurry. B:()

    • A、 Stay longer
    • B、 Go slowly
    • C、 Ok, see you later

    正确答案:C

  • 第16题:

    Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC; What is true about them?()

    • A、The two statements produce identical results.
    • B、The second statement returns a syntax error.
    • C、There is no need to specify DESC because the results are sorted in descending order by default.
    • D、The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.

    正确答案:A

  • 第17题:

    单选题
    What did U.S. Secretary of Agriculture do last week?
    A

    He banned McDonald from using meat from unhealthy cattle.

    B

    He stopped the selling of meat from unhealthy cattle.

    C

    He lost the trust from the public.

    D

    He issued a recall of the meat from unhealthy cattle sold last month.


    正确答案: A
    解析:
    录音结尾描述到上周美国农业部长采取的重大举措之一就是“ban the sale of meat from these animals”,其中these animals指的是上文提到的unhealthy cattle。
    【录音原文】
    The American beef industry is facing a long road to recovering the world’s trust. McDonald’s issued a press release about its longstanding policy against using unhealthy cattle, like the one implicated in last month’s recall. One of the biggest steps U.S. Secretary of Agriculture took last week was to ban the sale of meat from these animals.

  • 第18题:

    单选题
    It can be concluded from the passage that _____.
    A

    safety screens are of poor quality

    B

    working at a VDU for a long time is good for one’s health

    C

    more and more British offices will use word processors

    D

    British companies will need fewer and fewer managers


    正确答案: C
    解析:
    文章最后一段表明,尽管文字处理器有利有弊,但不管怎么说,它都代表着办公室工作的革命,因此它还是会不断普及。

  • 第19题:

    单选题
    Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary , hire_date FROM EMPLOYEESORDER BY 2 DESC; What is true about them?()
    A

    The two statements produce identical results.

    B

    The second statement returns a syntax error.

    C

    There is no need to specify DESC because the results are sorted in descending order by default.

    D

    The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.


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

  • 第20题:

    单选题
    Mrs. Green ______ in this university for more than 20 years when she retired from work last month.
    A

    has taught

    B

    had been teaching

    C

    has been teaching

    D

    had been taught


    正确答案: B
    解析:
    句意;当格林女士上个月退休时,她已经在这所大学教书超过20年了。当从句为一般过去时时,主句应为过去完成时,又因为主句中的teach为延续性动词,且从20多年前一直到上个月才停止,故主句应使用过去完成进行时,故B正确。

  • 第21题:

    多选题
    You need to generate a list of all customer last names with their credit limits from the CUSTOMERS table. Those customers who do not have a credit limit should appear last in the list. Which two queries would achieve the required result?()
    A

    SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit DESC

    B

    SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit

    C

    SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit NULLS LAST

    D

    SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_last_name, cust_credit_limit NULLSLAST


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

  • 第22题:

    单选题
    The EMP table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) DEPARTMENT_ID NUMBER (6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARTMENT_ID = NULL; What is true about this SQL statement ?()
    A

    The SQL statement displays the desired results.

    B

    The column in the WHERE clause should be changed to display the desired results.

    C

    The operator in the WHERE clause should be changed to display the desired results.

    D

    The WHERE clause should be changed to use an outer join to display the desired results.


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

  • 第23题:

    单选题
    Senior managers have the best views on how to save money.
    A

    Right.

    B

    Wrong.

    C

    Doesn’t say.


    正确答案: A
    解析:
    文中第五段提到“Your employees are in the best position to suggest ways of cutting costs”,可见本题“高级经理能提出节省开支的最好的见解”是错误的。