Access & SQL - Quiz 1

15 Questions | By Yupeilin | Updated: Mar 21, 2022 | Attempts: 192

Questions

Settings

Create your own Quiz

This quiz consists of 10 questions. You have 10 minutes to take the quiz.

Questions and Answers

1.

Which of the following is NOT one of the three phases for Database Design phase?
- A.
  
  A) Global Database Design
- B.
  
  B) Conceptual Database Design
- C.
  
  C) Logical Database Design
- D.
  
  D) Physical Database Design
2.

Application Design phase includes two important activities, which are ______________ and user interface design.
- A.
  
  A) table design
- B.
  
  B) transaction design
- C.
  
  C) data design
- D.
  
  D) user view design
3.

Which of the following is NOT one of transaction types mentioned in class?
- A.
  
  A) Retrieval transaction
- B.
  
  B) Update transaction
- C.
  
  C) Group transaction
- D.
  
  D) Mixed transaction
4.

Which is not one of the evaluation criteria during testing phase?
- A.
  
  A) Learnability
- B.
  
  b) Performance
- C.
  
  C) Robustness
- D.
  
  D) Creativity
5.

Which of the following is an advantage of using the DBMS approach?
- A.
  
  A) Enforcing integrity constraints
- B.
  
  B) Increasing data redundancy
- C.
  
  C) Providing single user interface for different types of users
- D.
  
  D) Allowing unauthorized access
6.

Which of the following is NOT a typical DBMS functionality?
- A.
  
  A) Manipulating the database
- B.
  
  B) Manage the user interface of database application
- C.
  
  C) Define a particular database in terms of its data types, structures and constraints
- D.
  
  D) Processing and sharing by a set of concurrent users and application programs
7.

When taking the centralized approach for Requirement Collection and Analysis phase, we create local data models for each user view.
- A.
  
  True
- B.
  
  False
8.

Data model comprises all of the following, except _________
- A.
  
  A) a structural part
- B.
  
  B) a manipulative part
- C.
  
  C) a set of integrity rules
- D.
  
  D) a managerial part
9.

______________ refers to a minimal set of attributes that uniquely identifies each occurrence of an entity.
- A.
  
  A) Composite Key
- B.
  
  B) Primary Key
- C.
  
  C) Candidate Key
- D.
  
  D) Super Key
10.

Entity Relationship Model is a type of Objec-based data model
- A.
  
  True
- B.
  
  False
11.

Database System includes database management system, data, and applications.
- A.
  
  True
- B.
  
  False
12.

The description of data within the database system is called mega-data.
- A.
  
  True
- B.
  
  False
13.

DBMS provides insulation between program and data. This is referred to as _______________
- A.
  
  A) program-data independence
- B.
  
  B) program-data dependence
- C.
  
  C) database-data dependence
- D.
  
  D) program-database independence
14.

When we say a relationship is 1 to 1, or 1 to many, we are referring to the modality (participation).
- A.
  
  True
- B.
  
  False
15.

Record-based data model includes relational data model, network data model,and hierarchical data model.
- A.
  
  True
- B.
  
  False