Discussion
Home ‣ Database ‣ Database Design Using Normalization See What Others Are Saying!
- Question
When building a database from an existing set of tables, we may safely assume that referential integrity constraints have been enforced on the data we are given.
Options- A. True
- B. False
- Correct Answer
- False
- 1. Which of the following is an SQL trigger supported by Oracle?
Options- A. BEFORE
- B. INSTEAD OF
- C. AFTER
- D. All of the above. Discuss
- 2. The primary mechanism for providing context for data is metadata.
Options- A. True
- B. False Discuss
- 3. Data scrubbing is which of the following?
Options- A. A process to reject data from the data warehouse and to create the necessary indexes
- B. A process to load the data in the data warehouse and to create the necessary indexes
- C. A process to upgrade the quality of data after it is moved into a data warehouse
- D. A process to upgrade the quality of data before it is moved into a data warehouse Discuss
- 4. The entity integrity rule states that:
Options- A. no primary key attribute may be null.
- B. no primary key can be composite.
- C. no primary key may be unique.
- D. no primary key may be equal to a value in a foreign key. Discuss
- 5. Replication may use either synchronous or asynchronous distributed database technologies, although asynchronous technologies are more typical in a replicated environment.
Options- A. True
- B. False Discuss
- 6. When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
Options- A. LIKE only.
- B. IN only.
- C. NOT IN only.
- D. Both IN and NOT IN. Discuss
- 7. Static extract is used for ongoing warehouse maintenance.
Options- A. True
- B. False Discuss
- 8. Which of the following is true concerning an ODBMS?
Options- A. They have the ability to store complex data types on the Web.
- B. They are overtaking RDBMS for all applications.
- C. They are most useful for traditional, two-dimensional database table applications.
- D. All of the above. Discuss
- 9. Which of the following statements is true concerning routines and triggers?
Options- A. Both consist of procedural code.
- B. Both have to be called to operate.
- C. Both run automatically.
- D. Both are stored in the database. Discuss
- 10. With SQL Server, parameters and variables in T-SQL start with the "%" sign.
Options- A. True
- B. False Discuss
More questions
Correct Answer: All of the above.
Correct Answer: True
Correct Answer: A process to upgrade the quality of data before it is moved into a data warehouse
Correct Answer: no primary key attribute may be null.
Correct Answer: True
Correct Answer: Both IN and NOT IN.
Correct Answer: False
Correct Answer: They have the ability to store complex data types on the Web.
Correct Answer: Both consist of procedural code.
Correct Answer: False
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.