- Flume is a tool for converting data back and forth between a relational database and the HDFS.
False
2. Automatic query optimization means that the:
DBMS finds the most cost-effective access path without user intervention.
3. _____ can render data useless to unauthorized users who might have violated some of the database security layers.
Data encryption
4. Which statement describes a feature of Oracle sequences?
Dropping a sequence does not delete values assigned to table attributes; it deletes only the sequence object from the database.
5. The _____ component of a CASE tool produces the information system’s input/output formats.
screen painter and report generator
6. Which of the following is true of a web application server?
It provides security and authentication of users through user IDs and passwords.
7. The scheduler establishes the order in which the operations within concurrent transactions are executed.
True
8. An atomic attribute _____.
cannot be further subdivided
9. A(n) _____ specifically reserves access to the transaction that locked the object.
exclusive lock
10. The effects of bad database design, implementation, and management are magnified in an environment in which the number of transactions is less than one hundred.
False
11. Advanced OLAP feature become more useful when access to them is kept simple.
True
12. The storage locations for multiple backups must include sites inside and outside the organization.
True
13. Fully equivalent means that the optimized query results are always the same as the original query.
True
14. _____ transparency exists when the end user or programmer must specify the database fragment names but does not need to specify where these fragments are located.
Location
15. An operational database is sometimes referred to as an enterprise database.
False
16. In the single-site processing, single-site data (SPSD) scenario, all processing must be done on the end user’s side of the system.
False
17. Which of the following is a specialization hierarchy overlapping constraint scenario in case of partial completeness?
Supertype has optional subtypes.
18. The database contents might be loaded interactively or in batch mode using a variety of methods and devices including customized user programs.
True
19. A _____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.
weak
20. Which query is used to list a unique value for V_CODE, where the list will produce only a list of those values that are different from one another?
SELECT DISTINCT V_CODE
FROM PRODUCT;
21. In the relational model, _____ are important because they are used to ensure that each row in a table is uniquely identifiable.
keys
22. ______ minimizes the number of disk reads necessary to retrieve a row of data.
Row-centric storage
23. The reliance on _____ as the design methodology for relational databases is seen as a stumbling block to its use in OLAP systems.
normalization
24. Which of the following is true of business rules?
They can serve as a communication tool between the users and designers.
Other Links:
See other websites for quiz:
Check on QUIZLETCheck on CHEGG