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. Composition does not allow an object to be part of more than one aggregate object.
Options- A. True
- B. False Discuss
- 2. The default extension for SQL*Plus is .sql.
Options- A. True
- B. False Discuss
- 3. Entities of a given type are grouped into a(n):
Options- A. database.
- B. entity class.
- C. attribute.
- D. ERD. Discuss
- 4. A UML diagram includes which of the following?
Options- A. Class name
- B. List of attributes
- C. List of operations
- D. All of the above. Discuss
- 5. What is the overall responsibility of the DBA?
Options- A. Facilitate the development and use of the database
- B. Create and populate tables
- C. Development, operation, and maintenance of the database and its applications
- D. Both the first and third answers above are correct. Discuss
- 6. The ODBC Level 1 API contains which of the following functions?
Options- A. Browse possible connections and data sources only
- B. Connect to data sources with driver-specific information only
- C. Process a scrollable cursor only
- D. Both 1 and 3 above are in the OBDC Level 1 API. Discuss
- 7. SERIALIZABLE is the strictest isolation level.
Options- A. True
- B. False Discuss
- 8. A key:
Options- A. must always be composed of two or more columns.
- B. can only be one column.
- C. identifies a row.
- D. identifies a column. Discuss
- 9. Structured data may include which of the following?
Options- A. Photo image
- B. Video clip
- C. Dates
- D. None of the above. Discuss
- 10. Which of the following is not a restriction for a table to be a relation?
Options- A. The cells of the table must contain a single value.
- B. All of the entries in any column must be of the same kind.
- C. The columns must be ordered.
- D. No two rows in a table may be identical. Discuss
More questions
Correct Answer: True
Correct Answer: True
Correct Answer: entity class.
Correct Answer: All of the above.
Correct Answer: Both the first and third answers above are correct.
Correct Answer: Connect to data sources with driver-specific information only
Correct Answer: True
Correct Answer: identifies a row.
Correct Answer: Dates
Correct Answer: The columns must be ordered.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.