Multiple Choice Questions -database Concepts

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 Aparnasunil75
A
Aparnasunil75
Community Contributor
Quizzes Created: 20 | Total Attempts: 43,326
| Attempts: 1,688
SettingsSettings
Please wait...
  • 1/15 Questions

    Which one of the following attribute can be taken as a primary key ?

    • Name
    • Street
    • ID
    • Department
Please wait...
About This Quiz

This quiz focuses on fundamental database concepts within relational models, including cardinality, schema, and data records, emphasizing data independence and management advantages.

Multiple Choice Questions -database Concepts - Quiz

Quiz Preview

  • 2. 

    DBMS helps to achieve

    • Data independence

    • Centralised control of data

    • Neither (A) or (B)

    • Both A and B

    Correct Answer
    A. Both A and B
    Explanation
    DBMS (Database Management System) helps to achieve both data independence and centralized control of data. Data independence refers to the ability to modify the database schema without affecting the applications that use the data. This allows for flexibility and ease of maintenance. Centralized control of data means that the DBMS provides a centralized location for managing and controlling access to the data, ensuring data integrity and security. Therefore, the correct answer is "Both A and B".

    Rate this question:

  • 3. 

    A attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation .

    • Candidate

    • Primary

    • Super

    • Sub

    Correct Answer
    A. Primary
    Explanation
    A attribute in a relation is a foreign key if the primary key from one relation is used as an attribute in that relation. This means that the attribute in question is referencing the primary key of another relation, establishing a relationship between the two relations. The foreign key helps maintain referential integrity and ensures that the values in the attribute correspond to valid values in the referenced primary key.

    Rate this question:

  • 4. 

    Data about data is normally termed as:

    • Directory   

    • Data bank

    • Metadata

    • None of the above

    Correct Answer
    A. Metadata
    Explanation
    Metadata refers to the data about data. It provides information about the characteristics, structure, and content of data. It helps in organizing, managing, and understanding the data by providing context and meaning. In this case, the correct answer is "metadata" because it accurately describes the concept of data about data.

    Rate this question:

  • 5. 

    An advantage of the database management approach is

    • Data is dependent on programs.

    • Data redundancy increases.

    • Data is integrated and can be accessed by multiple programs.

    • None of the above.

    Correct Answer
    A. Data is integrated and can be accessed by multiple programs.
    Explanation
    The advantage of the database management approach is that data is integrated and can be accessed by multiple programs. This means that the data is centralized in a database, making it easier for different programs to access and use the same data. This eliminates the need for each program to have its own separate data storage and reduces data redundancy. It also ensures data consistency and integrity, as any changes made to the data are reflected across all programs that access it.

    Rate this question:

  • 6. 

    Key to represent the relationship between tables is called

    • Primary key      

    • Secondary key

    • Foreign key

    • None of these

    Correct Answer
    A. Foreign key
    Explanation
    A foreign key is used to establish a relationship between two tables in a database. It is a field in one table that refers to the primary key in another table. This relationship helps maintain data integrity and ensures that the data in the related tables remains consistent. The foreign key allows for the linking of data across tables, enabling the retrieval of related information when needed.

    Rate this question:

  • 7. 

    Related fields in a database are grouped to form a

    • Data file

    • Data record

    • Menu.

    • Bank

    Correct Answer
    A. Data record
    Explanation
    In a database, related fields are grouped together to form a data record. A data record is a collection of related data elements or fields that are treated as a single unit. It represents a complete set of information about a specific entity or object in the database. By grouping related fields into a data record, it allows for efficient storage, retrieval, and manipulation of data in the database.

    Rate this question:

  • 8. 

    A DBMS query language is designed to

    • Support end-users who use English-like commands.

    • Support in the development of complex applications software.

    • Specify the structure of a database.

    • All of the above

    Correct Answer
    A. All of the above
    Explanation
    A DBMS query language is designed to support end-users who use English-like commands by providing a user-friendly interface that allows them to interact with the database using familiar language. Additionally, it supports in the development of complex applications software by providing tools and capabilities for querying and manipulating data within the database. Lastly, it also allows users to specify the structure of a database by providing commands and syntax for creating, modifying, and managing the database schema. Therefore, the correct answer is "all of the above."

    Rate this question:

  • 9. 

    A primary key is combined with a foreign key creates

    • Parent-Child relationship between the tables that connect them.

    • Many to many relationships between the tables that connect them.

    • Network model between the tables that connect them.

    • None of the above

    Correct Answer
    A. Parent-Child relationship between the tables that connect them.
    Explanation
    When a primary key is combined with a foreign key, it creates a parent-child relationship between the tables that connect them. This means that the table with the primary key (parent table) is the parent, and the table with the foreign key (child table) is the child. The relationship ensures that each record in the child table is associated with a record in the parent table. This allows for data integrity and enables efficient querying and manipulation of related data.

    Rate this question:

  • 10. 

    In a relational model, relations are termed as

    • Tuples

    • Attributes

    • Tables

    • Rows

    Correct Answer
    A. Tables
    Explanation
    In a relational model, relations are represented as tables. Tables consist of rows and columns, where each row represents a record or tuple, and each column represents an attribute or field. Therefore, the correct answer is "Tables."

    Rate this question:

  • 11. 

    The relational model feature is that there

    • Is no need for primary key data.

    • Is much more data independence than some other database models.

    • Are explicit relationships among records

    • Are tables with many dimensions

    Correct Answer
    A. Is much more data independence than some other database models.
    Explanation
    The correct answer is "is much more data independence than some other database models." This means that in the relational model, the data is stored separately from the applications that use it, allowing for easier modifications and updates without affecting the entire system. This level of data independence is not present in some other database models, where changes to the data structure can have a significant impact on the applications using it.

    Rate this question:

  • 12. 

    A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.

    • Rows

    • Key

    • Attribute

    • Fields

    Correct Answer
    A. Key
    Explanation
    A key is a property of the entire relation, rather than of the individual tuples, in which each tuple is unique. A key is used to uniquely identify each tuple in a relation and is an important concept in database design. It ensures that there are no duplicate tuples in a relation and allows for efficient retrieval of data.

    Rate this question:

  • 13. 

    A set of possible data values is called

    • Attribute.

    • Degree

    • Tuple

    • Domain

    Correct Answer
    A. Domain
    Explanation
    In the context of data, a domain refers to the set of all possible values that an attribute can have. It represents the range of values that a particular attribute can take on. Therefore, a set of possible data values is called a domain.

    Rate this question:

  • 14. 

    In the relational model, cardinality is termed as:

    • A number of attributes.

    • A number of tuples

    • A number of tables

    • A number of constraints.

    Correct Answer
    A. A number of tuples
    Explanation
    Cardinality in the relational model refers to the number of tuples or rows in a table. It represents the size or the count of the data entries in a specific table. Therefore, the correct answer is "A number of tuples" as it accurately describes the cardinality concept in the relational model.

    Rate this question:

  • 15. 

    A logical schema

    • Is the entire database

    • Is a standard way of organising information into accessible parts.

    • Describes how data is actually stored on disk.

    • Both (A) and (C)

    Correct Answer
    A. Is the entire database
    Explanation
    A logical schema refers to the entire database, including all the tables, relationships, and constraints. It represents the overall structure and organization of the data, without specifying how it is physically stored on disk. Therefore, the correct answer is "is the entire database."

    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
  • Mar 17, 2020
    Quiz Created by
    Aparnasunil75
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.