Description : In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. -Technology
Last Answer : (i)Acc_No, Cust_Phone(ii)All the columns having capability to become Primary Key are known as Candidate Keys.(iii)Acc_No(iv)Trans_Id
Description : In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. Write a query to display customer’s name who has -Technology
Last Answer : (i) Select cust_name from customer c,transaction t where c.Acc_No=t.Acc_No and Transaction_Type= 'Debit';(ii)Select cust_name, t.* from customer c, transaction t where c.Acc_No=t.Acc_No;(iii) ... total amount of all type of transactions, it will only display the total of credit transactions only.
Description : Speedy Bike Company received a $940 check from a customer for the balance due. The transaction was erroneously recorded as a debit to Cash $490 and a credit to Service Revenue $490. The ... Receivable, $940. d. debit Accounts Receivable, $940; credit Cash, $450 and Service Revenue, $490.
Last Answer : c. debit Cash, $450 and Service Revenue, $490; credit Accounts Receivable, $940.
Description : Consider the following database: Product Code Product Name Date of sale QtySold Customer Name Amount -Technology
Last Answer : 1. Qty Sold and Amount fields2. ProductCode field3. Date/Time data type4. ProductCode, ProductName and CustomerName fields5. 6 fields and 5 records6. Validation Rule
Description : Ms. Pari, a beginner in SQL is not able to understand the meaning of “Cancelling a Transaction”. Help her in understanding the same. -Technology
Last Answer : Cancelling a transaction means rolls the transaction to the beginning. It aborts any changes made during the transaction and the state of database is returned to what it was before the transaction began to execute.Rollback command is used for the same.
Description : Ms. Sita trying to log into your Internet Banking account for online transaction activity. However, as strange as it may seem, -Technology
Last Answer : I. (i)Source code is available.(ii) Money need not to be paid for procuring the license for usage and further distribution.II. She could be under a DoS attack!She should deploy an ... into her network if not already done. This helps in restricting the bandwidth usage to authenticated users only.
Description : How do you tell the system that a transaction is beginning -Technology
Last Answer : When a transaction begins, Oracle Database assigns the transaction to an available undo data segment to record the undo entities for the new transaction. A transaction ID is not allocated until an ... ID is unique to a transaction and represents the undo segment number, slot and sequence number.
Description : Write a query to display customer’s name along with their transaction details. -Technology
Last Answer : Select cust_name, t.* from customer c, transaction t where c.Acc_No=t.Acc_No;
Description : Write a query to display customer’s name who have not done any transaction yet. -Technology
Last Answer : Select cust_name from customer c,transaction t where c.Acc_No!=t.Acc_No;
Description : (1) Prachi has given the following command to obtain the highest marks Select max(marks) from student where group by class; -Technology
Last Answer : (1)d. Select class, max(marks) from student group by class;(2)b. Both (ii) and (iv)(3)b. select name,max(DOB) from student;
Description : What is the difference between the order by and group by clause when used along with the select statement. -Technology
Last Answer : The order by clause is used to show the contents of a table/relation in a sorted manner with respect to the column mentioned after the order by clause. The contents of the column can be arranged in ... a given column and then apply an aggregate function eg max(), min() etc on the entire group.
Description : An ECS transaction gets bounced and you are unable to recover your money from your customer. Under which Act criminal action can be initiated? A. Negotiable Instrument Act 1881 B. Criminal Procedure Code C. Payment and Settlement Systems Act 2007 D. Indian Companies Act 1956
Last Answer : C. Payment and Settlement Systems Act 2007 Explanation: Under the Section 25 of Payment and Settlement Systems (PSS) Act, 2007, dishonour of an electronic fund transfer instruction due to insufficiency ... fine or both, similar to the dishonour of a cheque under the Negotiable Instruments Act 1881.
Description : An unbanked customer can initiate IMPS transaction using the services of _______. A. PPI B. PCI C. PFI D. PDI E. None of the Above
Last Answer : A. PPI Explanation: An unbanked customer can initiate IMPS transaction using the services of Pre-Paid Payments instrument issuer (PPI).
Description : Which of the following would not fit the description of a related-party transaction? a. An unusually large sale of merchandise to the company's best and largest customer. b. Sales of merchandise ... person. d. Loans to corporate officers at market rates of interest with a regular repayment schedule.
Last Answer : An unusually large sale of merchandise to the company's best and largest customer.
Description : Marketing that moves away from a transaction-based effort to a conversation (i.e. two-way dialogue) and can be described as a situation or mechanism through which marketers and a customer (e ... known as: A. Direct Marketing B. Eectronic marketing C. Interactive Marketing D. Indirect Marketing
Last Answer : C. Interactive Marketing
Description : Marketing that moves away from a transaction-based effort to a conversation (i.e. two-way dialogue) and can be described as a situation or mechanism through which marketers and a customer ... is known as: * Direct Marketing Electronic marketing Interactive Marketing Indirect Marketing
Last Answer : Interactive Marketing
Description : If a customer agrees to retain merchandise that is defective because the seller is willing to reduce the selling price, this transaction is known as a sales a. discount. b. return. c. contra asset. d. allowance.
Last Answer : b. return.
Description : Ashwin borrowed a sum of Rs.6, 300 from Mishra at the rate of 14% for 3 years. He then added some more money to the borrowed sum and lent it to Ramesh at the rate of 16% of simple interest for the same time. If ... sum did he lend to Ramesh? a) Rs.6600 b) Rs.6800 c) Rs.4800 d) Rs.9800 e) Rs.8500
Last Answer : Suppose Ashwin lend Rs. x to Ramesh then, Xx16x3/100 - (X – 6300) × 14 × 3/100 = 618......(1) From equation I , x = Rs. 6800 Answer: b)
Description : Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?
Last Answer : SELECT customer_no, payments from customer C1 WHERE 3
Description : Discuss the significance of having clause with group by statement with suitable example. -Technology
Last Answer : Sometimes we do not want to see the whole output produced by a statement with Group By clause. We want to see the output only for those groups which satisfy some condition. It means we want ... the total amount of all type of transactions, it will only display the total of credit transactions only.
Description : Match List- I and List -II and select the correct answer using code given below lists List-I a) Facts as effect of fact in issue 1) Section9 b) Facts forming part of same transaction 2) Section 8 c) Fact which constitute preparation for any ... d) A) 1 2 3 4 B) 4 3 2 1 C) 3 4 2 1 D) 2 3 1 4
Last Answer : c) Fact which constitute preparation for any fact in issue
Description : (i) Write command to compute sum of every column of the data frame. -Technology
Last Answer : (i) df1.sum()(ii) df1[‘Rainfall’].mean()(iii) df1.loc[:11, ‘maxtemp’:’Rainfall’].mean( )
Description : Given the following Series S1 and S2: Write the command to find the sum of series S1 and S2 -Technology
Last Answer : print(S1+S2)
Description : In which scenarios fraudulent credit card transaction may not be reversed?
Last Answer : One scenario is when you child makes an online purchase on your credit card.
Description : My credit card transaction failed will it be refunded or not?
Last Answer : answer:Sounds to me like the transaction never went through. Have you checked your credit card companys website? Log in there and view your credit card activity.
Description : Why would a transaction marked "credit" with a positive value deduct from my available balance at the bank?
Last Answer : If your bank hasn’t verified the funds from the entity giving you the credit yet, they won’t make it available for you to access.
Description : What's a great way to stop using credit cards but keep Mint-friendly electronic transaction records?
Last Answer : Is it possible to use a debt card (linked to a checking or savings account) or a charge card (like American Express) for you business? What specifically don’t you like about credit cards?
Description : ___________ is basically charged when a person uses a credit card to obtain cash. A. Early Repayment Charge B. Redemption Fee C. Transaction Fee D. Cash Advance Fee
Last Answer : D. Cash Advance Fee Explanation: A cash advance fee is a charge that a credit card issuer charges a customer for accessing the cash credit line on his or her account, either through an ATM, convenience check or at a bank‘s teller window.
Description : B) CaixaBank Explanation: As per the agreement, they will expand banks guarantee transaction businesses by jointly providing credit to Indian-Spanish joint ventures and Indian local ... finance and export credit agency finance, infrastructure finance and networking services, among others.
Last Answer : Recently an Indian bank launched next generation features on its app „iMobile‟ which will enable customers to instantly pay taxes and book railway tickets within the app. Name the bank. A) Federal Bank B) Punjab National Bank C) Kotak Mahindra Bank D) ICICI Bank E) Bandhan Bank
Description : Which of the following would not be classified as a related-party transaction? a. Sales of merchandise between affiliated companies. b. An advance of one week's salary to an employee. c. Loans ... the principal owner or client. d. Exchanges of equipment between two companies owned by the same person
Last Answer : An advance of one week's salary to an employee
Description : If an exporter is doubtful about an issuing bank's ability to pay, he will expect a domestic bank to join the transaction in a _____ letter of credit. A. revolving B. irrevocable C. revocable D. unconfirmed E. confirmed
Last Answer : E. confirmed
Description : During a merger and acquisition transaction, the ability to find and use good comparable data for a valuation is relatively ____________. a) easy because each successful company within an industry ... depth, product diversity and access to lines of credit seldom match the company being valued
Last Answer : d) difficult because size differential, management depth, product diversity and access to lines of credit seldom match the company being valued
Description : Preliminary expenses written off is-------- a) Cash transaction b) Non-cash transaction c) Credit transaction d) None of the above
Last Answer : b) Non-cash transaction
Description : The Secure Electronic Transaction protocol is used for a. credit card payment b. cheque payment c. electronic cash payments d. payment of small amounts for internet services
Last Answer : a. credit card payment
Description : A man told his son that he would give him $1000 if he could accomplish the following task. The father gave his son ten envelopes and a thousand dollars, all in one dollar bills. He told his ... exact amount of money asked for. How did the son distribute the money among the ten envelopes? -Riddles
Last Answer : The contents or the ten envelopes (in dollar bills) should be as follows: $1, 2, 4, 8, 16, 32, 64, 128, 256, 489. The first nine numbers are in geometrical progression, and their sum, deducted from 1,000, gives the contents of the tenth envelope.
Description : When refunding someone's money through PayPal, is it possible for them to get their full amount back, or will there always be a transaction fee sucked out of the full amount?
Last Answer : answer:If I remember correctly (and if they haven't changed their policies), I think the transaction fee is only taken from the seller. No fee is deducted from the buyer. That should include refunds. ... stuff. (Like having proof that you refunded them.) You want to keep all of that linked together.
Description : Using simple interestWhat amount produces a loan of $1,000 to 9 months, at 6% annual interest What is the interest I of the previous problem transaction (problem 1)?
Last Answer : Hey, if someone reads this, don't worry about it I already found the answer but thanks for worrying.
Description : In National Electronic Funds Transfer (NEFT) maximum amount per transaction is limited to ________ A. Rs.75000 B. Rs.50000 C. Rs.80000 D. Rs.90000
Last Answer : B. Rs.50000 Explanation: No. There is no limit - either minimum or maximum - on the amount of funds that could be transferred using NEFT. However, maximum amount per transaction is ... -based remittances within India and also for remittances to Nepal under the Indo-Nepal Remittance Facility Scheme.
Description : Which of the following is the Slogan of UPI(Unified Payment Interface)? A. Less Amount More Digital B. Less Cash More Transaction C. Less Cashflow More Digital D. Less Circulation More Digital E. Less Cash More Digital
Last Answer : E. Less Cash More Digital Explanation: Less cash more digital is the Slogan of UPI(Unified Payment Interface)
Description : Mark the correct option a) Minor cannot appoint a messenger for making withdrawal from SB account b) At the time of making a withdrawal by cheque from saving account not necessary to provide pass book ... added in a saving account may not be treated as transaction in that account d) All the above
Last Answer : d) All the above
Description : With respect to the concept of materiality, which one of the following statements is correct? a. Materiality is a matter of professional judgment. b. Materiality is determined by reference to AASC's ... depends only on the peso amount of an item relative to other items in the financial statements
Last Answer : Materiality is a matter of professional judgment
Description : On what basis the transaction recorded in treasures cash Book a. on the basis of amount b. on the basis of time they occur c. None of these
Last Answer : b. on the basis of time they occur
Description : The transaction is entered in cash book on the basis of ---------- a. Occurrence b. amount c None of these
Last Answer : a. Occurrence
Description : ___________ value is the amount for which an asset could be exchanged, or a liability settled, between knowledgeable, willing parties in an arm‟s length transaction.
Last Answer : Fair,
Description : A foreign currency transaction should be recorded, on initial recognition in the reporting currency, by applying to the foreign currency amount the exchange rate between the reporting currency and the foreign currency at the date of the recording.
Last Answer : FALSE
Description : Karan bought 1000 share of ABC Limited at Rs.910 through his broker excluding brokerage and taxes. However, the current market price of that share is Rs.915. Here, the amount of Rs.915 reflects ____________. a) value of share b) cost of investment c) investment value d) price of transaction
Last Answer : a) value of share
Description : The law concerning bailment provides for certain rights and duties of both bailor and bailee, depending on the: a) Amount of transaction b) Nature of business c) Kind of bailment d) Competency in the market
Last Answer : c) Kind of bailment
Description : Which attribute lets you control the display of select border sides of a table? -Technology
Last Answer : frame attribute displays the selected border sides of the table.
Description : In the Print dialog box, you can select the pages for printing. (a) Even pages (b) Odd pages (c) All pages in range (d) All of these -Technology
Last Answer : (d) You can select the even, odd and all pages in range for printing.