Access & SQL - Quiz 1

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Yupeilin
Y
Yupeilin
Community Contributor
Quizzes Created: 7 | Total Attempts: 13,139
| Attempts: 201
SettingsSettings
Please wait...
  • 1/15 Questions

    Entity Relationship Model is a type of Objec-based data model

    • True
    • False
Please wait...
About This Quiz

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

SQL Quizzes & Trivia

Quiz Preview

  • 2. 

    Database System includes database management system, data, and applications.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    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:

  • 3. 

    Record-based data model includes relational data model, network data model,and hierarchical data model.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    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:

  • 4. 

    The description of data within the database system is called mega-data.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    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:

  • 5. 

    Which of the following is NOT one of the three phases for Database Design phase?

    • A) Global Database Design

    • B) Conceptual Database Design

    • C) Logical Database Design

    • D) Physical Database Design

    Correct Answer
    A. A) Global Database Design
    Explanation
    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:

  • 6. 

    Data model comprises all of the following, except _________

    • A) a structural part

    • B) a manipulative part

    • C) a set of integrity rules

    • D) a managerial part

    Correct Answer
    A. D) a managerial part
    Explanation
    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:

  • 7. 

    Which is not one of the evaluation criteria during testing phase?

    • A) Learnability

    • b) Performance

    • C) Robustness

    • D) Creativity

    Correct Answer
    A. D) Creativity
    Explanation
    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:

  • 8. 

    When taking the centralized approach for Requirement Collection and Analysis phase, we create local data models for each user view.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    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:

  • 9. 

    DBMS provides insulation between program and data. This is referred to as _______________

    • A) program-data independence

    • B) program-data dependence

    • C) database-data dependence

    • D) program-database independence

    Correct Answer
    A. A) program-data independence
    Explanation
    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:

  • 10. 

    Which of the following is NOT a typical DBMS functionality?

    • A) Manipulating the database

    • B) Manage the user interface of database application

    • C) Define a particular database in terms of its data types, structures and constraints

    • D) Processing and sharing by a set of concurrent users and application programs

    Correct Answer
    A. B) Manage the user interface of database application
    Explanation
    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:

  • 11. 

    Which of the following is NOT one of transaction types mentioned in class?

    • A) Retrieval transaction

    • B) Update transaction

    • C) Group transaction

    • D) Mixed transaction

    Correct Answer
    A. C) Group transaction
    Explanation
    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:

  • 12. 

    Which of the following is an advantage of using the DBMS approach?

    • A) Enforcing integrity constraints

    • B) Increasing data redundancy

    • C) Providing single user interface for different types of users

    • D) Allowing unauthorized access

    Correct Answer
    A. A) Enforcing integrity constraints
    Explanation
    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:

  • 13. 

    When we say a relationship is 1 to 1, or 1 to many, we are referring to the modality (participation).

    • True

    • False

    Correct Answer
    A. False
    Explanation
    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:

  • 14. 

    ______________ refers to a minimal set of attributes that uniquely identifies each occurrence of an entity.

    • A) Composite Key

    • B) Primary Key

    • C) Candidate Key

    • D) Super Key

    Correct Answer
    A. C) Candidate Key
    Explanation
    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:

  • 15. 

    Application Design phase includes two important activities, which are ______________ and user interface design.

    • A) table design

    • B) transaction design

    • C) data design

    • D) user view design

    Correct Answer
    A. B) transaction design
    Explanation
    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:

Quiz Review Timeline (Updated): Mar 21, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Jan 28, 2010
    Quiz Created by
    Yupeilin
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.