TSKafli9

1. Which of the following relational operations combine data more than one relation?

PROJECT

JOIN

SELECT

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

5,2

2,5

2,2

3. Which of the following file structures is associated with the problem of clustering?

Indexed

Sequential

Hash

Hass

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?

Indexed

Sequential

Hash

Hass

5. 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

S

T

R

Z

6. 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

3

5

4

7. which of the following accesses a database in terms of a database model?

Actual database

Database management system

Application software

8. Which of the following is not a potential problem caused by multiple transactions manipulating a database at the same time?

Clustering

Lost update problem

Deadlock

Incorrect summary problem

9. 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.

Sequential

Hash (Matti)

Indexed

LoLwut?

10. Which of the following data mining techniques would be applied when trying to identify common properties between different groups of shoppers?

Class discrimination

Cluster analysis

Class description

Association analysis

11. Which of the following relational operations extracts entire columns from a relation?

PROJECT

JOIN

SELECT

12. Which of the following relational operations is performed by the SQL statement below? select A, B, C from x

PROJECT

JOIN

SELECT

13. SHIT marhhh

relation

roll back

database model

SQL

relational operations

schema

commit point

DBMS

Submit

Tskafli9

1. Which of the following relational operations combine data more than one relation?

2.

What first name or nickname would you like us to use?

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

3. Which of the following file structures is associated with the problem of clustering?

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?

5. 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

6. 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

7. which of the following accesses a database in terms of a database model?

8. Which of the following is not a potential problem caused by multiple transactions manipulating a database at the same time?

9. 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.

10. Which of the following data mining techniques would be applied when trying to identify common properties between different groups of shoppers?

11. Which of the following relational operations extracts entire columns from a relation?

12. Which of the following relational operations is performed by the SQL statement below? select A, B, C from x

13. SHIT marhhh