Data Base Management System 2(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 Harry.hot02
H
Harry.hot02
Community Contributor
Quizzes Created: 8 | Total Attempts: 1,446
Questions: 25 | Attempts: 100

SettingsSettingsSettings
Data Base Management System 2(TTA) - Quiz

. . INSTRUCTIONS
1. NUMBER OF QUESTIONS 22
2. HAS A TIME LIMIT OF 20 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. 

    The model for a record management system might be

    • A.

      Hand written list

    • B.

      a Rolodex card file

    • C.

      A business form

    • D.

      All of these

    Correct Answer
    D. All of these
    Explanation
    The model for a record management system can vary depending on the specific needs and preferences of the organization or individual. A hand-written list can serve as a simple and low-tech method of keeping track of records. A Rolodex card file provides a more organized and easily accessible way to store and retrieve information. A business form can be used to standardize the recording of data and ensure consistency. Therefore, all of these options can be considered as potential models for a record management system.

    Rate this question:

  • 2. 

    Primitive operations common to all record management system include

    • A.

      Print

    • B.

      Sort

    • C.

      look-up

    • D.

      All of above all of above all of these

    Correct Answer
    C. look-up
    Explanation
    The correct answer is "look-up". In a record management system, the common primitive operations include printing records, sorting records, and performing look-ups. Look-up refers to the action of searching for specific records based on certain criteria. Therefore, "look-up" is the correct answer as it encompasses all the other options mentioned.

    Rate this question:

  • 3. 

    In a large DBMS

    • A.

      each user can "see" only a small part of the entire database

    • B.

      each sub schema contains every field in the logical schema

    • C.

      each user can access every sub schema

    • D.

      None of these

    Correct Answer
    A. each user can "see" only a small part of the entire database
    Explanation
    In a large DBMS, each user can "see" only a small part of the entire database. This means that each user is granted access to a specific subset of the data, rather than having access to the entire database. This is done to ensure data security and privacy, as well as to optimize performance by limiting the amount of data that needs to be processed and retrieved for each user.

    Rate this question:

  • 4. 

    .Information can be transferred between the DBMS and a

    • A.

      Spreadsheet program

    • B.

      word processor program

    • C.

      Graphics program

    • D.

      All of these

    Correct Answer
    D. All of these
    Explanation
    The correct answer is "all of these". This means that information can be transferred between the DBMS (Database Management System) and a spreadsheet program, a word processor program, and a graphics program. This implies that the DBMS has the capability to interact and exchange data with these different types of software applications, allowing for seamless transfer and integration of information between them.

    Rate this question:

  • 5. 

    Which of the following fields in a student file can be used as a primary key?

    • A.

      Class

    • B.

      Social Security Number

    • C.

      GPA

    • D.

      Major

    Correct Answer
    B. Social Security Number
    Explanation
    The Social Security Number can be used as a primary key in a student file because it is a unique identifier for each student. Primary keys are used to uniquely identify each record in a database table, and the Social Security Number meets this requirement as it is assigned to each individual and is not repeated. The other fields, such as class, GPA, and major, may have multiple students with the same values, making them unsuitable as primary keys.

    Rate this question:

  • 6. 

    Which of the following is not an advantage of the database approach

    • A.

      Elimination of data redundancy

    • B.

      Ability of associate deleted data

    • C.

      increased security

    • D.

      All of these

    Correct Answer
    D. All of these
    Explanation
    The question asks for a disadvantage of the database approach. However, the given answer states that all of the options listed (elimination of data redundancy, ability to associate deleted data, increased security) are not advantages of the database approach. This is incorrect. The correct answer should be "None of these" or "There are no disadvantages of the database approach."

    Rate this question:

  • 7. 

    Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?

    • A.

      report writer

    • B.

      equerry language

    • C.

      Data manipulation language

    • D.

      transaction log

    Correct Answer
    D. transaction log
    Explanation
    A transaction log is a complete record of all activity that has affected the contents of a database during a specific period of time. It is used to track and record changes made to the database, such as insertions, deletions, and updates. The transaction log is essential for data recovery and rollback operations, as it allows the database to be restored to a previous state in case of errors or failures. It also helps in maintaining data integrity and consistency by providing a detailed audit trail of all database transactions.

    Rate this question:

  • 8. 

    In the DBMS approach, application programs perform the

    • A.

      Storage function

    • B.

      Processing functions

    • C.

      Access control

    • D.

      All of these

    Correct Answer
    B. Processing functions
    Explanation
    In the DBMS approach, application programs are responsible for performing the processing functions. This includes tasks such as data manipulation, data retrieval, data analysis, and data transformation. The application programs interact with the database management system (DBMS) to perform these functions efficiently and effectively. The storage function is handled by the DBMS, which manages the physical storage of data on disk or in memory. Access control is also managed by the DBMS, which ensures that only authorized users can access and modify the data. Therefore, the correct answer is processing functions.

    Rate this question:

  • 9. 

    A set of programs that handle a firm's database reponsibilities is called

    • A.

      database management system

    • B.

      Database processing system

    • C.

      Data management system

    • D.

      all of these

    Correct Answer
    D. all of these
    Explanation
    The correct answer is "all of these" because a set of programs that handle a firm's database responsibilities can be referred to as a database management system, a database processing system, or a data management system. Each of these terms can be used interchangeably to describe the software and tools used to organize, store, retrieve, and manage data within a firm's database.

    Rate this question:

  • 10. 

    Which is the make given to the database management system which is able to handle full text data,image data,audio and video?

    • A.

      full media

    • B.

      graphics media

    • C.

      Multimedia

    • D.

      Hypertext

    Correct Answer
    C. Multimedia
    Explanation
    Multimedia is the correct answer because it refers to the database management system that is capable of handling various types of data, including full text, images, audio, and video. This term encompasses the integration of different media formats into a single platform, allowing for the storage, retrieval, and manipulation of diverse data types. Therefore, multimedia is the appropriate term to describe a database management system that can handle full text, image, audio, and video data.

    Rate this question:

  • 11. 

    A record management system

    • A.

      can handle many files of information at a time

    • B.

      can be used to extract information stored in a computer file

    • C.

      always uses a list as its mode

    • D.

      All of these

    Correct Answer
    B. can be used to extract information stored in a computer file
    Explanation
    A record management system can be used to extract information stored in a computer file. This means that the system has the capability to retrieve specific data from a file, making it easier for users to access and utilize the information they need. This feature is important in ensuring efficient and effective management of records, as it allows users to quickly find and retrieve relevant data without having to manually search through the entire file.

    Rate this question:

  • 12. 

    A command that lets you change one or more fields in a record is

    • A.

      insert

    • B.

      Modify Information

    • C.

      look-up

    • D.

      None of these

    Correct Answer
    B. Modify Information
    Explanation
    The command "Modify Information" allows the user to change one or more fields in a record. This command is specifically designed to update or edit the information stored in a record, allowing for modifications to be made as needed. Unlike the other options listed, such as "insert" or "look-up", which do not directly involve changing fields in a record, "Modify Information" is the appropriate command for this purpose.

    Rate this question:

  • 13. 

    A transparent DBMS

    • A.

      Can not hide sensitive information from users

    • B.

      keeps its logical structure hidden from users

    • C.

      Keeps its physical structure hidden from users

    • D.

      All of these

    Correct Answer
    C. Keeps its physical structure hidden from users
    Explanation
    A transparent DBMS keeps its physical structure hidden from users. This means that users are not aware of how the data is stored or organized within the database. They are only able to interact with the data through the logical structure that is presented to them. This helps to simplify the user's experience and allows them to focus on accessing and manipulating the data without needing to understand the underlying technical details of the database's physical structure.

    Rate this question:

  • 14. 

    A file produced by a spreadsheet

    • A.

      A file produced by a spreadsheet

    • B.

      Can be used as it is by the DBMS

    • C.

      Both

    • D.

      Non

    Correct Answer
    A. A file produced by a spreadsheet
    Explanation
    A file produced by a spreadsheet can be used as it is by the DBMS. This means that the file created by the spreadsheet can be directly imported or utilized by the database management system without the need for any additional modifications or conversions. This suggests that the file format and structure of the spreadsheet is compatible with the database system, allowing for seamless integration and data transfer between the two.

    Rate this question:

  • 15. 

    Large collection of fields are called

    • A.

      fields

    • B.

      fields

    • C.

      Database

    • D.

      Sectors

    Correct Answer
    C. Database
    Explanation
    A large collection of fields is referred to as a database. A database is a structured set of data that is organized and stored in a way that allows for efficient retrieval, manipulation, and management. It typically consists of multiple fields, each representing a specific attribute or piece of information. By organizing data into fields within a database, it becomes easier to search, sort, and analyze the information. Therefore, the correct answer is "database".

    Rate this question:

  • 16. 

    What is the language used by most of DBMSs for helping their users to access data

    • A.

      High level language

    • B.

      SQL

    • C.

      Query languag

    • D.

      4GL

    Correct Answer
    B. SQL
    Explanation
    SQL (Structured Query Language) is the language used by most DBMSs (Database Management Systems) to help their users access data. SQL is a standardized language that allows users to create, manipulate, and retrieve data from databases. It provides a set of commands and syntax that enables users to interact with the database, perform queries, and retrieve specific information. SQL is widely used in the industry and is considered the standard language for managing and accessing data in relational databases.

    Rate this question:

  • 17. 

    Which of the following is not a relational database?

    • A.

      dbase IV

    • B.

      4th Dimension

    • C.

      Foxpro

    • D.

      Foxpro

    Correct Answer
    A. dbase IV
    Explanation
    dbase IV is not a relational database. It is a database management system that uses the dBase programming language, which is a procedural language rather than a relational language. Relational databases, on the other hand, store and organize data in tables with relationships between them, allowing for efficient querying and manipulation of data. Examples of relational databases include MySQL, Oracle, and Microsoft SQL Server.

    Rate this question:

  • 18. 

    If a piece of data is stored in two places in the database,then

    • A.

      Storage space is wasted

    • B.

      Changing the data in one spot will cause data inconsistency

    • C.

      It can be more easily accessed

    • D.

      Both,storage space is wasted and changing the data in one spot will cause data inconsistency

    Correct Answer
    D. Both,storage space is wasted and changing the data in one spot will cause data inconsistency
    Explanation
    When a piece of data is stored in two places in the database, it leads to both storage space being wasted and data inconsistency. Storing the same data in multiple locations unnecessarily occupies extra storage space, which could be used for other purposes. Additionally, when the data is changed in one spot, there is a risk of not updating it in the other location, resulting in data inconsistency. This can lead to confusion and errors when accessing or analyzing the data.

    Rate this question:

  • 19. 

    A audit trail

    • A.

      is used to make back up copies

    • B.

      is the recorded history of operations performed on a file

    • C.

      can be used to restore lost information

    • D.

      None of these

    Correct Answer
    B. is the recorded history of operations performed on a file
    Explanation
    An audit trail is a recorded history of operations performed on a file. It keeps track of all the actions and changes made to a file, providing a detailed record of who accessed the file, when they accessed it, and what changes they made. This can be useful for various purposes such as troubleshooting, compliance, and security. It does not specifically involve making backup copies or restoring lost information, although it can indirectly contribute to these activities by providing a comprehensive record of file operations.

    Rate this question:

  • 20. 

    The relational database environment has all of the following components except

    • A.

      users

    • B.

      Separate files

    • C.

      Database

    • D.

      Query languages

    Correct Answer
    B. Separate files
    Explanation
    In a relational database environment, the components typically include users, a database, and query languages. Users interact with the database using query languages to retrieve or manipulate data. However, "separate files" is not a component of the relational database environment. Instead, data in a relational database is organized and stored in tables within the database, eliminating the need for separate files.

    Rate this question:

  • 21. 

    The language used application programs to request data from the DBMS is referred to as the

    • A.

      DML

    • B.

      DDL

    • C.

      Query language

    • D.

      Any from these

    Correct Answer
    A. DML
    Explanation
    The correct answer is DML. DML stands for Data Manipulation Language and is used in application programs to request data from the DBMS (Database Management System). It is used to insert, update, delete, and retrieve data from the database. DDL (Data Definition Language) is used to define and manage the structure of the database, while query language is a more general term that refers to any language used to retrieve data from a database. Therefore, DML is the most appropriate answer in this context.

    Rate this question:

  • 22. 

    The highest level in the hierarchy of data organization is called

    • A.

      data bank

    • B.

      Data base

    • C.

      Data file

    • D.

      Data record

    Correct Answer
    B. Data base
    Explanation
    The highest level in the hierarchy of data organization is called a data base. A data base is a collection of related data that is organized and stored in a structured manner. It allows for efficient storage, retrieval, and manipulation of data. A data base typically consists of multiple data files, which in turn contain data records. Therefore, a data base is the highest level in the hierarchy as it encompasses all the lower levels of data organization.

    Rate this question:

  • 23. 

    Choose the RDBMS which supports full fledged client server application development

    • A.

      dbase IV

    • B.

      Oracle 7.1

    • C.

      Foxpro 2.1

    • D.

      Ingress

    Correct Answer
    A. dbase IV
  • 24. 

    A form defined

    • A.

      Where data is placed on the screen

    • B.

      the width of each field

    • C.

      Both

    • D.

      None

    Correct Answer
    A. Where data is placed on the screen
    Explanation
    The correct answer is "where data is placed on the screen". This answer suggests that a form is a visual representation of data on a screen, where users can input or view information. It implies that a form is used to display data in a structured manner, with each field having a specific width or layout. This explanation aligns with the understanding that forms are commonly used in user interfaces to collect or present data in a structured format.

    Rate this question:

  • 25. 

    . The most open source DBMS

    • A.

      Microsoft SQL Server

    • B.

      Microsoft Access

    • C.

      MySQL

    • D.

      Oracle

    Correct Answer
    C. MySQL
    Explanation
    MySQL is the most open source DBMS among the given options. It is an open-source relational database management system that is widely used for web applications. MySQL is known for its scalability, reliability, and ease of use. It is developed, distributed, and supported by Oracle Corporation. MySQL allows users to modify and customize the source code according to their specific needs, making it highly flexible and open for collaboration and contributions from the community.

    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.