Discussion
Home ‣ Database ‣ The Client-Server Database Comments
- Question
A benefit of the three-tier architecture is which of the following?
Options- A. New modules can be built to support specific business needs
- B. Performance improves for compiled SQL statements
- C. Results in a thinner client and database server
- D. All of the above.
- Correct Answer
- New modules can be built to support specific business needs
- 1. Which of the following is an advantage of partitioning?
Options- A. Complexity
- B. Inconsistent access speed
- C. Extra space
- D. Security Discuss
- 2. A multidimensional database model is used most often in which of the following models?
Options- A. Data warehouse
- B. Relational
- C. Hierarchical
- D. Network Discuss
- 3. Sequential retrieval on a primary key for sequential file storage has which of the following features?
Options- A. Very fast
- B. Moderately fast
- C. Slow
- D. Impractical Discuss
- 4. What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary?
Options- A. VARCHAR2
- B. CHAR
- C. LONG
- D. NUMBER Discuss
- 5. A rule of thumb for choosing indexes for a relational database includes which of the following?
Options- A. Indexes are more useful on smaller tables.
- B. Indexes are more useful for columns that do not appear frequently in the WHERE clause in queries.
- C. Do not specify a unique index for the primary key of each table.
- D. Be careful indexing attributes that have null values. Discuss
- 6. Which of the following statements is true concerning JDBC?
Options- A. It is language independent.
- B. It is similar in concept to ODBC.
- C. It is useful for all object-oriented languages.
- D. It consists of three main layers. Discuss
- 7. The three different application logic components are which of the following?
Options- A. Presentation, Client, and Storage
- B. Presentation, Client, and Processing
- C. Presentation, Processing, and Storage
- D. Presentation, Processing, and Network Discuss
- 8. A server cannot serve on which of the following levels?
Options- A. Client Layer
- B. Business Layer
- C. Database Layer
- D. All of the above. Discuss
- 9. Client/server security includes which of the following?
Options- A. Physical security
- B. Change control security
- C. Measures taken to secure all systems
- D. All of the above. Discuss
- 10. 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
The Client-Server Database problems
Search Results
Correct Answer: Security
Correct Answer: Data warehouse
Correct Answer: Very fast
Correct Answer: VARCHAR2
Correct Answer: Be careful indexing attributes that have null values.
Correct Answer: It is similar in concept to ODBC.
Correct Answer: Presentation, Processing, and Storage
Correct Answer: Client Layer
Correct Answer: All of the above.
Correct Answer: Manages file operations and is shared on a network.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.