多选题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?（）ASELECT cust_

题目
多选题
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

相似考题

1.SECTION A MINI-LECTUREDirections: In this section you sill hear a mini-lecture. You will hear the lecture ONCE ONLY. While listening, take notes on the important points. Your notes will not be marked, but you will need them to complete a gap-filling task after the mini-lecture. When the lecture is over, you will be given two minutes to check your notes, and another ten minutes to complete the gap-filling task on ANSWER SHEET ONE. Use the blank sheet for note-taking.听力原文： Good morning, everyone. First about your second assignment. I'd like to remind you that your second assignment should be in by next Fri day. You can either put it in my pigeon hole, or leave it with the Department's secretary. Now, let's get down to the lecture.Today, the lecture is on credit, er, or to be more specific, on credit cards. I'm sure you must have heard of some credit cards, like the VI SA card, which is an internationally used card, or the Great Wall card issued by the Bank of China, In order to give a better understanding, we'll discuss it in some detail.Many businesses, such as department stores, restaurants, hotels and airline companies, use a credit system for selling their products and services. In a credit system, the seller agrees to sell something to the buyer without immediately receiving cash. He receives the goods or ser vices immediately and promises to pay for them later. This buy-now-pay later credit system is quite old.There are two types of credit cards. One type is issued directly by a store to a customer. Many large department stores issue credit cards to their customers. The store credit card can be used to make purchases only at a particular store. For example, if you have a credit card from Store A, then you can only buy things in that store. Other stores would not accept it. The other kind of credit card is issued by a credit company. Credit cards from credit companies can be used to buy things almost anywhere. If you have a major credit card, you can buy airplane tickets, stay at hotels and eat at restaurant with it. Most large credit companies are connected to large banks. So if you want a credit card from a credit company, you generally have to make an application at a bank. After an applicant receives a credit card, he or she can make purchases using thecard.The credit company sends the customer a statement of purchases at the end of each month. Generally the customer has to pay 25--50% of their credit hill every month. The customer pays directly to the credit company and the credit company pays to the store or hotel or restaurant.There are some advantages and some disadvantages to using credit cards. The biggest advantage for the consumer is expressed by the phrase "buy now, pay later". This means that the consumer can purchase what he wants when he wants it. There is no need to save up money in advance. Another advantage of having a credit card is that it protects the owner, ff a credit card is lost or stolen, the owner only has to call the credit company and the credit company will stop the credit card number. No one else can use it. So the owner doesn't have to worry about losing the card. Another advantage of the credit card system is that the consumer receives a record of his or her purchases. Every month the credit customer receives a bill. The bill has a list of all purchases from that month. This makes it easier to remember when and where purchases are made. And another advantage is that credit cards can be used when something unexpected happens. Many kinds of professional people—plumbers, taxidrivers, doctors and dentists—will accept credit cards in an emergency. This is very important if you don't have any cash with you.However, having said all that, using credit cards has one major disadvantage. That is, consumers tend to overspend their money. They spend more than they make. If a consumer buys a lot of th

2.Normally, banks will set different credit limits on different customers' credit card ac counts.A．RightB．WrongC．Doesn't say

3.听力原文：Credit card customers are given a credit limit on the credit card account.(8)A．Credit card customers are given a right to buy goods and services.B．The cardholder can buy goods and services within the credit limit.C．Normally, banks will set different credit lines to different groups of cardholders.D．Each month the cardholder receives a statement from the bank.

4.Angry customers tend to aim their dissatisfaction and complaints at staff members. If this happens to you, you should remember that they are actually expressing their dissatisfaction about the company and not about you as an individual. But if you wish to be successful in any business, then you have to learn how to handle angry customers. Listed below are a few guidelines to help you develop your own personal strategy for dealing with angry customers:Never argue back. You must stay calm and aim to satisfy the customer even in the most difficult situations. It is only by agreeing with their view point and suggesting a possible solution that you will resolve the situation and send the customer away happy.Use your ears more than your mouth. Make sure you listen more than you speak. By listening carefully, you will be able to understand why the customer is complaining, so that satisfactory steps can be taken.Show that you care: Use every opportunity to express your apology and understanding. You have to show that you will do everything within your power to try and resolve the situation. This exhibition of your concern will win the customer over. There will be a significant change in their behavior.Control your anger and be patient. Learn to relax and calm yourself. Having patience with your customers and with yourself will go a long way in winning over hostile customers.The above guidelines are very useful in helping you successfully tackle all kinds of difficult situations in life. If you follow them, you are on your way to succeeding in your career.21. Whom do angry customers tend to aim their dissatisfaction and complaints at?A. Staff members.B. Company managers.C. Those who accompany them.22. When a customer shouts rudely at you, you should().A. arg1e back and protect yourselfB. keep quiet and leave the customer aloneC. keep calm and listen carefully to the customer23. The underlined sentence “Use your ears more than your mouth” means().A. Your mouth is not more important for you than your ears.B. You should listen more than you speak.C. You should talk more than you listen.24. When dealing with an angry customer, which is NOT the right attitude?A. Be concerned.B. Be patient.C. Be amused.25. Which of the following statements is true according to the passage?A. When the customers complain, you neednt listen carefully.B. You neednt say sorry to those angry customers.C. You should relax yourself and try to understand the angry customers.

更多“多选题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?（）ASELECT cust_”相关问题

  • 第1题：

    You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address. The CUSTOMERS table has these columns:CUST_ID NUMBER(4) NOT NULLCUST_NAME VARCHAR2(100) NOT NULLCUST_ADDRESS VARCHAR2(150)CUST_PHONE VARCHAR2(20)Which SELECT statement accomplishes this task?（）

    A. SELECT* FROM customers;

    B. SELECT name, address FROM customers;

    C. SELECT id, name, address, phone FROM customers;

    D. SELECT cust_name, cust_address FROM customers;

    E. SELECT cust_id, cust_name, cust_address, cust_phone FROM customers;


    参考答案：D

  • 第2题：

    You are developing a page named Products.aspx in a Web application that contains three DropDownList controls that are dynamically loaded from a SQL Server 2005 database file. The DropDownList controls represent a vendor list, a certification list, and an exam list. Certkiller .com customers use the Products.aspx page to select exams related to particular certifications on offer from a particular vendor. A Go button initiates the selection. Each DropDownList control has an associated RequiredFieldValidator control.Whenever the customer selects a vendor, and the vendor offers certifications, then the customer must also select a certification if the. If the vendor only offers exams and not certifications, the certification list should remain hidden. Whenever the customer selects a certification, the customer must also select an exam. Validation error messages should only be displayed when the Go button is clicked. You need to set properties on the vendor DropDownList control.

    What should you do?（）


    参考答案：A

  • 第3题：

    资料：No credit，bad credit Hear the terms often enough and they can blur together.These credit statuses aren’t one and the same，though.
    Whether you have no credit or bad credit，one thing’s for sure：You don’t have good credit.And without good credit，you’ll face an uphill battle any time you apply for a loan or credit card.
    Potential lenders will want to know that you will almost certainly repay any money that you borrow.They likely won’t risk loaning money or extending credit to those whose creditworthiness is a big question mark or，worse，who have a track record of poor money management.
    If you fall into either of these categories，it’s smart to focus on raising your credit scores.
    If you have no credit score，you don’t have a credit history.If you have bad credit，it’s likely that you’ve mishandled credit in the past.And these two less-than-ideal credit standings require different solutions.
    If you fall in the no-credit category，you haven’t necessarily made any financial mistakes.In this case，a good way to start building that history is to acquire a credit card for people with no credit.Secured credit cards （which require a security deposit）or college student credit cards are typically the easiest to qualify for if you have no credit.A credit-builder loan can also help you establish credit.
    Bad credit can be a result of financial missteps，including missing payments，defaulting on loans，or having accounts sent to collections.If you fall into this category and need credit，you’ll need to look for a bad-credit credit card.A secured card or credit-builder loan is a good option in this situation，as well.You also may qualify for a bad-credit personal loan.If you still have open accounts，pay down the balances but don’t close credit accounts if you can avoid it.
    People with no credit are just starting to build their financial reputation，while those with bad credit are doing damage control.
    Moving from one of these less desirable situations to a good credit standing may use different tools，but the method is much the same： Make your payments on time and keep your debt low.It takes diligence and dedication，but it can be done.

    The solution（s） for Bad-credit could be______.

    A.having accounts sent to collections.
    B.looking for a no-credit credit card.
    C.paying down the balance.
    D.closing your credit accounts.

    答案：B
    解析：
    本题考查的是细节理解。
    【关键词】solution（s） for Bad-credit
    【主题句】倒数第3自然段Bad credit can be a result of financial missteps，including missing payments，defaulting on loans，or having accounts sent to collections.If you fall into this category and need credit，you’ll need to look for a bad-credit credit card.A secured card or credit-builder loan is a good option in this situation，as well.You also may qualify for a bad-credit personal loan.If you still have open accounts，pay down the balances but don’t close credit accounts if you can avoid it.不良信用可能是由于财务失误造成的，包括错过付款，拖欠贷款或账户被银行托收。如果您属于此类别且需要信用，您将需要查找信用不良的信用卡。在这种情况下，担保卡或信用建设者贷款也是一个不错的选择。您也可能有资格获得不良信用的个人贷款。如果您仍有未结账户，请即时支付余额，但如果可以避免，不要关闭信用账户。
    【解析】本题的问题是“不良信用的解决方案可能是_______”A选项“账户被银行托收”；B选项“寻找无信用的信用卡”；C选项“支付余额”；D选项“关闭您的信用账户”。根据题目中关键词找到主题句，A选项是导致不良信用的缘由，而非解决方案，故错误；B选项与题干“寻找信用不良的信用卡”相符，故正确；必须在有未结账户的前提下，选择支付余额，C选项缺少限制条件，故错误；D选项与题干“不要关闭信用账户”相矛盾，故错误。故选B。

  • 第4题：

    资料：No credit，bad credit Hear the terms often enough and they can blur together.These credit statuses aren’t one and the same，though.
    Whether you have no credit or bad credit，one thing’s for sure：You don’t have good credit.And without good credit，you’ll face an uphill battle any time you apply for a loan or credit card.
    Potential lenders will want to know that you will almost certainly repay any money that you borrow.They likely won’t risk loaning money or extending credit to those whose creditworthiness is a big question mark or，worse，who have a track record of poor money management.
    If you fall into either of these categories，it’s smart to focus on raising your credit scores.
    If you have no credit score，you don’t have a credit history.If you have bad credit，it’s likely that you’ve mishandled credit in the past.And these two less-than-ideal credit standings require different solutions.
    If you fall in the no-credit category，you haven’t necessarily made any financial mistakes.In this case，a good way to start building that history is to acquire a credit card for people with no credit.Secured credit cards （which require a security deposit）or college student credit cards are typically the easiest to qualify for if you have no credit.A credit-builder loan can also help you establish credit.
    Bad credit can be a result of financial missteps，including missing payments，defaulting on loans，or having accounts sent to collections.If you fall into this category and need credit，you’ll need to look for a bad-credit credit card.A secured card or credit-builder loan is a good option in this situation，as well.You also may qualify for a bad-credit personal loan.If you still have open accounts，pay down the balances but don’t close credit accounts if you can avoid it.
    People with no credit are just starting to build their financial reputation，while those with bad credit are doing damage control.
    Moving from one of these less desirable situations to a good credit standing may use different tools，but the method is much the same： Make your payments on time and keep your debt low.It takes diligence and dedication，but it can be done.

    How to establish credit if you fall into the no-credit category？

    A.To have a credit-builder loan
    B.To acquire secured credit cards（which require a security deposit） or college student credit cards
    C.To acquire a credit card
    D.All of above

    答案：D
    解析：
    本题考查的是细节理解。
    【关键词】establish credit；fall into the no-credit category
    【主题句】第6自然段If you fall in the no-credit category，you haven’t necessarily made any financial mistakes.In this case，a good way to start building that history is to acquire a credit card for people with no credit.Secured credit cards （which require a security deposit）or college student credit cards are typically the easiest to qualify for if you have no credit.A credit-builder loan can also help you establish credit.如果您属于无信用类别，则不一定是出现了什么财务问题。在这种情况下，对于无信用的人来言，创建信用记录的一种好方法是获取信用卡。如果您没有信用卡，通常最容易获得安全信用卡（需要保证金）或者大学生信用卡资格。信贷建设者贷款也可以帮助您建立信贷。
    【解析】本题的问题是“如果你属于无信用类别，如何建立信用？”A选项“获得信贷建设者贷款”；B选项“获得有担保的信用卡（需要保证金）或大学生信用卡”；C选项“获得信用卡”；D选项“以上皆是”。根据主题句，建立信贷可以通过拥有获得信用卡、安全信用卡（需要保证金）、大学生信用卡或者信贷建设者贷款方式，故选D。

  • 第5题：

    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

  • 第6题：

    The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager （RMAN） against your database： RMAN> REPORT OBSOLETE； What would you see in the output？（）

    • A、 a list of all those files that have been deleted in the last two days
    • B、 a list of all those files that have been recovered within the last two days
    • C、 a list of all the expired backups and copies
    • D、 a list of backups and copies that are outside the range covered by the current retention policy

    正确答案:D

  • 第7题：

    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%'

    正确答案:A

  • 第8题：

    You have 17GB of private files on drive D on your Windows 2000 Professional computer. You have shared the files as private_files. You do not want other users to see this share name in the browse list. You want all other share names to continue to appear in the browser list.  What should you do？ （）

    • A、Stop the computer browser service, and disable the startup state. 
    • B、Change the comment for the share to hidden:Yes 
    • C、Change the share name to private_files$. 
    • D、Add a hidden entry to the  HKLMSystem/currentcontrolset/services/larmanserver/shares/private_files registry value entry. 

    正确答案:C

  • 第9题：

    单选题
    Your company uses a SQL Server 2005 database. Customer data from your trading partners is imported into the Customers table every night. You need to ensure that the customer record is updated if it already exists in the Customers table. If the record does not exist, the data needs to be inserted into the Customers table. What should you do?（）
    A

     Create a FOR trigger. 

    B

     Create an INSTEAD OF trigger. 

    C

     Create an AFTER trigger. 

    D

     Create a DDL trigger.


    正确答案： D
    解析： 暂无解析

  • 第10题：

    单选题
    You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address. The CUSTOMERS table has these columns: CUST_ID NUMBER(4) NOT NULL CUST_NAME VARCHAR2(100) NOT NULL CUST_ADDRESS VARCHAR2(150) CUST_PHONE VARCHAR2(20) Which SELECT statement accomplishes this task?（）
    A

    SELECT* FROM customers;

    B

    SELECT name, address FROM customers;

    C

    SELECT id, name, address, phone FROM customers;

    D

    SELECT cust_name, cust_address FROM customers;

    E

    SELECT cust_id, cust_name, cust_address, cust_phone FROM customers;


    正确答案： E
    解析： 暂无解析

  • 第11题：

    单选题
    The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager （RMAN） against your database： RMAN> REPORT OBSOLETE； What would you see in the output？（）
    A

     a list of all those files that have been deleted in the last two days

    B

     a list of all those files that have been recovered within the last two days

    C

     a list of all the expired backups and copies

    D

     a list of backups and copies that are outside the range covered by the current retention policy


    正确答案： D
    解析： 暂无解析

  • 第12题：

    单选题
    You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address. The CUSTOMERS table has these columns: Which SELECT statement accomplishes this task?（）
    A

    SELECT*   FROM customers;

    B

    SELECT name, address   FROM customers;

    C

    SELECT id, name, address, phone   FROM customers;

    D

    SELECT cust_name, cust_address   FROM customers;

    E

    SELECT cust_id, cust_name, cust_address, cust_phone   FROM customers;


    正确答案： D
    解析： 暂无解析

  • 第13题：

    Background information

    B-Star is a theme park based on a popular series of children’s books. Customers pay a fixed fee to enter the park,where they can participate in a variety of activities such as riding roller-coasters, playing on slides and purchasing themed souvenirs from gift shops.

    The park is open all year and has been in operation for the last seven years. It is located in a country which has very little rainfall – the park is open-air so poor weather such as rain results in a significant fall in the number of customers for that day (normally by 50%). During the last seven years there have been on average 30 days each year with rain.

    B-Star is now very successful; customer numbers are increasing at approximately 15% each year.

    Ticket sales

    Customers purchase tickets to enter the theme park from ticket offices located outside the park. Tickets are only valid on the day of purchase. Adults and children are charged the same price for admission to the park. Tickets are preprinted and stored in each ticket office.

    Tickets are purchased using either cash or credit cards.

    Each ticket has a number comprising of two elements – two digits relating to the ticket office followed by six digits to identify the ticket. The last six digits are in ascending sequential order.

    Cash sales

    1. All ticket sales are recorded on a computer showing the amount of each sale and the number of tickets issued.

    This information is transferred electronically to the accounts office.

    2. Cash is collected regularly from each ticket office by two security guards. The cash is then counted by two

    accounts clerks and banked on a daily basis.

    3. The total cash from each ticket office is agreed to the sales information that has been transferred from each office.

    4. Total cash received is then recorded in the cash book, and then the general ledger.

    Credit card sales

    1. Payments by credit cards are authorised online as the customers purchase their tickets.

    2. Computers in each ticket office record the sales information which is transferred electronically to the accounts office.

    3. Credit card sales are recorded for each credit card company in a receivables ledger.

    4. When payment is received from the credit card companies, the accounts clerks agree the total sales values to the amounts received from the credit card companies, less the commission payable to those companies. The receivables ledger is updated with the payments received.

    You are now commencing the planning of the annual audit of B-Star. The date is 3 June 2009 and B-Star’s year end is 30 June 2009.

    Required:

    (a) List and explain the purpose of the main sections of an audit strategy document and for each section, provide an example relevant to B-Star. (8 marks)

    (b) (i) For the cash sales system of B-Star, identify the risks that could affect the assertion of completeness of sales and cash receipts; (4 marks)

    (ii) Discuss the extent to which tests of controls and substantive procedures could be used to confirm the

    assertion of completeness of income in B-Star. (6 marks)

    (c) (i) List the substantive analytical procedures that may be used to give assurance on the total income from

    ticket sales for one day in B-Star;

    (ii) List the substantive analytical procedures that may be used to give assurance on the total income from

    ticket sales in B-Star for the year. (8 marks)

    (d) List the audit procedures you should perform. on the credit card receivables balance. (4 marks)


    正确答案：
    (b)(i)Riskaffectingcompleteness–Thecomputersystemdoesnotrecordsalesaccuratelyand/orinformationislostortransferredincorrectlyfromtheticketofficecomputertotheaccountsdepartmentcomputer.–Cashsalesarenotrecordedinthecashbook;cashisstolenbytheaccountsclerks.–Ticketsareissuedbutnopaymentisreceived–thatisthesaleisnotrecorded.–Cashisremovedbytheticketofficepersonnel,bythesecurityguardsorbytheaccountclerks.–Theaccountclerksmiscounttheamountofcashreceivedfromaticketoffice.(ii)UseoftestsofcontrolsandsubstantiveproceduresTestsofcontrolsTestsofcontrolaredesignedtoensurethatdocumentedcontrolsareoperatingeffectively.Ifcontrolsoverthecompletenessofincomewereexpectedtooperatecorrectly,thentheauditorwouldtestthosecontrols.InB-Star,whilecontrolscouldbeinoperation,e.g.theaccountclerksagreeingphysicalcashtocomputersummaries,thereisnoindicationthatthecontrolisdocumented;thatisthecomputersummaryisnotsignedtoshowthecomparisonhastakenplace.Theauditorcouldusethetestofinquiry–askingtheclerkswhetherthecontrolhasbeenused,andobservation–actuallywatchingtheclerkscarryoutthecontrols.Asnotedabovethough,lackofdocumentationofthecontroldoesmeanrelyingontestsofcontrolfortheassertioncompletenessofincomehaslimitedvalue.SubstantiveproceduresSubstantiveproceduresincludeanalyticalproceduresandotherprocedures.Analyticalproceduresincludetheanalysisofsignificantratiosandtrendsandsubsequentinvestigationofanytrendsorrelationshipsthatappeartobeabnormal.TheseprocedurescanbeusedeffectivelyinB-Starasanapproximationofincomethatcanbeobtainedfromsourcesotherthanthecashreceiptrecords.Otherprocedures,ortestsofdetail,arenormallyusedtoverifystatementoffinancialpositionassertionsandincludeobtainingauditevidencerelevanttospecificassertions.However,theycouldbeusedinB-Startotraceindividualtransactionsthroughthesales/cashsystemstoensureallticketsaleshavebeenrecorded(completenessassertion).Theuseofotherprocedureswillbetimeconsuming.(c)(i)Substantiveanalyticalprocedures–completenessofincomeforoneday–Obtainproofintotal.Ticketssoldtimespriceshouldequalday’sincome.–Comparedailysalestobudgeteddailysales(forexampleweekendsandbankholidayswouldexpectmoreincome).–Comparesaleswithpreviousdaysandaccountforchangessuchasvariationsforweather.–Comparesalestosouvenirssales(morepeopleinparkmeansmoresouvenirsales).–Compareticketofficesday-by-dayandstaffrotationtoseeifsaleslowersomeday/somestaff(attempttoidentifyfraudalso).–Comparetheexpectedsalesfromticketnumberstothetotalsalesamountfromcashandcreditsalesforeachticketoffice.(ii)Substantiveanalyticalprocedures–completenessofincomefortheyear–Obtainthesalesincomefromthepreviousyear.Multiplythisby115%toprovidearoughestimateoftheincomeforthisyear.–Obtaininformationonthenumberofdayswithrainduringthelastyear.Wherethisismoreorlessthan30,adjusttheincomeestimateby1/730downforeachdayofrainabove30or1/730upforeachdayofrainlessthan30.(Note:B-Staronlyattracts50%ofthenormalnumberofcustomersonarainyday;henceonedayofraindecreasestotalcustomersby1/730intheyear.)–Compareactualincometobudgetedincomefortheyear.Askthedirectorstoexplainanysignificantdeviations.–Obtainindustryinformationonthepopularityofthemeparks,andchangeincustomernumbers.ComparethesetrendstotheresultsobtainedbyB-Star.WhereB-Starperformedsignificantlybetterorworsethanaverage,obtainexplanationsfromthedirectors.(d)Auditofyearendcreditcardreceivable–Agreethebalancesoneachcreditcardcompany’sledgeraccounttothelistofreceivables.–Castthelistofreceivablesandagreethetotaltothetotalonthereceivablesledgercontrolaccount.–Forthelastdayofthefinancialyearandthefirstdayofthenewfinancialyear,agreetotalsalesincomefromticketofficerecordstothecashbookandreceivablesledgerensuringtheyarerecordedinthecorrectperiod.Forasampleofmaterialbalancesandarandomsampleofimmaterialitems,–ObtaindirectconfirmationfromthecreditcardcompanyoftheamountduetoB-Starusingareceivablesconfirmationletter.–Wheredirectconfirmationisnotpossible,obtainevidenceofcashreceiptaftertheendofthefinancialyear.AgreetheamountonthebankstatementspostyearendofB-Startotheamountdueinthereceivablesledger(lessanycommissiondue).–Reviewafterdatesalesdaybookfordebitnotesindicatingthatsalesmayhavebeenoverstatedintheprioryear.–ObtainthefinancialstatementsofB-Starandensurethatthereceivablesamountisdisclosedasacurrentassetnetofcommissionduetothecreditcardcompanies.

  • 第14题：

    资料：No credit，bad credit Hear the terms often enough and they can blur together.These credit statuses aren’t one and the same，though.
    Whether you have no credit or bad credit，one thing’s for sure：You don’t have good credit.And without good credit，you’ll face an uphill battle any time you apply for a loan or credit card.
    Potential lenders will want to know that you will almost certainly repay any money that you borrow.They likely won’t risk loaning money or extending credit to those whose creditworthiness is a big question mark or，worse，who have a track record of poor money management.
    If you fall into either of these categories，it’s smart to focus on raising your credit scores.
    If you have no credit score，you don’t have a credit history.If you have bad credit，it’s likely that you’ve mishandled credit in the past.And these two less-than-ideal credit standings require different solutions.
    If you fall in the no-credit category，you haven’t necessarily made any financial mistakes.In this case，a good way to start building that history is to acquire a credit card for people with no credit.Secured credit cards （which require a security deposit）or college student credit cards are typically the easiest to qualify for if you have no credit.A credit-builder loan can also help you establish credit.
    Bad credit can be a result of financial missteps，including missing payments，defaulting on loans，or having accounts sent to collections.If you fall into this category and need credit，you’ll need to look for a bad-credit credit card.A secured card or credit-builder loan is a good option in this situation，as well.You also may qualify for a bad-credit personal loan.If you still have open accounts，pay down the balances but don’t close credit accounts if you can avoid it.
    People with no credit are just starting to build their financial reputation，while those with bad credit are doing damage control.
    Moving from one of these less desirable situations to a good credit standing may use different tools，but the method is much the same： Make your payments on time and keep your debt low.It takes diligence and dedication，but it can be done.

    The main purpose of the passage is to______.

    A.teach people how to have credit accounts
    B.suggest ways for people to keep good credit record
    C.present a concern about people’s bad credit nowadays
    D.explain the differences between no-credit and bad credit

    答案：D
    解析：
    本题考查的是主旨大意。
    【关键词】main purpose
    【主题句】第1自然段No credit，bad credit Hear the terms often enough and they can blur together.These credit statuses aren’t one and the same，though.经常听到无信用、不良信用这些术语，它们之间容易混淆，但这些信用状态并不是一回事。
    【解析】本题的问题是“该段落的主要目的是_______”。A选项“教人们如何拥有信用账户”；B选项“推荐人们保持良好信用记录的方式”；C选项“表达对现在人们不良信用的关注”；D选项“解释无信用和不良信用之间的差异”。通读全文，文章开头引出无信用和不良信用这两种信用状态，之后分别进行解释，并给予改善信用状态的措施和方法，故D选项更符合题意。

  • 第15题：

    资料：No credit，bad credit Hear the terms often enough and they can blur together.These credit statuses aren’t one and the same，though.
    Whether you have no credit or bad credit，one thing’s for sure：You don’t have good credit.And without good credit，you’ll face an uphill battle any time you apply for a loan or credit card.
    Potential lenders will want to know that you will almost certainly repay any money that you borrow.They likely won’t risk loaning money or extending credit to those whose creditworthiness is a big question mark or，worse，who have a track record of poor money management.
    If you fall into either of these categories，it’s smart to focus on raising your credit scores.
    If you have no credit score，you don’t have a credit history.If you have bad credit，it’s likely that you’ve mishandled credit in the past.And these two less-than-ideal credit standings require different solutions.
    If you fall in the no-credit category，you haven’t necessarily made any financial mistakes.In this case，a good way to start building that history is to acquire a credit card for people with no credit.Secured credit cards （which require a security deposit）or college student credit cards are typically the easiest to qualify for if you have no credit.A credit-builder loan can also help you establish credit.
    Bad credit can be a result of financial missteps，including missing payments，defaulting on loans，or having accounts sent to collections.If you fall into this category and need credit，you’ll need to look for a bad-credit credit card.A secured card or credit-builder loan is a good option in this situation，as well.You also may qualify for a bad-credit personal loan.If you still have open accounts，pay down the balances but don’t close credit accounts if you can avoid it.
    People with no credit are just starting to build their financial reputation，while those with bad credit are doing damage control.
    Moving from one of these less desirable situations to a good credit standing may use different tools，but the method is much the same： Make your payments on time and keep your debt low.It takes diligence and dedication，but it can be done.

    It can be inferred that the potential lenders______

    A.will probably loan money bad-credit people as they still have open accounts.
    B.will probably loan money no-credit people as they haven’t made any financial mistakes.
    C.won’t risk loaning money or extending credit to no-credit person or bad-credit person.
    D.None of above

    答案：C
    解析：
    本题考查的是推理判断。
    【关键词】inferred；potential lenders
    【主题句】第3自然段Potential lenders will want to know that you will almost certainly repay any money that you borrow.They likely won’t risk loaning money or extending credit to those whose creditworthiness is a big question mark or，worse，who have a track record of poor money management.潜在的贷款人会想知道你确定会偿还你所借的款项。他们应该不会冒险借钱或将信贷扩展到信誉度可疑的人，或者更糟糕的是，有不良的资金管理记录的人。
    【解析】本题的问题是“可以推断出潜在的贷款人，_______”。A选项“因为他们仍有开户，可能会向坏账信贷人员贷款”；B选项“由于没有出现任何经济上的错误，他们可能会向没有信贷的人贷款”；C选项“不会冒险借款，或向无信贷人或不良信用人提供信贷”；D选项“以上皆不”。根据题目中关键词找到主题句，贷款人不会冒险贷款，故选C。

  • 第16题：

    资料：No credit，bad credit Hear the terms often enough and they can blur together.These credit statuses aren’t one and the same，though.
    Whether you have no credit or bad credit，one thing’s for sure：You don’t have good credit.And without good credit，you’ll face an uphill battle any time you apply for a loan or credit card.
    Potential lenders will want to know that you will almost certainly repay any money that you borrow.They likely won’t risk loaning money or extending credit to those whose creditworthiness is a big question mark or，worse，who have a track record of poor money management.
    If you fall into either of these categories，it’s smart to focus on raising your credit scores.
    If you have no credit score，you don’t have a credit history.If you have bad credit，it’s likely that you’ve mishandled credit in the past.And these two less-than-ideal credit standings require different solutions.
    If you fall in the no-credit category，you haven’t necessarily made any financial mistakes.In this case，a good way to start building that history is to acquire a credit card for people with no credit.Secured credit cards （which require a security deposit）or college student credit cards are typically the easiest to qualify for if you have no credit.A credit-builder loan can also help you establish credit.
    Bad credit can be a result of financial missteps，including missing payments，defaulting on loans，or having accounts sent to collections.If you fall into this category and need credit，you’ll need to look for a bad-credit credit card.A secured card or credit-builder loan is a good option in this situation，as well.You also may qualify for a bad-credit personal loan.If you still have open accounts，pay down the balances but don’t close credit accounts if you can avoid it.
    People with no credit are just starting to build their financial reputation，while those with bad credit are doing damage control.
    Moving from one of these less desirable situations to a good credit standing may use different tools，but the method is much the same： Make your payments on time and keep your debt low.It takes diligence and dedication，but it can be done.

    Which topic has not been covered in the passage？

    A.Next steps to take for people in different categories
    B.How no credit and bad credit are different
    C.How no credit and bad credit are similar
    D.All the above have been discussed in the passage

    答案：D
    解析：
    本题考查的是细节理解。
    【关键词】topic；not been covered
    【主题句】第1自然段No credit，bad credit Hear the terms often enough and they can blur together.These credit statuses aren’t one and the same，though.经常听到无信用、不良信用这些术语，它们之间很容易混淆，但这些信用状态并不是一回事。
    第2自然段Whether you have no credit or bad credit，one thing’s for sure：You don’t have good credit.And without good credit，you’ll face an uphill battle any time you apply for a loan or credit card.无论您没有信用还是信用不良，有一件事是肯定的——您没有良好的信誉。没有良好的信誉，您在申请贷款或信用卡时都势必要打一场硬战。
    第6自然段If you fall in the no-credit category，you haven’t necessarily made any financial mistakes.In this case，a good way to start building that history is to acquire a credit card for people with no credit.如果您属于无信用类别，则不一定是出现了什么财务问题。在这种情况下，对于无信用的人而言，创建信用记录的一种好方法是获取信用卡。
    第7自然段If you fall into this category and need credit，you’ll need to look for a bad-credit credit card.如果您属于此类别且需要信用，则需要查找不良信用的信用卡。
    【解析】本题的问题是“文章中没有涉及哪个主题？”A选项“为不同信用类别的人们提供后续步骤”；B选项“没有信用和不良信用是不同的”；C选项“没有信用和不良信用是相似的”；D选项“以上所有内容已在文章中讨论过”。通读全文，作者在开头提出无信用和不良信用虽然易混，但是截然不同，并具体阐释两者共通之处和相互差异。之后，给予两种不同信用状态用户相应的解决措施和方法，因而选项A、B、C文章都谈论到，故选D。

  • 第17题：

    Which of the following is a typical data warehouse query?（）

    • A、What is this customers address?
    • B、Does this customer have any unpaid bills?
    • C、What is the balance in this customers account?
    • D、What are the total sales for each of the last 6 months?

    正确答案:D

  • 第18题：

    The details of the order ID， order date， order total， and customer ID are obtained from the ORDERS table. If the order value is more than 30000， the details have to be added to the LARGEjDRDERS table. The order ID， order date， and order total should be added to the ORDERJHISTORY table， and order ID and customer ID should be added to the CUSTJHISTORY table.   Which multitable INSERT statement would you use？ （）

    • A、 Pivoting INSERT
    • B、 Unconditional INSERT
    • C、 Conditional ALL INSERT
    • D、 Conditional FIRST INSERT

    正确答案:C

  • 第19题：

    From the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries.  You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message.  Which method would you follow to achieve this？（）

    • A、set the CPU time per call in the users profile
    • B、set the CPU time per session in the users profiles
    • C、set the CPU levels for the users’ group using Resource Manager
    • D、set the TIMED_STATISTICS parameter to TRUE in the parameter file

    正确答案:C

  • 第20题：

    Your company uses a SQL Server 2005 database. Customer data from your trading partners is imported into the Customers table every night. You need to ensure that the customer record is updated if it already exists in the Customers table. If the record does not exist, the data needs to be inserted into the Customers table. What should you do?（）

    • A、 Create a FOR trigger. 
    • B、 Create an INSTEAD OF trigger. 
    • C、 Create an AFTER trigger. 
    • D、 Create a DDL trigger.

    正确答案:B

  • 第21题：

    单选题
    You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address. The CUSTOMERS table has these columns: CUST_ID NUMBER(4) NOT NULL CUST_NAME VARCHAR2(100) NOT NULL CUST_ADDRESS VARCHAR2(150) CUST_PHONE VARCHAR2(20) Which SELECT statement accomplishes this task?（）
    A

    SELECT* FROM customers;

    B

    SELECT name, address FROM customers;

    C

    SELECT id, name, address, phone FROM customers;

    D

    SELECT cust_name, cust_address FROM customers;

    E

    SELECT cust_id, cust_name, cust_address, cust_phone FROM customers;


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

  • 第22题：

    单选题
    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%'


    正确答案： D
    解析： 暂无解析

  • 第23题：

    多选题
    TestKing.com uses a SQL Server 2005 database. This database contains a trigger named trg InsertOrders， which fires when order data is inserted into the Orders table. The trigger is responsible for ensuring that a customer exists in the Customers table before data is inserted into the Orders table. You need to configure the trigger to prevent it from firing during the data import process. You must accomplish this goal while using the least amount of administrative effort. Which two Transact-SQL statements can you use to achieve this goal？（）
    A

    ALTER TABLE OrdersDISABLE TRIGGER trg InsertOrders

    B

    DROP TRIGGER trg InsertOrders

    C

    DISABLE TRIGGER trg InsertOrders ON Orders

    D

    ALTER TRIGGER trg InsertOrders ON Orders NOT FOR REPLICATION


    正确答案： B,A
    解析： 暂无解析

  • 第24题：

    多选题
    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


    正确答案： A,B
    解析： 暂无解析

相关内容