Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns: LAST NAME VARCNAR2(35) NOT NULL SALARY NUMBER(9,2) NOT NULL COMMISION_PCT NUMBER(4,2) Which statement ensures that a value is displayed in the calculated columns for all employees?（）A、SELECT last_name, 12*salary* commission_pct FROM emp;B、SELECT last_name, 12*salary* (commission_pct,0) FROM emp;C、SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;D、SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;
Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns: LAST NAME VARCNAR2(35) NOT NULL SALARY NUMBER(9,2) NOT NULL COMMISION_PCT NUMBER(4,2) Which statement ensures that a value is displayed in the calculated columns for all employees?（）
- A、SELECT last_name, 12*salary* commission_pct FROM emp;
- B、SELECT last_name, 12*salary* (commission_pct,0) FROM emp;
- C、SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;
- D、SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;
相关考题：
(c) You have been making preliminary inquiries regarding matters arising from the previous year’s audit of Di Rollo.It has been revealed that no action has been taken in response to the management letter prepared by the previousauditors. Di Rollo’s management has explained that this was because it was ‘poorly prepared’ and ‘unhelpful’.Required:Briefly describe various criteria against which the effectiveness of a management letter may be assessed.(7 marks)
A new internal auditor, Daisy Rosepetal, has recently joined Bluebell Co. She has been asked by management toestablish and to monitor a variety of social and environmental Key Performance Indicators (KPIs). Daisy has noexperience in this area, and has asked you for some advice. It has been agreed with Bluebell Co’s audit committeethat you are to provide guidance to Daisy to help her in this part of her role, and that this does not impair theobjectivity of the audit.(c) Recommend EIGHT KPIs which could be used to monitor Bluebell Co’s social and environmentalperformance, and outline the nature of evidence that should be available to provide assurance on theaccuracy of the KPIs recommended. Your answer should be in the form. of briefing notes to be used at ameeting with Daisy Rosepetal. (10 marks)Note: requirement (c) includes 2 professional marks.
Certkiller .com has asked you to create a file management application to monitor the hosts file.Certkiller .com has instructed you to change the hosts file if it has been changed.You, therefore, need to display the size and whether the hosts file is set to read-only.What should you do?（）A.B.C.D.
Certkiller.com has asked you to create an application to display all of the top directories based on the drive path.You need to ensure that the application displays the number of files within top-level directories.What should you do?（）A.B.C.D.
The network administrator has asked you to check the status of the workstation’s IP stack by pinging the loopback address.Which address would you ping to perform this task?() A.10.1.1.1B.127.0.0.1C.192.168.0.1D.239.1.1.1
Mary has just called and asked__to have lunch with her tomorrow.A.you and IB.you and meC.I and youD.me and you
The network administrator has asked you to check the status of the workstation’s IP stack by pinging the loopback address.Which address would you ping to perform this task？（）A、10.1.1.1B、127.0.0.1C、192.168.0.1D、239.1.1.1
You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）A、Database ControlB、Management ServerC、Management RepositoryD、Application Server ControlE、Oracle Management Agent
Your company has a domain with multiple sites. You have a domain-based DFS namespace called contoso.com Management. The contoso.com Management namespace hierachy is updated frequently.You need to configure the contoso.com/Management namespace to reduce the workload of the PDC emulator. What should you do？ （）A、 Enable the Optimize for scalibity optionB、 Enable the optimize for consistency optionC、 Set the Ordering method option to Lowest costD、 Set the Ordering method option to Random order
A customer reports the optical drive is no longer responding. Which of the following questionsshould be asked FIRST?（）A、“Did you log in with an administrator account?”B、“Have you been to any inappropriate websites?”C、“What have you changed since the optical drive worked properly?”D、“What has changed since the optical drive worked properly?”
You work as the Exchange administrator at Company.com.The Company.com network contains an Exchange Server 2010 Organization.Company.com has its headquarters in London where you are located.During the course of the day you receive notification from management to view the a number of mailbox on the servers that is bigger than 1 GB.What should you do？（）A、You should consider having the properties of the mailbox database viewed from the Exchange Management Console （EMC）.B、You should consider running the Get-Mailbox cmdlet from the Exchange Management Shell.C、You should consider running the Get-MailboxStatistics cmdlet from the Exchange Management Shell.D、You should consider having a recipient filter created from the Exchange Management Console （EMC）.
You work as the exchange administrator at company.com.the company.com network contains an exchange server 2010 organization.company.com has its headquarters in london where you are located.during the course of the day you receive notification from management to view the number of mailboxes on the servers that exceeds 1 gb in size.what should you do？（）A、you should consider having the properties of the mailbox database viewed using the exchange management console （emc）.B、you should consider running the get-mailbox cmdlet using the exchange management shell.C、you should consider running the get-mail box statistics cmdlet using the exchange management shell.D、you should consider having a send- and a recipient filter created using the exchange management console （emc）.
You work as an administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. All servers in the ABC.com domain， including domain controllers， have Windows Server 2012 R2 installed.ABC.com has a server， named ABC-SR15， which is configured as a file server. You have received instructions to make sure that a user， named Mia Hamm， has the ability to generate a complete backup of ABC-SR15 via Windows Server Backup. Which of the following actions should you take？（）A、You should consider making use of Computer Management to configure the local groups.B、You should consider making use of Computer Management to configure the domain local groups.C、You should consider making use of Computer Management to configure the global groups.D、You should consider making use of Computer Management to configure the administrator groups.
You work as the exchange administrator at TestKing.com. The TestKing.com network contains an Exchange Server 2010 Organization. TestKing.com has its headquarters in Stockholm where you arelocated. The TestKing.com network contains a Hub Transport server that has anti-spam agents installed. Youreceive instruction from management to assign the administration of the Exchange 201 organization to agroup named KingSecruity. To ensure productivity you need to make sure that users belonging to thisgroup are able to manage anti-spam setting in the organization. You should thus ensure that your solutionreduces the number of permissions that are assigned to KingSecurity. What should you do？（）A、You should consider assigning the Organization Management role group.B、You should consider assigning the Server Management role group.C、You should consider assigning the Hygiene Management role group.D、You should consider assigning the Records Management role group.
You work as the exchange administrator at TestKing.com. The TestKing.com network contains an Exchange Server 2010 Organization. TestKing.com has its headquarters in Stockholm where you are located.The TestKing.com network contains a database availability group （DAG）. You receive an instruction fromthe management to devise a Mailbox database security solution for the organization. Management wantsthe read/write performance to be maximized as well as ensuring that any access to the database isprohibited in the event of theft. What should you do？（）A、You should recommend that management make use of DAG network encryption.B、You should recommend that management make use of Encrypted File System （EFS）C、You should recommend that management make use of Windows BitLocker Drive Encryption.D、You should recommend that management make use of Rights Management Service RMS.
You work as the enterprise exchange administrator at Xxx .The Xxx network consists of a domain named xxx .The Xxx network has a client computer named XXX-WS662 that has Microsoft Windows 7 installed.How can you proceed with the deployment of management tools for Exchange 2010 on XXX-EX02？（）A、You should run the Test-ServiceHealth cmdlet.B、You should deploy Microsoft .NET Framework 3.5.1.C、You should run the ACLDIAG and the scanforfeature command.D、You should deploy Internet Information Services （IIS） 6.0 Management console.E、You should run the wuauclt.exe /detectnow command.
单选题You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）ADatabase ControlBManagement ServerCManagement RepositoryDApplication Server ControlEOracle Management Agent
单选题2010 Server has Message Tracking enabled.You need to modify storage location of message tracking logs.What should you do？（）AFrom the Shell Management Console apply Set-EventLogLevel cmdletBFrom the Shell Management Console apply Set-TransportConfig cmdletCFrom the Exchange Management Console （EMC） modify properties of Mailbox DatabaseDFrom the Exchange Management Console （EMC） modify properties of Hub Transport Server object
问答题Practice 3 ● You are the Director of the Training Department. The CEO asked you to prepare a proposal for the company in-house course for the management discussion. ● Write 200—250 words.
问答题Practice 4 ● Your manager is keen to improve work efficiency among the staff. He has asked you to introduce to your fellow staff members practices to improve time management. ● Write the report for your manager, including the following information: ● the importance of planning work time effectively, ● practices to improve time management, ● steps to follow in carrying out the practices.
问答题Practice 5 ● Your colleague, Tom Miller has asked you for help with a report on current market situation, but you cannot help at the moment. ● Write an e-mail to Tom: ● Explaining why you cannot help him; ● Recommending another person; ● Telling what relevant experience that person has. ● Write 30—40words.
问答题Practice 6 Discussion—about 5 minutes In this part of the test you are given a discussion topic. You have 30 seconds to look at the prompt card, an example of which is below, and then about 3 minutes to discuss the topic with your partner. After that the examiner will ask you more questions related to the topic. Time Management Your company has found that ineffective time management is one of the major problem areas throughout the workforce. You have been asked to put forward some suggestions for improving the situation. Discuss, and decide together: ● Why poor time management can become a major problem in companies ● What procedures could be adopted to ensure that time is managed effectively.
单选题The network administrator has asked you to check the status of the workstation’s IP stack by pinging the loopback address.Which address would you ping to perform this task？（）A10.1.1.1B127.0.0.1C192.168.0.1D239.1.1.1
问答题Practice 1 Discussion—about 5 minutes In this part of the test you are given a discussion topic. You have 30 seconds to look at the prompt card, an example of which is below, and then about 3 minutes to discuss the topic with your partner. After that the examiner will ask you more questions related to the topic. For two candidates Program for New Staff Your company has found that ineffective time management is one of the major problem areas throughout the workforce. You have been asked to put forward some suggestions for improving the situation. Discuss and decide together: ● why poor time management can become a major problem in companies. ● what procedures could be adopted to ensure that time is managed effectively.
单选题You work as the exchange administrator at TestKing.com. The TestKing.com network contains an Exchange Server 2010 Organization. TestKing.com has its headquarters in Stockholm where you arelocated. The TestKing.com network contains a Hub Transport server that has anti-spam agents installed. Youreceive instruction from management to assign the administration of the Exchange 201 organization to agroup named KingSecruity. To ensure productivity you need to make sure that users belonging to thisgroup are able to manage anti-spam setting in the organization. You should thus ensure that your solutionreduces the number of permissions that are assigned to KingSecurity. What should you do？（）AYou should consider assigning the Organization Management role group.BYou should consider assigning the Server Management role group.CYou should consider assigning the Hygiene Management role group.DYou should consider assigning the Records Management role group.
问答题Practice 2 ● Your manager is considering fostering team spirit among the staff. He has asked you to write a report concerning this. ● Write the report for your manager, including the following information: ● the current state of teamwork among co-workers, ● the importance of teamwork for the effective management, ● the practices that could foster team spirit, ● write 200-250 words.
问答题Practice 8 ● You are the Director of the Human Resources Department. The CEO has asked you to prepare a proposal on how to turn classroom training into workplace learning for the management discussion. ● Write the proposal explaining how to turn the classroom training into workplace learning. ● In your proposal, you need to: ● refer to the importance of turning professional training into workplace learning, ● summarize the key factors in effective learning cycle such as goals, practice, and application, etc. ● Write 200-250 words on the separate answer paper provided.
问答题Practice 7 ● Your company has planned three training courses：Foreign Language Development, Changes in Technology, Management Skills. ● You have been asked to write a report, recommending the course you think would be most useful for people who do the same kind of job as you. ● Write the report, saying which course you have chosen. ● Explain why you feel it would be the most useful and why the others are not so suitable. ● Write 200-250 words on your Answer Sheet．