Discussion
Home ‣ Database ‣ ER Model and Business Rules See What Others Are Saying!
- Question
It is appropriate to use a supertype/subtype relationship when there are attributes that apply to some of the instances of an entity type.
Options- A. True
- B. False
- Correct Answer
- True
- 1. In enterprise data modeling, which is incorrect?
Options- A. You review current systems.
- B. You implement the new database.
- C. You describe the data needed at a very high level of abstraction.
- D. You plan one or more database development projects. Discuss
- 2. Metadata enables database designers and users to do all of the following except:
Options- A. sample data.
- B. understand what data exist.
- C. what the fine distinctions are between similar data items.
- D. what the data mean. Discuss
- 3. A characteristic of a file server is which of the following?
Options- A. Manages file operations and is shared on a network.
- B. Manages file operations and is limited to one PC.
- C. Acts as a fat client and is shared on a network.
- D. Acts as a fat client and is limited to one PC. Discuss
- 4. We have Market Basket data for 1,000 rental transactions at a Video Store. There are for videos for rent -- Video A, Video B, Video C and Video D. The probability that both Video C and Video D are rented at the same time is known as ________ .
Options- A. the basic probability
- B. support
- C. lift
- D. confidence Discuss
- 5. Creating a read-only database is a task that is ________ assigned to beginning database professionals.
Options- A. always
- B. commonly
- C. seldom
- D. never Discuss
- 6. Which of the following is true concerning a procedure?
Options- A. You do not create them with SQL.
- B. They do not need to have a unique name.
- C. They include procedural and SQL statements.
- D. They are the same thing as a function. Discuss
- 7. An SQL Server 2000 language that adds programming elements like parameters, variables, IF, WHILE loops, and so forth, to the basic capabilities of SQL is called:
Options- A. COBOL.
- B. VB.NET.
- C. TRANSACT SQL.
- D. Visual Basic. Discuss
- 8. An attribute name should be which of the following?
Options- A. Singular verb or verb phrase
- B. Follow a standard format
- C. Use a alias
- D. All of the above. Discuss
- 9. With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.
Options- A. READ_ONLY
- B. SCROLL_LOCK
- C. OPTIMISTIC
- D. PESSIMISTIC Discuss
- 10. Which of the following is one of the basic approaches for joining tables?
Options- A. Subqueries
- B. Union Join
- C. Natural join
- D. All of the above Discuss
More questions
Correct Answer: You implement the new database.
Correct Answer: sample data.
Correct Answer: Manages file operations and is shared on a network.
Correct Answer: support
Correct Answer: commonly
Correct Answer: They include procedural and SQL statements.
Correct Answer: TRANSACT SQL.
Correct Answer: Follow a standard format
Correct Answer: OPTIMISTIC
Correct Answer: All of the above
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.