Discussion
Home ‣ Database ‣ Managing Multiuser Databases See What Others Are Saying!
- Question
Which of the following locks the item from change but not from read?
Options- A. Implicit lock
- B. Explicit lock
- C. Exclusive lock
- D. Shared lock
- Correct Answer
- Shared lock
- 1. A distributed database can use which of the following strategies?
Options- A. Totally centralized at one location and accessed by many sites
- B. Partially or totally replicated across sites
- C. Partitioned into segments at different sites
- D. All of the above Discuss
- 2. There is one physical schema for each logical schema.
Options- A. True
- B. False Discuss
- 3. An extent is a contiguous section of disk storage space.
Options- A. True
- B. False Discuss
- 4. Each answer below shows example data from a table. Which answer is an example of the inconsistent values problem?
Options- A. Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
- B. Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
- C. Three rows have the values Brown, NULL, and Blue in the same column.
- D. One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column. Discuss
- 5. With this type of index, the data are stored in the bottom level of the index and in the same order as that index.
Options- A. Nonclustered
- B. Clustered
- C. Primary
- D. Secondary Discuss
- 6. The relational database model was created by E.F. Codd.
Options- A. True
- B. False Discuss
- 7. When one transaction reads a changed record that has not been committed to the database a filthy read occurs.
Options- A. True
- B. False Discuss
- 8. What is bytecode?
Options- A. Machine-specific code
- B. Java code
- C. Machine-independent code
- D. None of the above is correct. Discuss
- 9. The blocking factor is:
Options- A. a group of fields stored in adjacent memory.
- B. the number of physical records per page.
- C. attributes grouped together by the same primary key.
- D. attributes grouped together by the same secondary key. Discuss
- 10. The object definition language (ODL) is which of the following?
Options- A. Used to develop logical schemas
- B. A data definition language for OODB
- C. A method to implement a logical schema
- D. All of the above. Discuss
More questions
Correct Answer: All of the above
Correct Answer: True
Correct Answer: True
Correct Answer: Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
Correct Answer: Clustered
Correct Answer: True
Explanation:
The relational model for database management is a database model based on first-order predicate logic, first formulated and proposed in 1969 by E.F. Codd.
Correct Answer: False
Correct Answer: Machine-independent code
Correct Answer: the number of physical records per page.
Correct Answer: All of the above.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.