Database Management System (DBMS)

361. Which query joins many dimension of tables to a fact table which contains large amount of rows and uses aggregate:

1. IBM
2. SQL
3. ANSI
4. ORACLE

View answer

362. Which valued facts formalize the concept of functional dependency:

1. Single-valued
2. Double-valued
3. Both
4. None

View answer

363. Which relationship model provides a starting point for identifying schemas and integrity constraints:

1. Entity
2. Referential
3. Both
4. None

View answer

364. FD stands for:

1. Formal dependency
2. Functional dependency
3. Fact dependency
4. Superset dependency

View answer

365. Which is derived from mathematical theory:

1. IBM
2. SQL
3. ANSI
4. FD

View answer

366. Which are dependent on the information of what can be stored in the relation and serve as integrity constraints:

1. IBM
2. SQL
3. ANSI
4. FD

View answer

367. A relation state r of R that satisfies the functional dependency constraints is called ___________ of R:

1. Legal relation state
2. Unlegal relation state
3. FD
4. All of these

View answer

368. How many various types of dependencies:

1. 1
2. 2
3. 3
4. 4

View answer

369. Which are the dependencies types:

1. Full functional dependency
2. Partial dependency
3. Trivial functional dependency
4. All of these

View answer

370. FDs are the types of constraints that are based on:

1. Key
2. Key revisited
3. Superset key
4. None of these

View answer