Discussion
Home ‣ Technical Questions ‣ Database Comments
- Question
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.
- Correct Answer
- The supertype primary key is assigned to each subtype.
- 1. A collection of interrelated records is called a
Options- A. Datasheet
- B. Spreadsheet
- C. Database
- D. Utility File Discuss
- 2. 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
- 3. 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
- 4. 88%of 370 +24% of 210-x =118 find x Discuss
- 5. 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
- 6. 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
- 7. 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
- 8. 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
- 9. 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
- 10. It is necessary to sort a file before searching a particular item
Options- A. True
- B. False
- C. May or may not be true
- D. None of the above Discuss
Database problems
Search Results
Correct Answer: Database
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: OPTIMISTIC
Correct Answer: Six
Correct Answer: All of the above.
Correct Answer: A functional dependency between two or more nonkey attributes.
Correct Answer: May or may not be true
Explanation:
If less work is involved in searching a element than to sort and then extract, then we don?t go for sort
If frequent use of the file is required for the purpose of retrieving specific element, it is more efficient to sort the file.
Thus it depends on situation
Comments
There are no comments.More in Technical Questions:
Programming
Copyright ©CuriousTab. All rights reserved.