Discussion
Home ‣ Database ‣ SQL Server 2000 See What Others Are Saying!
- Question
SQL Server indexes are special data structures used to improve performance.
Options- A. True
- B. False
- Correct Answer
- True
- 1. If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.
Options- A. the primary key
- B. any alternate key
- C. a surrogate key
- D. a foreign key Discuss
- 2. Multiple inheritance allows a class to inherit features from more than one superclass.
Options- A. True
- B. False Discuss
- 3. A database design may be based on existing data.
Options- A. True
- B. False Discuss
- 4. If both data and database administration exist in an organization, the database administrator is responsible for which of the following?
Options- A. Data modeling
- B. Database design
- C. Metadata
- D. All of the above. Discuss
- 5. The degree of a relationship refers to the number of entity classes in the relationship.
Options- A. True
- B. False Discuss
- 6. After a table has been created, its structure can be modified using the SQL command:
Options- A. UPDATE TABLE [TableName].
- B. MODIFY TABLE [TableName].
- C. ALTER TABLE [TableName].
- D. CHANGE TABLE [TableName]. Discuss
- 7. Which statement about sequences is not true?
Options- A. A sequence is an object that generates a sequential series of unique numbers.
- B. Sequences are most often used to provide values for surrogate keys.
- C. NextVal and CurrVal are both sequence methods.
- D. Sequences guarantee valid surrogate key values. Discuss
- 8. Of the three ways to create an Oracle database, which one is the easiest and most recommended?
Options- A. Using the Oracle Database Configuration Assistant.
- B. Using the Oracle-supplied database creation procedures.
- C. Using the SQL CREATE DATABASE command.
- D. None of the above is correct. Discuss
- 9. JDBC stands for:
Options- A. Java Database Connectivity
- B. Java Database Components
- C. Java Database Control
- D. None of the above is correct. Discuss
- 10. What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?
Options- A. Full backup
- B. Consistent backup
- C. Inconsistent backup
- D. Differential backup Discuss
More questions
Correct Answer: the primary key
Correct Answer: True
Correct Answer: True
Correct Answer: Database design
Correct Answer: True
Correct Answer: ALTER TABLE [TableName].
Correct Answer: Sequences guarantee valid surrogate key values.
Correct Answer: Using the Oracle Database Configuration Assistant.
Correct Answer: Java Database Connectivity
Correct Answer: Consistent backup
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.