1. Applications must not keep up with changing user requirements against the database Verdadero Falso.
2. A binary relationship is a relationship of a. degree 3 b. degree 2 c. degree 1.
3. When a DBMS may be unnecessary a. If the database and applications are simple, well defined, and not expected to change. b. The previous two are correct. c. The previous two are incorrect d. If access to data by multiple users is not required.
4. Generalization is: a. the process of defining a set of subclasses of a superclass. b. the reverse of the specialization process.
5. In a lattice or hierarchy , a subclass inherits attributes not only of its direct superclass, but also of all its predecessor superclasses Verdadero Falso.
6. Existence Constraint / Participation Constraint specifies: a. maximum participation b. minimum participation.
7. Applications interact with a database by generating queries and transactions. Choose the correct option about “queries”. a. Queries: that access different parts of data and formulate the result of a request. b. Queries: that may read some data and “update” certain values or generate new data and store that in the database.
8. What is the meaning of NOSQL? a. Not Online SQL b. Not Override SQL. c. Not Only SQL d. Not Obviously SQL.
9. DBMS does not require changes to application program due to... a. Independence role b. Concurrency role c. Interface program-data independence.
10. Select the correct answer regarding the end-users: a. They use the data only for queries. b. They use the data for queries, reports and some of them update the database content. c. They use the data only for updates.
11. A multivaluated attribute… a. may be composed of several components b. may form a hierarchy where some components are themselves composite. c.may have multiple values.
12. Choose the correct definition of the Data: a. Known facts that can be recorded and have an implicit meaning. b. A collection of related data c. A software package/ system to facilitate the creation and maintenance of a computerized database. d. Some part of the real world about which data is stored in a database.
13. An entity that is member of a subclass inherits: a. All relationships of the entity as a member of the superclass but not the attributes. b. All attributes of the entity as a member of the superclass and all relationships of the entity as a member of the superclass c. All attributes of the entity as a member of the superclass but not the relationships.
14. what is the cardinality if a client books one or many rooms and a room is booked by one or more clients? a. (m:n) b. (1:n) c. (0:n).
They understand the user requirements of naïve and sophisticated users and design applications including canned transactions to meet those requirements. a. Application programmers b. System analysts c. Business analysts.
Naïve makes up a sizable portion of database end-users: a. Verdadero b. Falso.
17. INSERT may violate any of the next constraints: a. Key constraint,Referential integrity constraint,Entity integrity b. Domain constraint,Key constraint,Referential integrity constraint c. Domain constraint,Key constraint,Referential integrity constraint,Entity integrity.
Relational model... a. Was proposed by Boyle Codd b. Was proposed by Frederic Codd c.Was proposed by E.F Codd.
19. Entities are… a. a data type associated with an attribute b. specific things or objects in the mini-world that are represented in the database c. properties used to describe a relationship.
20. Users of Mobile Apps are... a. Naïve users b. Casual users c. Beginners users.
|
