Access & SQL - Quiz 1
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
Correct Answer
A. A) Global Database DesignExplanation
The correct answer is a) Global Database Design. This is not one of the three phases for Database Design. The three phases for Database Design are Conceptual Database Design, Logical Database Design, and Physical Database Design. Global Database Design is not a recognized phase in the process of designing a database.Rate this question:
-
- 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
Correct Answer
B. B) transaction designExplanation
In the application design phase, two important activities are mentioned - transaction design and user interface design. Transaction design refers to the process of designing the flow and structure of the transactions that will occur within the application. This includes defining the steps, inputs, outputs, and logic involved in each transaction. User interface design, on the other hand, focuses on designing the visual and interactive elements of the application that users will interact with. Therefore, the correct answer is b) transaction design.Rate this question:
-
- 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
Correct Answer
C. C) Group transactionExplanation
The correct answer is c) Group transaction. In the given question, the options are transaction types mentioned in class, and the task is to identify the option that is not mentioned. The options a) Retrieval transaction, b) Update transaction, and d) Mixed transaction are commonly mentioned transaction types. However, "Group transaction" is not mentioned as a transaction type in the class.Rate this question:
-
- 4.
Which is not one of the evaluation criteria during testing phase?
- A.
A) Learnability
- B.
b) Performance
- C.
C) Robustness
- D.
D) Creativity
Correct Answer
D. D) CreativityExplanation
During the testing phase, the evaluation criteria typically focus on the functionality and effectiveness of the system being tested. Learnability assesses how easily users can understand and use the system. Performance measures the system's speed and efficiency. Robustness evaluates the system's ability to handle errors and unexpected inputs. Creativity, on the other hand, is not a typical evaluation criterion during testing as it is subjective and does not directly relate to the functionality or effectiveness of the system.Rate this question:
-
- 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
Correct Answer
A. A) Enforcing integrity constraintsExplanation
The advantage of using the DBMS approach is that it allows for the enforcement of integrity constraints. This means that the system can ensure that the data stored in the database is accurate and consistent, by preventing any invalid or inconsistent data from being entered or stored. This helps to maintain data integrity and reliability, which is crucial for the overall quality and usability of the database.Rate this question:
-
- 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
Correct Answer
B. B) Manage the user interface of database applicationExplanation
The correct answer is b) Manage the user interface of database application. This is not a typical DBMS functionality because DBMS focuses on managing the storage, retrieval, and manipulation of data in a database, rather than managing the user interface. User interface management is usually handled by separate software applications or frameworks that interact with the DBMS.Rate this question:
-
- 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
Correct Answer
B. FalseExplanation
In the centralized approach for Requirement Collection and Analysis phase, we do not create local data models for each user view. Instead, we create a single centralized data model that represents the entire system. This allows for better coordination and consistency in the requirements and analysis process. Therefore, the correct answer is False.Rate this question:
-
- 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
Correct Answer
D. D) a managerial partExplanation
The data model is a conceptual representation of the data structure, relationships, and constraints within a database system. It consists of a structural part, which defines the entities and their attributes, and a manipulative part, which specifies the operations that can be performed on the data. Additionally, it includes a set of integrity rules to ensure data consistency and accuracy. However, a data model does not typically include a managerial part, as this is more related to the administration and decision-making aspects of the database system.Rate this question:
-
- 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
Correct Answer
C. C) Candidate KeyExplanation
A candidate key refers to a minimal set of attributes that uniquely identifies each occurrence of an entity. It is called a candidate key because it is a potential candidate for being chosen as the primary key of a relation. In other words, it is a set of attributes that can uniquely identify each tuple in a relation, without any redundancy.Rate this question:
-
- 10.
Entity Relationship Model is a type of Objec-based data model
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The Entity Relationship Model is a type of object-based data model. This model is used to represent the relationships between different entities in a database. It focuses on the relationships between entities rather than the attributes and operations of each entity. This model is widely used in database design to create a visual representation of the database structure, making it easier to understand and manage the relationships between different entities. Therefore, the statement "Entity Relationship Model is a type of Object-based data model" is true.Rate this question:
-
- 11.
Database System includes database management system, data, and applications.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
A database system consists of three main components: the database management system (DBMS), which is responsible for managing and controlling the database, the data itself, which is organized and stored in the database, and the applications, which interact with the DBMS to retrieve, manipulate, and update the data. Therefore, the statement "Database System includes database management system, data, and applications" is true.Rate this question:
-
- 12.
The description of data within the database system is called mega-data.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The description of data within the database system is not called mega-data. The correct term for describing the data within a database system is metadata. Metadata provides information about the structure, organization, and properties of the data stored in a database. Mega-data is not a recognized term in the field of database management.Rate this question:
-
- 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
Correct Answer
A. A) program-data independenceExplanation
DBMS provides insulation between program and data, allowing them to be independent of each other. This means that changes made to the program will not affect the data, and changes made to the data will not affect the program. This separation allows for flexibility and ease of maintenance, as modifications can be made to either the program or the data without impacting the other. Therefore, the correct answer is program-data independence.Rate this question:
-
- 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
Correct Answer
B. FalseExplanation
The given statement is false. When we say a relationship is 1 to 1 or 1 to many, we are not referring to the modality or participation. Instead, we are referring to the cardinality of the relationship, which describes the number of instances of one entity that can be associated with the number of instances of another entity. Modality, on the other hand, refers to the minimum and maximum participation of an entity in a relationship.Rate this question:
-
- 15.
Record-based data model includes relational data model, network data model,and hierarchical data model.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The statement is true because the record-based data model does include the relational data model, network data model, and hierarchical data model. These models are all different ways of organizing and representing data in a database. The relational data model organizes data into tables with rows and columns, the network data model organizes data into a graph-like structure, and the hierarchical data model organizes data into a tree-like structure. Therefore, the statement is correct.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Jan 28, 2010Quiz Created by
Yupeilin
Back to top