UML Lec2 Quiz

Question 1 of 21

1

Select all that are TRUE about Databases

Select one or more of the following:

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.

Explanation

Question 2 of 21

1

A DBMS is a software system that enables users to define, create, and maintain the database and that provides controlled access to this database?

Select one of the following:

True
False

Explanation

Question 3 of 21

1

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.

Select one of the following:

True
False

Explanation

Question 4 of 21

1

What are 'Views'?

Select one of the following:

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

Explanation

Question 5 of 21

1

Select ALL that are TRUE about 'Views'

Select one or more of the following:

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.

Explanation

Question 6 of 21

1

What are components of a DBMS Environment?

Select one or more of the following:

ACARS Monitoring
Hardware and Software
Data
Procedures
People

Explanation

Question 7 of 21

1

What are true about a Two-Tier Client-Server?

Select one or more of the following:

Client manages main business and data processing logic and user interface
Server manages and controls access to database
Third Party manage server

Explanation

Question 8 of 21

1

What are true about Three-Tier Architecture?

Select one or more of the following:

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)

Explanation

Question 9 of 21

1

What are the advantages of the Three-Tier Architecture?

Select one or more of the following:

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

Explanation

Question 10 of 21

1

Select ALL that are True about Functions of a DBMS

Select one or more of the following:

A User-Accessible Catalog
Data Storage, Retrieval, and Update
Concurrency Control Services
Recovery Services
Transaction Support

Explanation

Question 11 of 21

1

Select ALL that are True about Functions of a DBMS

Select one or more of the following:

Integrity Services
Utility Services
Services to Promote Data Independence
Support for Data Communication
Authorization Services

Explanation

Question 12 of 21

1

What is NOT an advantage of DBMS

Select one of the following:

Improved data integrity
Sharing of data
Data consistency
Control of data redundancy
Limited to one Super Administator
Improved maintenance through data independence

Explanation

Question 13 of 21

1

What is NOT an disadvantage of DBMS

Select one of the following:

Cost of conversion
Cost of DBMS
Complexity
Performance
Higher impact of a failure
Intuitive and easy to setup

Explanation

Question 14 of 21

1

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?

Select one or more of the following:

a structural part
a manipulative part
a set of integrity rules

Explanation

Question 15 of 21

1

Which Relational Model Terminologies are correct?

Select one or more of the following:

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

Explanation

Question 16 of 21

1

Each Table and Column name should be distinct?

Select one of the following:

True
False

Explanation

Question 17 of 21

1

A Superkey is a column, or a set of columns, that uniquely identifies a record within a table.

Select one of the following:

True
False

Explanation

Question 18 of 21

1

A Candidate Key is the Maximum type of Superkey

Select one of the following:

True
False

Explanation

Question 19 of 21

1

Select ALL Relational Key that are correct

Select one or more of the following:

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

Explanation

Question 20 of 21

1

Select ALL that are True regarding Relational Integrity

Select one or more of the following:

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

Explanation

Question 21 of 21

1

The two main Relational Languages are Structured Query Language and Query-by-Example?

Select one of the following:

True
False

	Created by Ray Welland about 10 years ago

Introduction to Databases

UML Lec2 Quiz

Question 1 of 21

Select all that are TRUE about Databases

Select one or more of the following:

Explanation

Question 2 of 21

A DBMS is a software system that enables users to define, create, and maintain the database and that provides controlled access to this database?

Select one of the following:

Explanation

Question 3 of 21

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.

Select one of the following:

Explanation

Question 4 of 21

What are 'Views'?

Select one of the following:

Explanation

Question 5 of 21

Select ALL that are TRUE about 'Views'

Select one or more of the following:

Explanation

Question 6 of 21

What are components of a DBMS Environment?

Select one or more of the following:

Explanation

Question 7 of 21

What are true about a Two-Tier Client-Server?

Select one or more of the following:

Explanation

Question 8 of 21

What are true about Three-Tier Architecture?

Select one or more of the following:

Explanation

Question 9 of 21

What are the advantages of the Three-Tier Architecture?

Select one or more of the following:

Explanation

Question 10 of 21

Select ALL that are True about Functions of a DBMS

Select one or more of the following:

Explanation

Question 11 of 21

Select ALL that are True about Functions of a DBMS

Select one or more of the following:

Explanation

Question 12 of 21

What is NOT an advantage of DBMS

Select one of the following:

Explanation

Question 13 of 21

What is NOT an disadvantage of DBMS

Select one of the following:

Explanation

Question 14 of 21

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?

Select one or more of the following:

Explanation

Question 15 of 21

Which Relational Model Terminologies are correct?

Select one or more of the following:

Explanation

Question 16 of 21

Each Table and Column name should be distinct?

Select one of the following:

Explanation

Question 17 of 21

A Superkey is a column, or a set of columns, that uniquely identifies a record within a table.

Select one of the following:

Explanation

Question 18 of 21

A Candidate Key is the Maximum type of Superkey

Select one of the following:

Explanation

Question 19 of 21

Select ALL Relational Key that are correct

Select one or more of the following:

Explanation

Question 20 of 21

Select ALL that are True regarding Relational Integrity