Discussion
Home ‣ Interview ‣ Technology See What Others Are Saying!
- Question
Which operator performs pattern matching ?
Options- A. LIKE operator
- B. EXISTS operator
- C. BETWEEN operator
- D. None of these
- Correct Answer
- LIKE operator
ExplanationLIKE is a keyword that is used in the WHERE clause. Basically, LIKE allows us to do a search based operation on a pattern rather than specifying exactly what is desired (as in IN) or spell out a range (as in BETWEEN).
The syntax is as follows:
SELECT "column_name"
FROM "table_name"
WHERE "column_name" LIKE {PATTERN}{PATTERN} often consists of wildcards.
In SQL, there are two wildcards:
% (percent sign) represents zero, one, or more characters._ (underscore) represents exactly one character.
More :: Certification Questions on SQL
- 1. How would you automatically transfer your visitors to a new web page? Discuss
- 2. The threshold limit upto which coins can be issued as per the Coinage Act 2011 ?
Options- A. 100
- B. 200
- C. 500
- D. 1000 Discuss
- 3. Cash Reserve Ratio ( CRR) and Stautory Liquidity Ratio (SLR ) are terms most closely related to which of the following industries/markets :
Options- A. Mutual Fund
- B. Income Tax
- C. Stock Exchange
- D. Banking Discuss
- 4. What is the minimum period of time for which one can open an FD(Fixed Deposit) account ?
Options- A. 15 days
- B. 6 months
- C. 7 days
- D. 1 year Discuss
- 5. Which Bank has been given scheduled bank status by RBI ?
Options- A. Disha
- B. Suryoday
- C. Janalakshmi
- D. Ujjivan Discuss
- 6. Which class is used to indicate Black Navigation Bar ?
Options- A. .navbar-inverse
- B. .navbar-black
- C. .navbar-dark
- D. .navbar-default Discuss
- 7. The journal entry to record a credit sale is
Options- A. Accounts Receivable
- B. Accounts Payable
- C. Both A & B
- D. None of the above Discuss
- 8. What is CRR rate? Discuss
- 9. Which among the following are not access Specifiers in C++?
Options- A. Public
- B. Protected
- C. Default
- D. Private Discuss
- 10. In which year, the first bank of India "Bank of Hindustan" was established ?
Options- A. 1677
- B. 1770
- C. 1796
- D. 1831 Discuss
More questions
Correct Answer: - You can do it with the help of meta tag mentioned below:
<META HTTP-EQUIV="Refresh" CONTENT="2"; URL="https://wwwyoursitecom">Place this tag between <HEAD></HEAD> - It will load yousitecom in 2 seconds
Correct Answer: 1000
Correct Answer: Banking
Correct Answer: 7 days
Correct Answer: Ujjivan
Explanation:
Ujjivan Small Finance Bank Ltd, a wholly-owned subsidiary of Ujjivan Financial Services Ltd, has been given scheduled bank status by RBI.
Correct Answer: .navbar-inverse
Explanation:
.navbar-inverse is used to display in black color.
Correct Answer: Accounts Receivable
Explanation:
The journal entry to record a credit sale is Accounts Receivable. Credit sale is nothing butthe customers pay at the time of buying.
Correct Answer: CRR or Cash Reverse Ratio is the amount of money that a commercial bank has to keep with the Reserve Bank of India If the bank increase CRR then the amount with RBI comes down and vice-versa
Correct Answer: Default
Explanation:
Default is the access specifier in java not in C++
Correct Answer: 1770
Explanation:
Among the first banks were the Bank of Hindustan, which was established in 1770 and liquidated in 1829-32.
Comments
There are no comments.More in Interview:
Programming
Copyright ©CuriousTab. All rights reserved.