Discussion
Home ‣ Database ‣ Data Models into Database Designs See What Others Are Saying!
- Question
A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):
Options- A. primary key.
- B. foreign key.
- C. composite key.
- D. surrogate key.
- Correct Answer
- surrogate key.
- 1. 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
- 2. Information repositories are replacing data dictionaries in many organizations.
Options- A. True
- B. False Discuss
- 3. 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
- 4. For every relationship, how many possible sets of minimum cardinalities are there?
Options- A. Two
- B. Three
- C. Four
- D. Six Discuss
- 5. 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
- 6. An entity is something that can be identified in the user's work environment; something that the users want to track.
Options- A. True
- B. False Discuss
- 7. When using ODBC, which of the following processes ODBC requests and submits specific SQL statements to a given type of data source?
Options- A. Data source
- B. Driver
- C. Driver manager
- D. DBMS Discuss
- 8. A reason for using an SQL view to hide columns is:
Options- A. to simplify a result only.
- B. to prevent the display of sensitive data only.
- C. to accomplish both of the above.
- D. None of the above are reasons for using an SQL view. Discuss
- 9. Eliminating modification anomalies is a(n) ________ of normalization.
Options- A. advantage
- B. disadvantage
- C. either an advantage or disadvantage
- D. neither an advantage nor disadvantage Discuss
- 10. What mode of authentication does SQL Server NOT provide?
Options- A. Windows-only security
- B. Both SQL Server and Windows-only security
- C. Mixed security
- D. SQL Server only security Discuss
More questions
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
Correct Answer: True
Correct Answer: Driver
Correct Answer: to accomplish both of the above.
Correct Answer: advantage
Correct Answer: SQL Server only security
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.