Discussion
Home ‣ Interview ‣ Technology See What Others Are Saying!
- Question
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables ?
Options- A. Data Manipulation Language(DML)
- B. Data Definition Language(DDL)
- C. Both A & B
- D. None
- Correct Answer
- Data Definition Language(DDL)
ExplanationThe Data Definition Language (DDL) is used to manage table and index structure.
CREATE,
ALTER,
RENAME,
DROP and
TRUNCATE
statements are the names of few data definition elements.
- 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.