Database Management System1(TTA)

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Harish.hot04
H
Harish.hot04
Community Contributor
Quizzes Created: 3 | Total Attempts: 2,644
Questions: 25 | Attempts: 1,761

SettingsSettingsSettings
Database Management System1(TTA) - Quiz

INSTRUCTIONS
1. NUMBER OF QUESTIONS 25
2. HAS A TIME LIMIT OF 15 MINUTES
3. HAS A PASS MARKS OF 30%
4. QUESTIONS PER PAGE 1
5. EACH QUESTIONS HAS 1 MARKS
6. NEGATIVE MARKING FOR EACH QUESTIONS 0.25
7. WILL ALLOW TO YOU GO BACK ,SKIP AND CHANGE YOUR ANSWERS
8. WILL ALLOW TO YOU PRINT OUT YOUR RESULT AND CERTIFICATE
9. WILL ALLOW TO YOU PRINT OUT YOURS RESPONSE SHEET WITH CORRECT ANSWER KEY AND EXPLANATION
10. WE WILL PROVIDE YOURS RESULT,CERTIFICATE AND YOUR RESPONSE SHEET TO YOURS EMAIL ID AT END OF ONLINE TEST
.
.


Questions and Answers
  • 1. 

    Software that defines a database, stores the data, supports a query language, produces reports and creates data entry screens is a:

    • A.

      data dictionary

    • B.

      database management system (DBMS)

    • C.

      decision support system

    • D.

      relational database

    Correct Answer
    B. database management system (DBMS)
    Explanation
    A database management system (DBMS) is a software that provides a set of tools and functions to define, store, manipulate, and retrieve data in a database. It includes features such as data definition language (DDL) for defining the structure and schema of the database, data manipulation language (DML) for querying and modifying the data, report generation capabilities, and data entry screen creation. Therefore, a DBMS is the correct answer as it encompasses all the mentioned functionalities.

    Rate this question:

  • 2. 

    The modern database report writer

    • A.

      A career path that focuses on creating, managing and supporting the reports generated from databases

    • B.

      Provide limited control over how information is displayed and reported.

    • C.

      provides the tools for database designer to display information in the desired

    • D.

      Provides the tools for the database administrator to monitor and report on database use and activity

    Correct Answer
    C. provides the tools for database designer to display information in the desired
    Explanation
    The modern database report writer provides the tools for the database designer to display information in the desired format. This means that the report writer allows the designer to customize how the information is presented and reported. It gives them control over the layout, formatting, and organization of the data. This is important because different users may have different preferences and requirements for how they want the information to be displayed. By providing these tools, the report writer enables the designer to create reports that meet the specific needs of the users.

    Rate this question:

  • 3. 

    The separation of the data definition from the program is known as

    • A.

      data dictionary

    • B.

      data independence

    • C.

      data integrity

    • D.

      referential integrity

    Correct Answer
    B. data independence
    Explanation
    Data independence refers to the ability to modify the data storage or data organization without affecting the programs that use the data. It allows for changes to be made to the data structure or schema without requiring changes to the application programs that access the data. This separation of data definition from the program is achieved through data independence, ensuring that the programs remain unaffected by changes in the data storage or organization.

    Rate this question:

  • 4. 

    In the client/server model, the data base

    • A.

      is downloaded to the client upon request

    • B.

      is shared by both client and server

    • C.

      Resides on the client side

    • D.

      Resides on the server side

    Correct Answer
    D. Resides on the server side
    Explanation
    In the client/server model, the database resides on the server side. This means that the server is responsible for storing and managing the database, while the client accesses and interacts with the database through requests sent to the server. The server side is typically more secure and provides better control over the database, allowing multiple clients to access and manipulate the data simultaneously.

    Rate this question:

  • 5. 

    The traditional storage of data that is organized by customer,stored in separate folders in filing cabinets is an example of what type of 'database' system?

    • A.

      Hierarchical

    • B.

      Network

    • C.

      Object oriented

    • D.

      Relational database

    Correct Answer
    A. Hierarchical
    Explanation
    The traditional storage of data organized by customer and stored in separate folders in filing cabinets aligns with the hierarchical database system. In this type of system, data is structured in a tree-like format with parent-child relationships. Each customer would be represented as a parent node, and their data would be stored in separate folders as child nodes. This hierarchical structure allows for easy organization and retrieval of data.

    Rate this question:

  • 6. 

    The database designing that consists of multiple tables that are linked together through matching data stored in each table is called a:

    • A.

      hierarchical database

    • B.

      Network database

    • C.

      object oriented database

    • D.

      relational database

    Correct Answer
    D. relational database
    Explanation
    A relational database is a type of database design that consists of multiple tables that are linked together through matching data stored in each table. This allows for efficient storage and retrieval of data, as well as the ability to establish relationships and perform complex queries. Unlike hierarchical or network databases, which have a more rigid structure, a relational database allows for flexibility and scalability in organizing and accessing data. Object-oriented databases, on the other hand, store data in objects and are primarily used in object-oriented programming.

    Rate this question:

  • 7. 

    What is the main limitation of Hierarchical Databases?

    • A.

      Limited capacity (unable to hold much data)

    • B.

      Limited flexibility in accessing data

    • C.

      Overhead associated with maintaining indexes

    • D.

      Performance of the database is poor

    Correct Answer
    B. Limited flexibility in accessing data
    Explanation
    The main limitation of Hierarchical Databases is limited flexibility in accessing data. In a hierarchical database, data is organized in a tree-like structure, where each record has a parent-child relationship. This structure makes it difficult to retrieve data that is not directly related or connected. Unlike relational databases, which allow for more complex and flexible queries, hierarchical databases have limited query capabilities. This limitation restricts the ability to efficiently access and retrieve data, especially when dealing with complex data relationships.

    Rate this question:

  • 8. 

    An abstract data type is used to:

    • A.

      link data from remote databases

    • B.

      Prevent users from getting to database security information

    • C.

      Provide a conceptual view of the data so it is easier to understand

    • D.

      Store complex data structure to represent the properties of objects

    Correct Answer
    D. Store complex data structure to represent the properties of objects
    Explanation
    An abstract data type is used to store complex data structures that represent the properties of objects. It allows for the encapsulation of data and operations into a single unit, providing a high level of abstraction. This helps in organizing and managing data in a more efficient and logical manner, making it easier to understand and work with. It enables the implementation of data structures such as lists, stacks, queues, trees, etc., which are essential for representing and manipulating complex data in various applications.

    Rate this question:

  • 9. 

    One of the first phases of a new database project that involves critical areas, expensive hardware or software within the organization is called ___________.

    • A.

      analysis phase

    • B.

      feasibility study

    • C.

      Investigation stage

    • D.

      System design

    Correct Answer
    B. feasibility study
    Explanation
    A feasibility study is conducted during the initial phase of a new database project that involves critical areas, expensive hardware or software within the organization. This study helps determine whether the project is viable and achievable, taking into consideration various factors such as technical, economic, legal, and operational aspects. It assesses the potential risks, benefits, and costs associated with the project, allowing decision-makers to make informed choices about whether to proceed with the project or not.

    Rate this question:

  • 10. 

    Which component of the database management system (DBMS) most affects the ability to handle large problems (scalability)?

    • A.

      Data storage subsystem

    • B.

      Database engine

    • C.

      query processor

    • D.

      Security sub system

    Correct Answer
    B. Database engine
    Explanation
    The database engine is the component of the DBMS that most affects the ability to handle large problems or scalability. It is responsible for managing the storage and retrieval of data, as well as executing queries and transactions efficiently. The performance and scalability of the database engine directly impact the system's ability to handle large amounts of data and process complex queries in a timely manner.

    Rate this question:

  • 11. 

    DBMS Stands for

    • A.

      Database marginal system

    • B.

      Directory Based Memory Standard

    • C.

      Data Base Management System

    • D.

      Dual Bus Mask Storage

    Correct Answer
    C. Data Base Management System
    Explanation
    DBMS stands for Data Base Management System. This term refers to a software system that allows users to create, manage, and manipulate databases. It provides a structured and organized approach to storing and retrieving data efficiently. DBMS ensures data integrity, security, and consistency, while also providing features like data backup and recovery. It is widely used in various industries and applications to handle large volumes of data and support complex data operations.

    Rate this question:

  • 12. 

    In a data base,each row is called as a

    • A.

      Horizontal data

    • B.

      record

    • C.

      Information

    • D.

      None of these

    Correct Answer
    B. record
    Explanation
    In a database, each row represents a single record of data. Therefore, the correct term to describe each row in a database is "record". This term is commonly used in database terminology to refer to a collection of related data fields that are grouped together. Other options like "horizontal data" or "information" do not accurately describe the concept of a row in a database.

    Rate this question:

  • 13. 

    Which command can be used to change or edit the database file

    • A.

      Edit

    • B.

      Browse

    • C.

      Replace

    • D.

      All of these

    Correct Answer
    D. All of these
    Explanation
    All of these commands can be used to change or edit the database file. The "Edit" command allows for direct editing of the file, while the "Browse" command allows for viewing and navigating through the file. The "Replace" command allows for replacing specific data within the file. Therefore, all of these commands are valid options for changing or editing the database file.

    Rate this question:

  • 14. 

    .Each column of a table may have values of

    • A.

      Different types

    • B.

      Same type

    • C.

      Varied or same type

    • D.

      none of the above

    Correct Answer
    B. Same type
    Explanation
    The correct answer is "Same type" because each column of a table is designed to store values of the same data type. This ensures consistency and allows for efficient data retrieval and manipulation. Storing values of different types in the same column would lead to data integrity issues and make it difficult to perform operations on the data. Therefore, it is important to maintain the same data type for each column in a table.

    Rate this question:

  • 15. 

    All the rows in a table are

    • A.

      same

    • B.

      May or may not same

    • C.

      different

    • D.

      All of above

    Correct Answer
    C. different
    Explanation
    In a table, the rows can be different from each other in terms of the data they contain. Each row in a table represents a separate record or entry, so it is possible for the rows to have different values or information. Therefore, the correct answer is "different".

    Rate this question:

  • 16. 

    SQL stands for

    • A.

      standard quality literature

    • B.

      structured query language

    • C.

      standard query language

    • D.

      Standard query linguistics

    Correct Answer
    B. structured query language
    Explanation
    SQL stands for Structured Query Language. It is a programming language used for managing and manipulating relational databases. SQL allows users to create, modify, and retrieve data from databases. It is a standardized language that is widely used in the industry for database management.

    Rate this question:

  • 17. 

    Which of the following are the elements of a database

    • A.

      data

    • B.

      Relations

    • C.

      Constraint and schema

    • D.

      All of these

    Correct Answer
    D. All of these
    Explanation
    The correct answer is "All of these". This is because all the options mentioned - data, relations, constraints, and schema - are essential elements of a database. Data refers to the actual information stored in the database, relations represent the connections between different sets of data, constraints ensure the integrity and validity of the data, and schema defines the structure and organization of the database. Therefore, all of these elements are necessary for a functioning database.

    Rate this question:

  • 18. 

    A DBMS enables you to

    • A.

      Store Information

    • B.

      Modify Information

    • C.

      Extract Information

    • D.

      All of above

    Correct Answer
    D. All of above
    Explanation
    A DBMS (Database Management System) allows you to store information by providing a structured and organized way to store data. It also enables you to modify information by allowing you to add, update, or delete data in the database. Additionally, a DBMS allows you to extract information by providing tools and functionalities to retrieve specific data or generate reports based on specific criteria. Therefore, the correct answer is "all of the above" as a DBMS enables you to perform all these actions.

    Rate this question:

  • 19. 

    Meta data is

    • A.

      Small amount of data

    • B.

      data about data

    • C.

      Redundant data

    • D.

      None of these

    Correct Answer
    B. data about data
    Explanation
    The correct answer is "data about data". Metadata refers to the information that provides context and describes the characteristics of other data. It helps to organize, manage, and understand the data by providing details such as the format, structure, location, and relationships between different data elements.

    Rate this question:

  • 20. 

    4GL stands for

    • A.

      Four general languages

    • B.

      Fourth generation languages

    • C.

      Forty General Languages

    • D.

      none

    Correct Answer
    B. Fourth generation languages
    Explanation
    4GL stands for Fourth generation languages. Fourth generation languages are high-level programming languages that are designed to be easier to use than previous generations of languages. They provide a higher level of abstraction, allowing programmers to write code in a more natural and intuitive way. 4GLs are typically used for database management, report generation, and other business applications. They are often used in conjunction with database management systems to simplify data manipulation and retrieval.

    Rate this question:

  • 21. 

    The ascending order of a data hierarchy is

    • A.

      bit-byte-record-field-file-database

    • B.

      byte-bit-field-record-file-database

    • C.

      bit-byte-field-record-file-database

    • D.

      bit-byte-file-record-field-database

    Correct Answer
    C. bit-byte-field-record-file-database
    Explanation
    The ascending order of a data hierarchy starts with the smallest unit of data, which is a bit. Then it progresses to a byte, which is composed of 8 bits. After that, it moves on to a field, which is a group of related bytes. Next, it goes to a record, which is a collection of related fields. Then, it goes to a file, which is a collection of related records. Finally, it reaches the highest level of the hierarchy, which is a database, consisting of multiple files.

    Rate this question:

  • 22. 

    Which of the following is true of a network structure

    • A.

      It is a physical representation of the data

    • B.

      It allows a many-to -many relationship

    • C.

      It is conceptually simple

    • D.

      It will be dominant database of the future

    Correct Answer
    B. It allows a many-to -many relationship
    Explanation
    A network structure in database management allows for a many-to-many relationship between entities. This means that multiple entities can be related to multiple other entities, creating a complex interconnected network. Unlike other database structures such as hierarchical or relational, the network structure allows for more flexibility in representing real-world relationships. It is not necessarily a physical representation of the data, as it is a conceptual model. While it is conceptually simple in terms of understanding the relationships, it may not necessarily be the dominant database structure in the future as there are other evolving database models.

    Rate this question:

  • 23. 

    Which of the following is a problem in file management system?

    • A.

      difficult to update

    • B.

      Lack of data independence

    • C.

      data redundancy

    • D.

      All of above

    Correct Answer
    D. All of above
    Explanation
    All of the options mentioned are problems in a file management system. Difficult to update refers to the challenge of making changes or modifications to existing files. Lack of data independence means that the data is tightly coupled with the programs using it, making it difficult to make changes without affecting other programs. Data redundancy refers to the duplication of data, which can lead to inconsistencies and inefficiencies in the system. Therefore, all of these issues are valid problems in a file management system.

    Rate this question:

  • 24. 

    One data dictionary software package is called

    • A.

      DB/DC dictionary

    • B.

      TOTAL

    • C.

      ACCESS

    • D.

      DATA PACK

    Correct Answer
    A. DB/DC dictionary
    Explanation
    The given options are names of data dictionary software packages. Among these options, "DB/DC dictionary" is the correct answer.

    Rate this question:

  • 25. 

    The function of a database is

    • A.

      to check all input data

    • B.

      To check all spelling

    • C.

      To collect and organize input data

    • D.

      to output data

    Correct Answer
    C. To collect and organize input data
    Explanation
    The function of a database is to collect and organize input data. A database is designed to store and manage large amounts of data efficiently. It allows users to input data into the database, which is then organized and stored in a structured manner. This organization enables easy retrieval and manipulation of the data when needed. Therefore, the primary function of a database is to collect and organize input data.

    Rate this question:

Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.