Discussion
Home ‣ Technical Questions ‣ Database Comments
- Question
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.
- Correct Answer
- to accomplish both of the above.
- 1. 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
- 2. Which of the following products implemented the CODASYL DBTG model?
Options- A. IDMS
- B. DB2
- C. dBase-II
- D. R:base Discuss
- 3. 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 Discuss
- 4. If you are using C language to implement the heterogeneous linked list, what pointer type will you use? Discuss
- 5. The time complexity of sequential search is
Options- A. O(n)
- B. O(2n)
- C. O(n^2)
- D. None Discuss
- 6. 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
- 7. SQL Server program code that is executed instead of an SQL command that needs to be processed is called
Options- A. INSTEAD OF trigger.
- B. BEFORE trigger.
- C. AFTER trigger.
- D. BEGIN trigger. Discuss
- 8. The expression FOR XML RAW tells SQL Server to:
Options- A. place the values of the columns as attributes in the resulting XML document.
- B. place the values of the columns into elements rather than attributes.
- C. place some columns into elements and others into attributes.
- D. None of the above is correct. Discuss
- 9. The "curse of dimensionality" relates to which problem of using operational data for BI reporting?
Options- A. Dirty data
- B. Inconsistent data
- C. Too much data
- D. Non-integrated data Discuss
- 10. A report generated by a reporting system is delivered to the appropriate users via a user-accessed Web site. This system uses which of the following report modes?
Options- A. Push
- B. Pull
- C. RFM
- D. OLAP Discuss
Database problems
Search Results
Correct Answer: Maximum cardinality
Correct Answer: IDMS
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.
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
Correct Answer: O(n)
Explanation:
The time complexity of sequential search is O(n)
Correct Answer: Nonrepeatable read
Correct Answer: INSTEAD OF trigger.
Correct Answer: place the values of the columns as attributes in the resulting XML document.
Correct Answer: Too much data
Correct Answer: Pull
Comments
There are no comments.More in Technical Questions:
Programming
Copyright ©CuriousTab. All rights reserved.