701902
Descripción
Test por Ray Welland, actualizado hace más de 1 año
|
Creado por Ray Welland
hace más de 10 años
|
|
Pregunta 1
Pregunta
Select all that are TRUE about Databases
Respuesta
-
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.
Pregunta 2
Pregunta
A DBMS is a software system that enables users to define, create, and maintain the database and that provides controlled access to this database?
Respuesta
- True
- False
Pregunta 3
Pregunta
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.
Respuesta
- True
- False
Pregunta 4
Pregunta
What are 'Views'?
Respuesta
-
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
Pregunta 5
Pregunta
Select ALL that are TRUE about 'Views'
Respuesta
-
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.
Pregunta 6
Pregunta
What are components of a DBMS Environment?
Respuesta
-
ACARS Monitoring
-
Hardware and Software
-
Data
-
Procedures
-
People
Pregunta 7
Pregunta
What are true about a Two-Tier Client-Server?
Respuesta
-
Client manages main business and data processing logic and user interface
-
Server manages and controls access to database
-
Third Party manage server
Pregunta 8
Pregunta
What are true about Three-Tier Architecture?
Respuesta
-
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)
Pregunta 9
Pregunta
What are the advantages of the Three-Tier Architecture?
Respuesta
-
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
Pregunta 10
Pregunta
Select ALL that are True about Functions of a DBMS
Respuesta
-
A User-Accessible Catalog
-
Data Storage, Retrieval, and Update
-
Concurrency Control Services
-
Recovery Services
-
Transaction Support
Pregunta 11
Pregunta
Select ALL that are True about Functions of a DBMS
Respuesta
-
Integrity Services
-
Utility Services
-
Services to Promote Data Independence
-
Support for Data Communication
-
Authorization Services
Pregunta 12
Pregunta
What is NOT an advantage of DBMS
Respuesta
-
Improved data integrity
-
Sharing of data
-
Data consistency
-
Control of data redundancy
-
Limited to one Super Administator
-
Improved maintenance through data independence
Pregunta 13
Pregunta
What is NOT an disadvantage of DBMS
Respuesta
-
Cost of conversion
-
Cost of DBMS
-
Complexity
-
Performance
-
Higher impact of a failure
-
Intuitive and easy to setup
Pregunta 14
Pregunta
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?
Respuesta
-
a structural part
-
a manipulative part
-
a set of integrity rules
Pregunta 15
Pregunta
Which Relational Model Terminologies are correct?
Respuesta
-
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
Pregunta 16
Pregunta
Each Table and Column name should be distinct?
Respuesta
- True
- False
Pregunta 17
Pregunta
A Superkey is a column, or a set of columns, that uniquely identifies a record within a table.
Respuesta
- True
- False
Pregunta 18
Pregunta
A Candidate Key is the Maximum type of Superkey
Respuesta
- True
- False
Pregunta 19
Pregunta
Select ALL Relational Key that are correct
Respuesta
-
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
Pregunta 20
Pregunta
Select ALL that are True regarding Relational Integrity
Respuesta
-
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
Pregunta 21
Pregunta
The two main Relational Languages are Structured Query Language and Query-by-Example?
Respuesta
- True
- False
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.