Tskafli9
13 Questions
| Attempts: 361
Spurningar úr kaflanum: (kafli 9)
Questions and Answers
- 1.
Which of the following file structures is associated with the problem of clustering?
- A.
Indexed
- B.
Sequential
- C.
Hash
- D.
Hass
Correct Answer
C. Hash -
- 2.
Given the relation below x: A B C 2 5 7 3 3 6 4 4 2 5 2 2 what values will be retrieved by the following SQL statement? select A, B from X where X.B=X.C
- A.
5,2
- B.
2,5
- C.
2,2
Correct Answer
A. 5,2 -
- 3.
Given the relation below x: A B C 2 5 7 3 3 3 4 4 2 5 2 8 what value will be retrieved by the following query? TEMP <-- SELECT from X where B = C RESULT <-- PRIJECT B from TEMP
- A.
3
- B.
5
- C.
4
Correct Answer
A. 3 -
- 4.
Which of the following file structures is most efficient in cases in which the file is always processed in its entirety a predetermined order?
- A.
Indexed
- B.
Sequential
- C.
Hash
- D.
Hass
Correct Answer
B. Sequential -
- 5.
Which of the following is not a potential problem caused by multiple transactions manipulating a database at the same time?
- A.
Clustering
- B.
Lost update problem
- C.
Deadlock
- D.
Incorrect summary problem
Correct Answer
A. Clustering -
- 6.
Which of the following relational operations combine data more than one relation?
- A.
PROJECT
- B.
JOIN
- C.
SELECT
Correct Answer
B. JOIN -
- 7.
Which of the following accesses a database in terms of a database model?
- A.
Actual database
- B.
Database management system
- C.
Application software
Correct Answer
C. Application software -
- 8.
Which of the following relational operations is performed by the SQL statement below? select A, B, C from x
- A.
PROJECT
- B.
JOIN
- C.
SELECT
Correct Answer
A. PROJECT -
- 9.
Given the two relations X and Y below X: A B Y: C D 7 s t 3 2 z r 2 what value would be retrieved by executing the following SQL statement? select Y.C from X, Y where X.A < Y.D
- A.
S
- B.
T
- C.
R
- D.
Z
Correct Answer
B. T -
- 10.
Which of the following data mining techniques would be applied when trying to identify common properties between different groups of shoppers?
- A.
Class discrimination
- B.
Cluster analysis
- C.
Class description
- D.
Association analysis
Correct Answer
D. Association analysis -
- 11.
Which of the following file structures requires a small "auxiliary" storage system that must be updated as entries in the file are inserted or deleted.
- A.
Sequential
- B.
Hash (Matti)
- C.
Indexed
- D.
LoLwut?
Correct Answer
C. Indexed -
- 12.
Which of the following relational operations extracts entire columns from a relation?
- A.
PROJECT
- B.
JOIN
- C.
SELECT
Correct Answer
A. PROJECT -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 15, 2022Quiz Edited by
ProProfs Editorial Team -
Nov 28, 2012Quiz Created by
Viddz1
Back to top