Discussion
Home ‣ Technical Questions ‣ Database Comments
- Question
Stored procedures have which of the following advantages?
Options- A. It takes a longer time to write them as compared to writing Visual Basic.
- B. Data integrity improves as multiple applications access the same stored procedure.
- C. Network traffic increases
- D. Result in thicker client and thinner database server.
- Correct Answer
- Data integrity improves as multiple applications access the same stored procedure.
- 1. Which of the following improves a query's processing time?
Options- A. Write complex queries.
- B. Combine a table with itself.
- C. Query one query within another.
- D. Use compatible data types. Discuss
- 2. Which of the following is an advantage of partitioning?
Options- A. Complexity
- B. Inconsistent access speed
- C. Extra space
- D. Security Discuss
- 3. A supertype/subtype hierarchy has which of the following features?
Options- A. Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype.
- B. Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype.
- C. Attributes are assigned at the highest logical level.
- D. Attributes are assigned at the lowest logical level. Discuss
- 4. In enterprise data modeling, which is incorrect?
Options- A. You review current systems.
- B. You implement the new database.
- C. You describe the data needed at a very high level of abstraction.
- D. You plan one or more database development projects. Discuss
- 5. The first step in database development is which of the following?
Options- A. Enterprise data modeling
- B. Logical database design
- C. Physical database design and definition
- D. Database Implementation Discuss
- 6. A distributed database can use which of the following strategies?
Options- A. Totally centralized one location and accessed by many sites
- B. Partially or totally replicated across sites
- C. Partitioned into segments at different sites
- D. All of the above Discuss
- 7. A distributed database is which of the following?
Options- A. A single logical database that is spread to multiple locations and is interconnected by a network
- B. A loose collection of file that is spread to multiple locations and is interconnected by a network
- C. A single logical database that is limited to one location.
- D. A loose collection of file that is limited to one location. Discuss
- 8. The object definition language (ODL) is which of the following?
Options- A. Used to develop logical schemas
- B. A data definition language for OODB
- C. A method to implement a logical schema
- D. All of the above. Discuss
- 9. Using OQL, you may do which of the following?
Options- A. Return an entire collection of elements including duplicates.
- B. Return a collection of elements without duplicates.
- C. Return a specific subset of elements using a given criteria.
- D. All of the above. Discuss
- 10. In a 1:N relationship, the foreign key is placed in:
Options- A. the parent table.
- B. the child table.
- C. either table without specifying parent and child tables.
- D. either the parent table or the child table. Discuss
Database problems
Search Results
Correct Answer: Use compatible data types.
Correct Answer: Security
Correct Answer: Attributes are assigned at the highest logical level.
Correct Answer: You implement the new database.
Correct Answer: Enterprise data modeling
Correct Answer: All of the above
Correct Answer: A single logical database that is spread to multiple locations and is interconnected by a network
Correct Answer: All of the above.
Correct Answer: All of the above.
Correct Answer: the child table.
Comments
There are no comments.More in Technical Questions:
Programming
Copyright ©CuriousTab. All rights reserved.