Discussion
Home ‣ Database ‣ SQL for Database Construction See What Others Are Saying!
- Question
A stored procedure is a program that performs some common action on database data and is stored in the database.
Options- A. True
- B. False
- Correct Answer
- True
- 1. The "curse of dimensionality" relates to which problem of using operational data for BI reporting?
Options- A. Dirty data
- B. Inconsistent data
- C. Too much data
- D. Non-integrated data Discuss
- 2. A subquery in an SQL SELECT statement:
Options- A. can only be used with two tables.
- B. can always be duplicated by a join.
- C. has a distinct form that cannot be duplicated by a join.
- D. cannot have its results sorted using ORDER BY. Discuss
- 3. By default, SQL Server will create one data file and one log file for each newly created database.
Options- A. True
- B. False Discuss
- 4. Reconciled data is which of the following?
Options- A. Data stored in the various operational systems throughout the organization.
- B. Current data intended to be the single source for all decision support systems.
- C. Data stored in one operational system in the organization.
- D. Data that has been selected and formatted for end-user support applications. Discuss
- 5. The longest step of database development is database maintenance.
Options- A. True
- B. False Discuss
- 6. Query-by-Example (QBE) is the most widely available direct-manipulation database query language.
Options- A. True
- B. False Discuss
- 7. RFM analysis uses customers' purchasing patterns to ________ .
Options- A. record transactions
- B. analyze and rank customers
- C. predict future sales using regression techniques
- D. perform OLAP Discuss
- 8. Which of the following column properties would be used to specify that cells in a column must contain a monetary value?
Options- A. Null status
- B. Data type
- C. Default value
- D. Data constraints Discuss
- 9. Specialization is which of the following processes?
Options- A. Defining one or more subtypes of the supertype and forming supertype/subtype relationships.
- B. Defining one or more supertypes of the subtype and forming supertype/subtype relationships.
- C. Defining one or more subtypes of the supertype and not forming supertype/subtype relationships.
- D. Defining one or more supertypes of the subtype and not forming supertype/subtype relationships. Discuss
- 10. Performance analysis and tuning is which of the following?
Options- A. Undertaken one time at the time of a DBMS installation
- B. Undertaken one time at the time of the implementation of a new application
- C. Undertaken as an ongoing part of the backup of a database
- D. Undertaken as an ongoing part of managing a database Discuss
More questions
Correct Answer: Too much data
Correct Answer: has a distinct form that cannot be duplicated by a join.
Correct Answer: True
Correct Answer: Current data intended to be the single source for all decision support systems.
Correct Answer: True
Correct Answer: True
Correct Answer: analyze and rank customers
Correct Answer: Data type
Correct Answer: Defining one or more subtypes of the supertype and forming supertype/subtype relationships.
Correct Answer: Undertaken as an ongoing part of managing a database
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.