Discussion
Home ‣ Interview ‣ Technology See What Others Are Saying!
- Question
What are fact tables and dimension tables?
- Correct Answer
- Business facts or measures and foreign keys are persisted in fact tables which are referred as candidate keys in dimension tables Additive values are usually provided by the fact tables which acts as independent variables by which dimensional attributes are analyzed Attributes that are used to constrain and group data for performing data warehousing queries are persisted in the dimension tables
- 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.