Trivia Quiz On Database Management System

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 Ashishdoorwar96
A
Ashishdoorwar96
Community Contributor
Quizzes Created: 2 | Total Attempts: 926
| Attempts: 318
SettingsSettings
Please wait...
  • 1/10 Questions

    The full form of DDL is

    • Dynamic Data Language
    • Detailed Data Language
    • Data Definition Language
    • Data Derivation Language
Please wait...
About This Quiz

Welcome to the trivia quiz on database management system. Over the past few days we have been able to dive deeper into the data base. A data base is made of different components and each of them has a specific responsibility in order to meet a user’s responsibility. Take up the quiz and get to see just how much you got to understand. All the best!

Trivia Quiz On Database Management System - Quiz

Quiz Preview

  • 2. 

    DBMS helps achieve

    • Data independence

    • Centralized control of data

    • Neither (A) nor (B)

    • Both (A) and (B)

    Correct Answer
    A. Both (A) and (B)
    Explanation
    DBMS (Database Management System) helps achieve both data independence and centralized control of data. Data independence refers to the ability to make changes to the database structure without affecting the applications that use the data. DBMS provides a layer of abstraction between the physical storage and the logical representation of data, allowing for easier modifications. Centralized control of data means that the DBMS provides a centralized location for storing and managing data, ensuring consistency, security, and efficient access. Therefore, both options (A) and (B) are correct.

    Rate this question:

  • 3. 

    The statement in SQL which allows to change the definition of a table is

    • Alter.

    • Update.

    • Create.

    • Select.

    Correct Answer
    A. Alter.
    Explanation
    The correct answer is "Alter" because the ALTER statement in SQL is used to modify the structure or definition of an existing table. It allows you to add, delete, or modify columns, constraints, and other table attributes. The UPDATE statement is used to modify the data within the table, not the table structure. The CREATE statement is used to create a new table, not change an existing one. The SELECT statement is used to retrieve data from the table, not modify its definition.

    Rate this question:

  • 4. 

    Which of the following are the properties of entities?

    • Groups

    • Table

    • Attributes

    • Switchboards

    Correct Answer
    A. Attributes
    Explanation
    Entities are the objects or things that we want to store information about in a database. They can be people, places, things, or events. Properties of entities are the characteristics or attributes that describe them. These attributes provide information about the entities and help in organizing and categorizing the data. Therefore, "Attributes" is the correct answer as it correctly identifies one of the properties of entities.

    Rate this question:

  • 5. 

    The RDBMS terminology for a row is

    • Tuple.

    • Relation.

    • Attribute.

    • Degree.

    Correct Answer
    A. Tuple.
    Explanation
    In the context of relational database management systems (RDBMS), a row is referred to as a tuple. A tuple represents a single record or instance of data within a table. It consists of a collection of attributes or fields that describe the characteristics or properties of that particular record. Therefore, the term "tuple" accurately describes the RDBMS terminology for a row in a database table.

    Rate this question:

  • 6. 

    Count function in SQL returns the number of

    • Values.

    • Distinct values.

    • groups.

    • Columns.

    Correct Answer
    A. Values.
    Explanation
    The count function in SQL returns the number of values. It is used to count the number of rows or records in a table or the number of values in a specific column. It does not take into account the distinct values, groups, or columns, but simply returns the total count of values.

    Rate this question:

  • 7. 

    A report generator is used to

    • Update files.

    • Print files on paper.

    • Data entry.

    • Delete files.

    Correct Answer
    A. Print files on paper.
    Explanation
    A report generator is a tool or software that is specifically designed to generate reports. These reports can be in various formats, such as PDF, Excel, or HTML, but one of the common outputs is printing the reports on paper. Therefore, the correct answer is "print files on paper."

    Rate this question:

  • 8. 

    Which of the following is a legal expression in SQL?

    • SELECT NULL FROM EMPLOYEE;

    • SELECT NAME FROM EMPLOYEE;

    • SELECT NAME FROM EMPLOYEE WHERE SALARY = NULL;

    • None of the above

    Correct Answer
    A. SELECT NAME FROM EMPLOYEE;
    Explanation
    The correct answer is "SELECT NAME FROM EMPLOYEE;". This is a legal expression in SQL because it follows the syntax of the SELECT statement, which is used to retrieve data from a database. The statement selects the "NAME" column from the "EMPLOYEE" table, indicating that the desired data is the names of employees.

    Rate this question:

  • 9. 

    The result of the UNION operation between R1 and R2 is a relation that includes

    • All the tuples of R1

    • All the tuples of R2

    • All the tuples of R1 and R2

    • All the tuples of R1 and R2 which have common columns

    Correct Answer
    A. All the tuples of R1 and R2 which have common columns
    Explanation
    The result of the UNION operation between R1 and R2 is a relation that includes all the tuples of R1 and R2 which have common columns. The UNION operation combines the tuples from both relations and eliminates any duplicates. In this case, only the tuples that have common columns in R1 and R2 will be included in the result. Tuples that do not have common columns will not be included.

    Rate this question:

  • 10. 

    Which of the following is not the responsibility of the utilities component of DBMS software?

    • Creating the physical and logical designs

    • Removing flagged records for deletion

    • Creating and maintaining the data dictionary

    • Monitoring performance

    Correct Answer
    A. Creating the physical and logical designs
    Explanation
    The utilities component of DBMS software is responsible for various tasks, such as removing flagged records for deletion, creating and maintaining the data dictionary, and monitoring performance. However, creating the physical and logical designs is not one of its responsibilities. This task typically falls under the responsibility of the database administrator or the database designer, who are in charge of designing the structure and organization of the 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
  • Nov 26, 2012
    Quiz Created by
    Ashishdoorwar96
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.