Discussion
Home ‣ Interview ‣ Technology See What Others Are Saying!
- Question
Define PL/SQL. Explain its purpose
- Correct Answer
- PL/SQL is Procedural Language SQL that is an extension of SQL that results in a more structural language composed of blocks It is mainly used in writing applications that needs to be structured and has error handling
- 1. Who is responsible for maintaining the Accounts receivable in an organization? Discuss
- 2. What are the components of DataStage? Discuss
- 3. Credit sales are recorded as
Options- A. Accounts Receivable
- B. Accounts Payable
- C. Both A & B
- D. None of the above Discuss
- 4. Which of the following is not a function of a Warehouse?
Options- A. Ensuring Profit
- B. Stabilisation in price
- C. Risk-bearing
- D. Storage Discuss
- 5. What is commercial Bank ? Discuss
- 6. Which of the following are elements of SQL?
Options- A. base-table-identifier ::= user-defined-name
- B. base-table-name ::= base-table-identifier
- C. boolean-primary ::= comparison-predicate
- D. All the above Discuss
- 7. State Bank of India recently launched 'SBI Exclusif'. It is a ____ product.
Options- A. Wealth Management
- B. Loan
- C. Mutual Fund
- D. Insurance Discuss
- 8. Describe the use of PL/SQL table? Discuss
- 9. Name any three PL/SQL exceptions? Discuss
- 10. Which one of the following sorts rows in SQL?
Options- A. ORDER BY
- B. GROUP BY
- C. SORT BY
- D. ALIGN BY Discuss
More questions
Correct Answer: Accountants in big organization there will be a department to maintain AR department
Correct Answer: Datastage has two components -Client Components ? Designer, Director, Manager and Administrator -Server Components ? Server, Repository and Plug-ins
Correct Answer: Accounts Receivable
Correct Answer: Ensuring Profit
Correct Answer: A commercial bank is a type of bank that provides services such as accepting deposits, making business loans, and offering basic investment products Commercial bank can also refer to a bank or a division of a bank that mostly deals with deposits and loans from corporations or large businesses, as opposed to individual members of the public
Correct Answer: All the above
Correct Answer: Wealth Management
Correct Answer: PL/SQL tables are scalar arrays that can be referenced by a binary digit They can be used to store values for later queries and calculations
Correct Answer: Too_many_rows No_Data_Found Zero_Error
Correct Answer: ORDER BY
Comments
There are no comments.More in Interview:
Programming
Copyright ©CuriousTab. All rights reserved.