Bissoy.com
Doctors Medicines MCQs Q&A

Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = ‘VA’;

Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = ‘VA’; Correct Answer SELECT NAME FROM CUSTOMER WHERE STATE IN (‘VA’);

Query d satisfy the condition mention in above.

Related Questions

The question given below consists of a statement, followed by three arguments numbered I, II and III. You have to decide which of the arguments is/are ‘strong’ arguments and which is/are ‘weak’ arguments and accordingly choose your answer from the alternatives given below each question. Statement: In an interview with ETCIO.COM, Kuruvilla Markose, Chief Digital Officer of Titan shares his perspective on how technology is serving the company’s digital vision and the various initiatives that he is spearheading to hone the competitive edge of Titan. He is the first CDO to be appointed by the software conglomerate Tata Group. He is the man who has put the Titan’s digital transformation on fast-track. Which of the following arguments support the fact that Kuruvilla Markose has put Titan’s digital transformation on fast-track? Arguments: I. Markose is a man with a vision. He is the first CDO to be appointed by the software conglomerate Tata Group. He has spent his entire two decade long career in Tata Group. He has been in customer facing roles across different group companies.  II. His CDO role is horizontal and supports Titan’s myriad business lines: watches, jewellery, bags, perfumes wallets, and eye-wear. But the man and his words are grounded. Diny, as he is popularly known, is a man of measured speech and bearing. III. “Digital innovation”, according to Markose, is all about creating value for the customer. To him, customer centricity is the road to longevity in the digital age. Under his stewardship, Titan has launched a panoply of digital initiatives aimed at improving customer centricity.
A customer purchased two units of the same item, one from a shopkeeper and one from a whole seller. The whole seller sold the items to the shopkeeper and customer at 15% profit while the shopkeeper sold the item to the customer at 20% profit. If the difference between the price of both units for the customer is Rs. 96.6, then what is the total cost of both the units for the customer?
Phillip Kotler argues that the 4 Ps which represent the seller’s thinking more than buyer’s thinking can be translated into the 4 Cs. Match the following : 4 Ps of marketing Planning 4 Cs of Marketing Planning 1. Product (a) Customer Communication 2. Price (b) Customer value 3. Place (c) Customer costs 4. Promotion (d) Customer convenience Select the correct matching using the code given below :
Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';
You are the administrator of a SQL Server 2000 computer. The server contains a database named FinanceData that is used by a client/server application. Each employee has a SQL Server login that the application uses to access the server.Your company hires a new employee named Andrew. You create a SQL Server login named Andrew. You also create a database user named Andrew in the database and grant the database user full permissions in the database.Whenever Andrew runs the client/server application, he receives the following error message: "Invalid object name." Andrew also reports that he cannot access the database by using the application.You need to ensure that Andrew can use the application. Which Transact-SQL statement should you execute?
In the question below, are given a statement followed by three courses of actions numbered I, II and III. On the basis of the information given, you have to assume everything in the statement to be true, and then decide which of the suggested course of action logically follow (s) for pursuing. Statement: Reliance Jio Infocomm, the most recent entrant in India’s telecom service sector, may be more adversely affected by the Supreme Court order curbing the use of Aadhaar than older rivals Vodafone Idea and Bharti Airtel. The apex court order disallowing telcos from using the faster Aadhaar-based verification system could slow the pace of subscriber additions significantly, potentially delaying the company’s plan to acquire a 50% revenue market share. The Mukesh Ambani-owned telco has been adding many more subscribers every month than its rivals.  Courses of action: I. Jio’s gross customer additions could decline in the coming months as the verification process will henceforth be a more cumbersome affair, which could also be a turn-off for potential new users who’ve been lately used to instant connectivity under the Aadhaar-based enrolment mechanism.  II. Customer verification expenses will increase in step with the volume of customer acquisition of telcos and so, stronger the monthly user additions, higher the associated verification costs.  III. The more tedious verification process henceforth is also likely to slow down the processing of porting requests from customers.
Read the passage carefully and choose the best answer to each question out of the four alternatives.
Eight north Indian Ocean countries, namely, Bangladesh, India, the Maldives, Myanmar, Oman, Pakistan, Sri Lanka and Thailand, were asked to contribute names so that a combined list could be compiled. Each country gave eight names and a combined list of 64 names was prepared. This list is currently in use, and all cyclones arising in the north Indian Ocean are named from this list, with one name from each country being used in turn. Almost 38 or 39 names from the list have been used up, but since many cyclones dissipate long before they hit land, their names rarely figure in the papers or other media. The names that people do know about, and remember are, naturally, those that were most destructive ones, or very recent. Aila, in 2009 is remembered with a shudder for the enormous destruction it caused in West Bengal and Bangladesh; Phaillin, also for the damage it caused when it hit the Odisha coast in 2013. Two harmless cyclones, which also might remain in peoples memory, are the more recent ones of 2014 — Hudhud, which threatened the east coast of India and Nilofar, which was expected to, but did not, devastate the western coast. The names in the cyclone list are usually words one associates with storms; words which mean water or wind or lightning in various national languages. Sometimes they are names of other things — birds or flowers or precious stones. The name Aila, contributed by the Maldives means fire, the name Phaillin from Thailand means sapphire, the name Hudhud from Oman is the name of a bird, probably the hoopoe, and the name Nilofar, given by Pakistan, is the Urdu name of the lotus or water lily. The eight names suggested by India, and which are in the list of 64, are Agni, Akaash, Bijli, Jal, Leher, Megh, Sagar and Vayu, meaning in that order, fire, sky, lightning, water, wave, cloud, sea and wind. Five of these names (that is, up to Leher) have been used so far.
For the next cyclone if it is the turn of an Indian name to be chosen, then what will be that name?
A shopkeeper marked an item 50% above the cost price and sold to customer A at a 10% discount. While he marked the same item 60% above the cost price and sold to customer B at a 20% discount. If customer A paid Rs. 56 more than customer B, then what is the profit amount earned by a shopkeeper after selling items to both the customers?
A company sold a bike worth Rs. 40000 to a dealer at a profit of 5%. The dealer sold it to a customer at a profit of 12%. After few years, the customer sold the bike back to the dealer at 25% loss. If the dealer sold the old bike to a new customer at 5% profit, at what price did the new customer bought the bike?
The cost of servicing of a Maruti car at Maruti care Pvt. Ltd. is Rs. 400. Manager of service centre told me that for the second service within a year a customer can avail a 10% discount and further for third and fourth servicing he can avail 10% discount of the previous amount paid, within a year. Further if a customer gets more than 4 services within a year, he has to pay just 60% of the servicing charges on these services. A customer availed 5 services from the same servicing station, what is the total percentage discount fetched by the customer?