Discussion
Home ‣ Database ‣ Physical Database Design See What Others Are Saying!
- Question
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.
- Correct Answer
- the number of physical records per page.
- 1. The extract process is which of the following?
Options- A. Capturing all of the data contained in various operational systems
- B. Capturing a subset of the data contained in various operational systems
- C. Capturing all of the data contained in various decision support systems
- D. Capturing a subset of the data contained in various decision support systems Discuss
- 2. The SQL keyword BETWEEN is used:
Options- A. for ranges.
- B. to limit the columns displayed.
- C. as a wildcard.
- D. None of the above is correct. Discuss
- 3. 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
- 4. 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
- 5. An application program interface (API) is which of the following?
Options- A. The same thing as ODBC.
- B. Middleware that does not provide access to a database.
- C. Middleware that provides access to a database.
- D. The same thing as JDBC. Discuss
- 6. A data warehouse is which of the following?
Options- A. Can be updated by end users.
- B. Contains numerous naming conventions and formats.
- C. Organized around important subject areas.
- D. Contains only current data. Discuss
- 7. Information repositories are replacing data dictionaries in many organizations.
Options- A. True
- B. False Discuss
- 8. Which of the following is true concerning QBE?
Options- A. An official standard has been defined for QBE.
- B. QBE cannot be used for client/server systems.
- C. QBE does not give the programmer a visual programming environment.
- D. Complete applications can be written using QBE. Discuss
- 9. For every relationship, how many possible sets of minimum cardinalities are there?
Options- A. Two
- B. Three
- C. Four
- D. Six Discuss
- 10. Which SQL phrase is not supported by Oracle?
Options- A. ON DELETE CASCADE
- B. ON UPDATE CASCADE
- C. CREATE SEQUENCE [SequenceName]
- D. DROP SEQUENCE [SequenceName] Discuss
More questions
Correct Answer: Capturing a subset of the data contained in various operational systems
Correct Answer: for ranges.
Correct Answer: It is similar in concept to ODBC.
Correct Answer: Presentation, Processing, and Storage
Correct Answer: Middleware that provides access to a database.
Correct Answer: Organized around important subject areas.
Correct Answer: True
Correct Answer: Complete applications can be written using QBE.
Correct Answer: Four
Correct Answer: ON UPDATE CASCADE
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.