Quiz
UML Lec2 Quiz
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (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?
- ATrue
- BFalse
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.
- ATrue
- BFalse
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?
- ATrue
- BFalse
17A Superkey is a column, or a set of columns, that uniquely identifies a record within a table.
- ATrue
- BFalse
18A Candidate Key is the Maximum type of Superkey
- ATrue
- BFalse
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?
- ATrue
- BFalse
Information
- Description
- Introduction to Databases
- Author
- Ray Welland
- Language
- English
- Views
- 83
- Tags
- Rating
- No ratings yet Rate this quiz