Discussion
Home ‣ Database ‣ Managing Databases with Oracle See What Others Are Saying!
- Question
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.
- Correct Answer
- Sequences guarantee valid surrogate key values.
- 1. 1:1, 1:N and N:M relationships are also known as HAS-A relationships.
Options- A. True
- B. False Discuss
- 2. A user data source is one that can be shared among database users.
Options- A. True
- B. False Discuss
- 3. When a business rule involves three or more graphical symbols, you can show the constraint as a note and attach the note to each of the symbols by a dashed line.
Options- A. True
- B. False Discuss
- 4. An exclusive lock locks the item from change but not from read.
Options- A. True
- B. False Discuss
- 5. Which of the following refers to an entity in which the identifier of one entity includes the identifier of another entity?
Options- A. Weak entity
- B. Strong entity
- C. ID-dependent entity
- D. ID-independent entity Discuss
- 6. Authorization tables contain highly sensitive data and should be protected by stringent security rules.
Options- A. True
- B. False Discuss
- 7. Poor data administration can lead to which of the following?
Options- A. A single definition of the same data entity
- B. Familiarity with existing data
- C. Missing data elements
- D. All of the above. Discuss
- 8. Needing to using more complicated SQL in database applications is a(n) ________ of normalization.
Options- A. advantage
- B. disadvantage
- C. either an advantage or disadvantage
- D. neither an advantage nor disadvantage Discuss
- 9. Which type of SQL Server cursor concurrency places an update lock on a row when the row is read?
Options- A. READ_ONLY
- B. SCROLL_LOCK
- C. OPTIMISTIC
- D. READCOMMITTED Discuss
- 10. XML Schemas consist of:
Options- A. properties and methods.
- B. elements and attributes.
- C. structure and data.
- D. tables and relationships. Discuss
More questions
Correct Answer: True
Correct Answer: False
Correct Answer: True
Correct Answer: False
Correct Answer: ID-dependent entity
Correct Answer: True
Correct Answer: Missing data elements
Correct Answer: disadvantage
Correct Answer: READCOMMITTED
Correct Answer: elements and attributes.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.