Discussion
Home ‣ Technical Questions ‣ Database Comments
- Question
A collection of interrelated records is called a
Options- A. Datasheet
- B. Spreadsheet
- C. Database
- D. Utility File
- Correct Answer
- Database
- 1. The benefits of object-oriented modeling are which of the following?
Options- A. The ability to tackle more challenging problems
- B. Reusability of analysis, design, and programming results
- C. Improved communication between users, analysts, etc.
- D. All of the above. Discuss
- 2. A proxy server is used for which of the following?
Options- A. To provide security against unauthorized users
- B. To process client requests for Web pages
- C. To process client requests for database access
- D. To provide TCP/IP Discuss
- 3. 88%of 370 +24% of 210-x =118 find x Discuss
- 4. The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T ;
Options- A. Equi-join
- B. Natural join
- C. Outer join
- D. Cartesian join Discuss
- 5. The different classes of relations created by the technique for preventing modification anomalies are called:
Options- A. normal forms.
- B. functional dependencies.
- C. referential integrity constraints.
- D. None of the above is correct. Discuss
- 6. When mapping a supertype/subtype relationship which of the following is true?
Options- A. The supertype primary key is assigned to each subtype.
- B. The subtype primary key is assigned to each supertype.
- C. There is no link between the supertype/subtype entities.
- D. There is no primary key/foreign key relationship between a supertype/subtype. Discuss
- 7. With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.
Options- A. READ_ONLY
- B. SCROLL_LOCK
- C. OPTIMISTIC
- D. PESSIMISTIC Discuss
- 8. For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?
Options- A. Two
- B. Three
- C. Four
- D. Six Discuss
- 9. A shared database should:
Options- A. be accurate and available.
- B. provide for backup and recovery.
- C. be secure.
- D. All of the above. Discuss
- 10. A transitive dependency is which of the following?
Options- A. A functional dependency between two or more key attributes.
- B. A functional dependency between two or more nonkey attributes.
- C. A relation that is in first normal form.
- D. A relation that is in second normal form. Discuss
Database problems
Search Results
Correct Answer: All of the above.
Correct Answer: To provide security against unauthorized users
Correct Answer: From the given equation, 88x370/100 + 24x210/100 - 118 = x => x = 3256 + 504 - 118 x = 258
Correct Answer: Cartesian join
Correct Answer: normal forms.
Correct Answer: The supertype primary key is assigned to each subtype.
Correct Answer: OPTIMISTIC
Correct Answer: Six
Correct Answer: All of the above.
Correct Answer: A functional dependency between two or more nonkey attributes.
Comments
There are no comments.More in Technical Questions:
Programming
Copyright ©CuriousTab. All rights reserved.