Discussion
Home ‣ Database ‣ Managing Databases with Oracle See What Others Are Saying!
- Question
To see the contents of the SQL*Plus buffer, type:
Options- A. CONTENTS.
- B. BUFFER.
- C. CURRENT.
- D. LIST.
- Correct Answer
- LIST.
- 1. The result of a SQL SELECT statement is a(n) ________ .
Options- A. report
- B. form
- C. file
- D. table Discuss
- 2. Each answer below shows example data from a table. Which answer is an example of the missing 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
- 3. An abstract class is which of the following?
Options- A. A class that has direct instances, but whose descendants may have direct instances.
- B. A class that has no direct instances, but whose descendants may have direct instances.
- C. A class that has direct instances, but whose descendants may not have direct instances.
- D. A class that has no direct instances, but whose descendants may not have direct instances Discuss
- 4. Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?
Options- A. MUST COVER
- B. MUST NOT
- C. Both of the above.
- D. None of the above is correct. Discuss
- 5. To drop a column that is used as a foreign key, first:
Options- A. drop the primary key.
- B. drop the table containing the foreign key..
- C. drop the foreign key constraint.
- D. All of the above must be done. Discuss
- 6. The lost update problem is when User A reads data that have been processed by a portion of a transaction from User B.
Options- A. True
- B. False Discuss
- 7. A primary key should be defined as:
Options- A. NULL.
- B. NOT NULL.
- C. Either of the above can be used.
- D. None of the above are correct. Discuss
- 8. Which of the following items are not necessary for client/server?
Options- A. Assure that tools will connect with middleware.
- B. Understand the requirements.
- C. Determine network bandwidth capabilities.
- D. Include the use of a file server. Discuss
- 9. An action assertion must include which of the following?
Options- A. Anchor object
- B. Action
- C. Corresponding object
- D. All of the above. Discuss
- 10. Use of a supertype/subtype relationship is necessary when which of the following exists?
Options- A. An instance of a subtype participates in a relationship that is unique to that subtype.
- B. An instance of a subtype participates in a relationship that is the same as the other subtypes.
- C. Attributes apply to all of the instances of an entity type.
- D. No attributes apply to any of the instances of an entity type. Discuss
More questions
Correct Answer: table
Correct Answer: Three rows have the values Brown, NULL, and Blue in the same column.
Correct Answer: A class that has no direct instances, but whose descendants may have direct instances.
Correct Answer: MUST COVER
Correct Answer: drop the foreign key constraint.
Correct Answer: False
Correct Answer: NOT NULL.
Correct Answer: Include the use of a file server.
Correct Answer: All of the above.
Correct Answer: An instance of a subtype participates in a relationship that is unique to that subtype.
Comments
There are no comments.More in Database:
Advanced SQLData and Database AdministrationData Modeling with ER ModelData Models into Database DesignsData WarehousingDatabase Design Using NormalizationDatabase Processing for BISDatabase RedesignDistributed DatabasesER Model and Business RulesIntroduction to DatabaseIntroduction to SQLJDBC, Java Server Pages, and MySQLLogical Database DesignManaging Databases with OracleManaging Multiuser DatabasesModeling Data in the OrganizationObject-Oriented Data ModelingObject-Oriented DatabaseODBC, OLE DB, ADO, and ASPPhysical Database DesignSQL for Database ConstructionSQL Server 2000The Client-Server DatabaseThe Database Development ProcessThe Database EnvironmentThe Internet Database EnvironmentThe Relational Model and NormalizationXML and ADO.NETProgramming
Copyright ©CuriousTab. All rights reserved.