Discussion
Home ‣ Database ‣ Physical Database Design See What Others Are Saying!
- Question
Which of the following is an advantage of partitioning?
Options- A. Complexity
- B. Inconsistent access speed
- C. Extra space
- D. Security
- Correct Answer
- Security
- 1. Which of the following is a disadvantage of replication?
Options- A. Reduced network traffic
- B. If the database fails at one site, a copy can be located at another site.
- C. Each site must have the same storage capacity.
- D. Each transaction may proceed without coordination across the network. Discuss
- 2. The SQL -92 wildcards are ____ and ____ .
Options- A. asterisk (*); percent sign (%)
- B. percent sign (%); underscore (_)
- C. underscore(_); question mark (?)
- D. question mark (?); asterisk (*) Discuss
- 3. Which of the following is the original purpose of SQL?
Options- A. To specify the syntax and semantics of SQL data definition language
- B. To specify the syntax and semantics of SQL manipulation language
- C. To define the data structures
- D. All of the above. Discuss
- 4. The result of every SQL query is a table.
Options- A. True
- B. False Discuss
- 5. The data warehouse DBMS needs to be the same DBMS used for the operational database.
Options- A. True
- B. False Discuss
- 6. The reasons for overriding include extension, restriction, and optimization.
Options- A. True
- B. False Discuss
- 7. If a document does not conform to the DTD, it is a bad XML document.
Options- A. True
- B. False Discuss
- 8. Which of the following statements concerning business rules is true?
Options- A. It should be complex.
- B. It should not be convertible to computer code.
- C. It may include restrictions.
- D. All of the above. Discuss
- 9. To sort the results of a query use:
Options- A. SORT BY.
- B. GROUP BY.
- C. ORDER BY.
- D. None of the above is correct. Discuss
- 10. Which of the following statements is true about symmetric multiprocessing?
Options- A. A single copy of the operating system resides in each processor.
- B. Useful for situations where data must remain in memory to process.
- C. Bottlenecks increase with uniprocessor systems because tasks are not shared.
- D. The problems of memory contention are unlikely. Discuss
More questions
Correct Answer: Each site must have the same storage capacity.
Correct Answer: percent sign (%); underscore (_)
Correct Answer: All of the above.
Correct Answer: True
Correct Answer: False
Correct Answer: True
Correct Answer: False
Correct Answer: It may include restrictions.
Correct Answer: ORDER BY.
Correct Answer: Useful for situations where data must remain in memory to process.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.