多选题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_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit DESCBSELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limitCSELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit NULLS LASTDSELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_last_name, cust_credit_limit NULLSLAST
多选题
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
参考解析
解析：
暂无解析
相关考题：
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
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.
Normally, banks will set different credit limits on different customers' credit card ac counts.A．RightB．WrongC．Doesn't say
听力原文：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.
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;
Background informationB-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 salesCustomers 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 sales1. 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 twoaccounts 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 sales1. 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 theassertion 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 fromticket sales for one day in B-Star;(ii) List the substantive analytical procedures that may be used to give assurance on the total income fromticket 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)
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?（）
资料：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 accountsB.suggest ways for people to keep good credit recordC.present a concern about people’s bad credit nowadaysD.explain the differences between no-credit and bad credit
资料：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.
资料：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
资料：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 loanB.To acquire secured credit cards（which require a security deposit） or college student credit cardsC.To acquire a credit cardD.All of above
资料：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 categoriesB.How no credit and bad credit are differentC.How no credit and bad credit are similarD.All the above have been discussed in the passage
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 DESCB、SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limitC、SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit NULLS LASTD、SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_last_name, cust_credit_limit NULLSLAST
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?
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 daysB、 a list of all those files that have been recovered within the last two daysC、 a list of all the expired backups and copiesD、 a list of backups and copies that are outside the range covered by the current retention policy
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 INSERTB、 Unconditional INSERTC、 Conditional ALL INSERTD、 Conditional FIRST INSERT
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%'
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 profileB、set the CPU time per session in the users profilesC、set the CPU levels for the users’ group using Resource ManagerD、set the TIMED_STATISTICS parameter to TRUE in the parameter file
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.
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.
单选题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.
单选题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?（）ASELECT* FROM customers;BSELECT name, address FROM customers;CSELECT id, name, address, phone FROM customers;DSELECT cust_name, cust_address FROM customers;ESELECT cust_id, cust_name, cust_address, cust_phone FROM customers;
单选题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?（）ASELECT* FROM customers;BSELECT name, address FROM customers;CSELECT id, name, address, phone FROM customers;DSELECT cust_name, cust_address FROM customers;ESELECT cust_id, cust_name, cust_address, cust_phone FROM customers;
单选题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? （）ASELECT last_name FROM EMP WHERE last_ name LIKE '_A%';BSELECT last_name FROM EMP WHERE last name ='*A%'CSELECT last_name FROM EMP WHERE last name ='_A%';DSELECT last_name FROM EMP WHERE last name LIKE '*A%'
单选题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 daysB a list of all those files that have been recovered within the last two daysC a list of all the expired backups and copiesD a list of backups and copies that are outside the range covered by the current retention policy
多选题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？（）AALTER TABLE OrdersDISABLE TRIGGER trg InsertOrdersBDROP TRIGGER trg InsertOrdersCDISABLE TRIGGER trg InsertOrders ON OrdersDALTER TRIGGER trg InsertOrders ON Orders NOT FOR REPLICATION
单选题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;
多选题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_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit DESCBSELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limitCSELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit NULLS LASTDSELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_last_name, cust_credit_limit NULLSLAST