Discussion
Home ‣ Interview ‣ Technology See What Others Are Saying!
- Question
Could you explain the areas where tuning of database is required?
- Correct Answer
- The following are the areas of concern for tuning: - Memory Usage - Data Storage - Data Manipulation - Physical Storage - Logic Storage - Network Traffic Tuning Memory Usage: In Oracle 10g, we can use the Automatic Workload Repository (AWR) toolset to gather and manage statistical data but in case of Oracle 11g, we can use new initialization parameters such as MEMORY_TARGET to further control the overall memory used by Oracle It helps us to tune the database automatically when we don?t have time to read the AWR report Tuning Data Manipulation: There are two ways to tune Data manipulation in Oracle one way is through Conventional Path mode and second is Direct Path mode Tuning Physical Storage: We need to tune the physical storage because it limits the disk in database This can be done by: Distributing I/O, Striping and Mirroring
- 1. 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
- 2. 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
- 3. 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
- 4. Which Bank has been given scheduled bank status by RBI ?
Options- A. Disha
- B. Suryoday
- C. Janalakshmi
- D. Ujjivan Discuss
- 5. Which class is used to indicate Black Navigation Bar ?
Options- A. .navbar-inverse
- B. .navbar-black
- C. .navbar-dark
- D. .navbar-default Discuss
- 6. 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
- 7. What is CRR rate? Discuss
- 8. Which among the following are not access Specifiers in C++?
Options- A. Public
- B. Protected
- C. Default
- D. Private Discuss
- 9. In which year, the first bank of India "Bank of Hindustan" was established ?
Options- A. 1677
- B. 1770
- C. 1796
- D. 1831 Discuss
- 10. What could be the bucket size if collision and overlapping occur at same time?
Options- A. 2
- B. 0
- C. 1
- D. 4 Discuss
More questions
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.
Correct Answer: 1
Explanation:
One. If there is only one entry possible in the bucket, when the collision occurs, there is no way to accommodate the colliding value. This results in the overlapping of values
Comments
There are no comments.More in Interview:
Programming
Copyright ©CuriousTab. All rights reserved.