UML Lec2 Quiz

Description

Introduction to Databases
Ray Welland
Quiz by Ray Welland, updated more than 1 year ago
Ray Welland
Created by Ray Welland over 8 years ago
32
0

Resource summary

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
Show full summary Hide full summary

Similar

UML Lec1 Quiz
Ray Welland
UML Lec3 Quiz
Ray Welland
Chapter 3 : Use Cases
Jo Hart
Chapter 6 – Essentials of Design and the Design Activities
Jo Hart
French Verbs
dylankhakh
Chapter 5: Extending the Requirements Model
Jo Hart
Basics in Object Oriented Programming
Bit buddy
Metodos y modelos para desarrollo de sofware
SERGIO GIL HERRERA
los diferentes diagramas en UML
Alexis Tamayo