Test
UML Lec2 Quiz
Crea una cuenta gratis para terminar este test
Guarda tu progreso y consulta tu resultado final.
¿Ya tienes cuenta? Inicia sesión
Preguntas del test (21)
1Select all that are TRUE about Databases
- AShared collection of logically related data (and a description of this data), designed to meet the information needs of an organization
- BShared collection: can be used simultaneously by many departments and users
- CLogically related: comprises the important objects and the relationships between these objects.
2A DBMS is a software system that enables users to define, create, and maintain the database and that provides controlled access to this database?
- AVerdadero
- BFalso
3A 'Database Application Program' is a software program that interacts with the database by issuing an appropriate request (typically an SQL statement) to the DBMS.
- AVerdadero
- BFalso
4What are 'Views'?
- AAllows each user to connect to the network
- BAllows each user to have his or her own view of the database
- CAllows each user to connect to the database
5Select ALL that are TRUE about 'Views'
- AProvide a level of security
- BProvide a mechanism to customize the appearance of the database
- CProvide the benefit of regular database backups
- DPresent a consistent, unchanging picture of the structure of the database, even if the underlying database is changed.
6What are components of a DBMS Environment?
- AACARS Monitoring
- BHardware and Software
- CData
- DProcedures
- EPeople
7What are true about a Two-Tier Client-Server?
- AClient manages main business and data processing logic and user interface
- BServer manages and controls access to database
- CThird Party manage server
8What are true about Three-Tier Architecture?
- ABusiness logic and data processing layer, middle tier runs on a server (application server)
- BUser interface layer runs on client
- CMakes use of the Cloud
- DDBMS stores data required by the middle tier. This tier may be on a separate server (database server)
9What are the advantages of the Three-Tier Architecture?
- AApplication maintenance centralized
- B‘Thin’ client, requiring less expensive hardware
- CEasier to modify or replace one tier without affecting others
- DBackups are always and only run off site for redundancy
- EMaps quite naturally to Web environment
- FSeparating business logic from database functions makes it easier to implement load balancing
10Select ALL that are True about Functions of a DBMS
- AA User-Accessible Catalog
- BData Storage, Retrieval, and Update
- CConcurrency Control Services
- DRecovery Services
- ETransaction Support
11Select ALL that are True about Functions of a DBMS
- AIntegrity Services
- BUtility Services
- CServices to Promote Data Independence
- DSupport for Data Communication
- EAuthorization Services
12What is NOT an advantage of DBMS
- AImproved data integrity
- BSharing of data
- CData consistency
- DControl of data redundancy
- ELimited to one Super Administator
- FImproved maintenance through data independence
13What is NOT an disadvantage of DBMS
- ACost of conversion
- BCost of DBMS
- CComplexity
- DPerformance
- EHigher impact of a failure
- FIntuitive and easy to setup
14A Data Model is a Integrated collection of concepts for describing data, relationships between data, and constraints on the data. What are the three components?
- Aa structural part
- Ba manipulative part
- Ca set of integrity rules
15Which Relational Model Terminologies are correct?
- ARelation: table with columns and rows
- BAttribute: named column of a relation
- CDomain: set of allowable values for one or more attributes
- DTuple: a record of a relation
- ERelational Database - collection of normalized relations with distinct relation names
16Each Table and Column name should be distinct?
- AVerdadero
- BFalso
17A Superkey is a column, or a set of columns, that uniquely identifies a record within a table.
- AVerdadero
- BFalso
18A Candidate Key is the Maximum type of Superkey
- AVerdadero
- BFalso
19Select ALL Relational Key that are correct
- APrimary Key: Candidate key selected to identify records uniquely within table
- BAlternate Keys: Candidate keys that are not selected to be primary key
- CMaster Key: Candidate keys that are equivalent to the Primary Key
- DForeign Key: Column, or set of columns, within one table that matches candidate key of some (possibly same) table
20Select ALL that are True regarding Relational Integrity
- AEntity Integrity: In a base table, no column of a primary key can be null
- BReferential Integrity: If FK exists in a table, either FK value must match a candidate key value of some record in its home table or FK value must be wholly null
- CRelational Integrity: If FK exists in a table, either FK value must match a candidate key value of some record in its home table or FK value must be wholly null
- DNull Value: Represents value for a column that is currently unknown or not applicable for record
21The two main Relational Languages are Structured Query Language and Query-by-Example?
- AVerdadero
- BFalso
Información
- Descripción
- Introduction to Databases
- Autor
- Ray Welland
- Idioma
- English
- Visitas
- 83
- Etiquetas
- Valoración
- Aún sin valoraciones Valora este test