Database problems
- 1. The relationship where both the participating entities belong to same entity type is called
Options- A. Participation
- B. Recursive
- C. Standard
- D. Normal Also asked in: Database Administrator
Correct Answer: Recursive
Explanation:
The relationship where both the participating entities belong to same entity type is called Recursive relationship
- 2. Which among the following is the relationship constraints
Options- A. Cardinality ratio
- B. Participation constraints
- C. Both A and B
- D. None of the above Also asked in: Database Administrator
Correct Answer: Both A and B
Explanation:
Both of them are relation ship constraints
- 3. Which among the following is the disadvantage of circular list?
Options- A. An info field that contains the information stored in the node
- B. Can?t traverse the list backward
- C. A pointer to the node is given we cannot delete the node
- D. Both 2 and 3 Also asked in: Database Administrator
Correct Answer: Both 2 and 3
Explanation:
Both 2 and 3 are clearly the diadvantages of circular list
- 4. The time complexity of sequential search is
Options- A. O(n)
- B. O(2n)
- C. O(n^2)
- D. None Also asked in: Database Administrator
Correct Answer: O(n)
Explanation:
The time complexity of sequential search is O(n)
- 5. If you are using C language to implement the heterogeneous linked list, what pointer type will you use? Also asked in: Database Administrator
Correct Answer: The heterogeneous linked list contains different data types in its nodes and we need a link, pointer to connect them It is not possible to use ordinary pointers for this So we go for void pointer Void pointer is capable of storing pointer to any type as it is a generic pointer type
- 6. Does the minimum spanning tree of a graph give the shortest distance between any 2 specified nodes?
Options- A. Yes
- B. No
- C. May be Yes or No
- D. None Also asked in: Database Administrator
Correct Answer: No
Explanation:
No.Minimal spanning tree assures that the total weight of the tree is kept at its minimum. But it doesn?t mean that the distance between any two nodes involved in the minimum-spanning tree is minimum.
- 7. Which of the following products implemented the CODASYL DBTG model?
Options- A. IDMS
- B. DB2
- C. dBase-II
- D. R:base Discuss
Correct Answer: IDMS
- 8. Which of the following indicates the maximum number of entities that can be involved in a relationship?
Options- A. Minimum cardinality
- B. Maximum cardinality
- C. ERD
- D. Greater Entity Count (GEC) Discuss
Correct Answer: Maximum cardinality
- 9. A reason for using an SQL view to hide columns is:
Options- A. to simplify a result only.
- B. to prevent the display of sensitive data only.
- C. to accomplish both of the above.
- D. None of the above are reasons for using an SQL view. Discuss
Correct Answer: to accomplish both of the above.
- 10. Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction?
Options- A. Nonrepeatable read
- B. Phantom read
- C. Dirty read
- D. Consistent read Discuss
Correct Answer: Nonrepeatable read
More in Technical Questions:
Programming
Copyright ©CuriousTab. All rights reserved.