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