701902
Descrição
Quiz por Ray Welland, atualizado more than 1 year ago
|
Criado por Ray Welland
aproximadamente 10 anos atrás
|
|
Questão 1
Questão
Select all that are TRUE about Databases
Responda
-
Shared collection of logically related data (and a description of this data), designed to meet the information needs of an organization
-
Shared collection: can be used simultaneously by many departments and users
-
Logically related: comprises the important objects and the relationships between these objects.
Questão 2
Questão
A DBMS is a software system that enables users to define, create, and maintain the database and that provides controlled access to this database?
Responda
- True
- False
Questão 3
Questão
A 'Database Application Program' is a software program that interacts with the database by issuing an appropriate request (typically an SQL statement) to the DBMS.
Responda
- True
- False
Questão 4
Questão
What are 'Views'?
Responda
-
Allows each user to connect to the network
-
Allows each user to have his or her own view of the database
-
Allows each user to connect to the database
Questão 5
Questão
Select ALL that are TRUE about 'Views'
Responda
-
Provide a level of security
-
Provide a mechanism to customize the appearance of the database
-
Provide the benefit of regular database backups
-
Present a consistent, unchanging picture of the structure of the database, even if the underlying database is changed.
Questão 6
Questão
What are components of a DBMS Environment?
Responda
-
ACARS Monitoring
-
Hardware and Software
-
Data
-
Procedures
-
People
Questão 7
Questão
What are true about a Two-Tier Client-Server?
Responda
-
Client manages main business and data processing logic and user interface
-
Server manages and controls access to database
-
Third Party manage server
Questão 8
Questão
What are true about Three-Tier Architecture?
Responda
-
Business logic and data processing layer, middle tier runs on a server (application server)
-
User interface layer runs on client
-
Makes use of the Cloud
-
DBMS stores data required by the middle tier. This tier may be on a separate server (database server)
Questão 9
Questão
What are the advantages of the Three-Tier Architecture?
Responda
-
Application maintenance centralized
-
‘Thin’ client, requiring less expensive hardware
-
Easier to modify or replace one tier without affecting others
-
Backups are always and only run off site for redundancy
-
Maps quite naturally to Web environment
-
Separating business logic from database functions makes it easier to implement load balancing
Questão 10
Questão
Select ALL that are True about Functions of a DBMS
Responda
-
A User-Accessible Catalog
-
Data Storage, Retrieval, and Update
-
Concurrency Control Services
-
Recovery Services
-
Transaction Support
Questão 11
Questão
Select ALL that are True about Functions of a DBMS
Responda
-
Integrity Services
-
Utility Services
-
Services to Promote Data Independence
-
Support for Data Communication
-
Authorization Services
Questão 12
Questão
What is NOT an advantage of DBMS
Responda
-
Improved data integrity
-
Sharing of data
-
Data consistency
-
Control of data redundancy
-
Limited to one Super Administator
-
Improved maintenance through data independence
Questão 13
Questão
What is NOT an disadvantage of DBMS
Responda
-
Cost of conversion
-
Cost of DBMS
-
Complexity
-
Performance
-
Higher impact of a failure
-
Intuitive and easy to setup
Questão 14
Questão
A Data Model is a Integrated collection of concepts for describing data, relationships between data, and constraints on the data. What are the three components?
Responda
-
a structural part
-
a manipulative part
-
a set of integrity rules
Questão 15
Questão
Which Relational Model Terminologies are correct?
Responda
-
Relation: table with columns and rows
-
Attribute: named column of a relation
-
Domain: set of allowable values for one or more attributes
-
Tuple: a record of a relation
-
Relational Database - collection of normalized relations with distinct relation names
Questão 16
Questão
Each Table and Column name should be distinct?
Responda
- True
- False
Questão 17
Questão
A Superkey is a column, or a set of columns, that uniquely identifies a record within a table.
Responda
- True
- False
Questão 18
Questão
A Candidate Key is the Maximum type of Superkey
Responda
- True
- False
Questão 19
Questão
Select ALL Relational Key that are correct
Responda
-
Primary Key: Candidate key selected to identify records uniquely within table
-
Alternate Keys: Candidate keys that are not selected to be primary key
-
Master Key: Candidate keys that are equivalent to the Primary Key
-
Foreign Key: Column, or set of columns, within one table that matches candidate key of some (possibly same) table
Questão 20
Questão
Select ALL that are True regarding Relational Integrity
Responda
-
Entity Integrity: In a base table, no column of a primary key can be null
-
Referential 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
-
Relational 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
-
Null Value: Represents value for a column that is currently unknown or not applicable for record
Questão 21
Questão
The two main Relational Languages are Structured Query Language and Query-by-Example?
Responda
- True
- False
Quer criar seus próprios Quizzes gratuitos com a GoConqr? Saiba mais.