Discussion
Home ‣ Technical Questions ‣ Database Comments
- Question
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.
- Correct Answer
- A single logical database that is spread to multiple locations and is interconnected by a network
- 1. 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
- 2. 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. Discuss
- 3. 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
- 4. Which of the following is an advantage of partitioning?
Options- A. Complexity
- B. Inconsistent access speed
- C. Extra space
- D. Security Discuss
- 5. 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
- 6. 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
- 7. 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
- 8. 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
- 9. The process of reading a database schema and producing a data model from that schema is known as:
Options- A. data modeling.
- B. database design.
- C. reverse engineering.
- D. None of the above is correct. Discuss
- 10. 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
Database problems
Search Results
Correct Answer: All of the above
Correct Answer: Data integrity improves as multiple applications access the same stored procedure.
Correct Answer: Use compatible data types.
Correct Answer: Security
Correct Answer: Attributes are assigned at the highest logical level.
Correct Answer: All of the above.
Correct Answer: All of the above.
Correct Answer: the child table.
Correct Answer: reverse engineering.
Correct Answer: drop the foreign key constraint.
Comments
There are no comments.More in Technical Questions:
Programming
Copyright ©CuriousTab. All rights reserved.