Discussion
Home ‣ Database ‣ Managing Databases with Oracle See What Others Are Saying!
- Question
Which of the following is not true about indexes?
Options- A. Indexes are created to enforce uniqueness on columns.
- B. Indexes are created to enable fast retrieval by column values.
- C. Columns that are frequently used with equal conditions in WHERE clauses are good candidates for indexes.
- D. Indexes are created with the ALTER TABLE command.
- Correct Answer
- Indexes are created with the ALTER TABLE command.
- 1. 'dbo' stands for database object.
Options- A. True
- B. False Discuss
- 2. SQL is a data sublanguage.
Options- A. True
- B. False Discuss
- 3. Which one of the following symbols is not used in an ERD?
Options- A. Rectangle
- B. Oval
- C. Diamond
- D. Circle Discuss
- 4. Data in operational systems are typically fragmented and inconsistent.
Options- A. True
- B. False Discuss
- 5. VBScript is similar to JavaScript.
Options- A. True
- B. False Discuss
- 6. Successful data warehousing requires that a formal program in total quality management (TQM) be implemented.
Options- A. True
- B. False Discuss
- 7. The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.
Options- A. True
- B. False Discuss
- 8. The source of the data is sometimes called the system of record.
Options- A. True
- B. False Discuss
- 9. All primary keys are required.
Options- A. True
- B. False Discuss
- 10. Entities use identifiers while tables use keys.
Options- A. True
- B. False Discuss
More questions
Correct Answer: False
Correct Answer: True
Correct Answer: Circle
Correct Answer: True
Correct Answer: True
Correct Answer: True
Correct Answer: True
Correct Answer: True
Correct Answer: True
Correct Answer: True
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.