Quiz 4- SEC A

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 Gshivani554
G
Gshivani554
Community Contributor
Quizzes Created: 2 | Total Attempts: 304
| Attempts: 157
SettingsSettings
Please wait...
  • 1/21 Questions

    Between the users and the database itself, a DBMS will act as :

    • Barrier
    • Interface
    • Referee
    • Obstacle
Please wait...
About This Quiz

QUIZ 4- SEC A covers fundamental concepts of databases including schema types, data abstraction levels, roles in database management, and the functionality of a DBMS.

Quiz 4- SEC A - Quiz

Quiz Preview

  • 2. 

    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 different programs can access and manipulate the same data, allowing for better data consistency and reducing the need for data duplication. This integration also improves data availability and accessibility, as multiple users or programs can retrieve and update the data simultaneously.

    Rate this question:

  • 3. 

    DBMS is used to :

    • Eliminate data redundancy

    • Maintain data integrity

    • Establish relationships among different files

    • All of the above

    Correct Answer
    A. All of the above
    Explanation
    DBMS (Database Management System) is a software that is used to efficiently manage and organize large amounts of data. It eliminates data redundancy by storing data in a centralized location, reducing the chances of data inconsistencies. It maintains data integrity by enforcing rules and constraints on the data, ensuring its accuracy and reliability. Additionally, DBMS helps establish relationships among different files or tables, allowing for efficient data retrieval and analysis. Therefore, the correct answer is "All of the above" as DBMS encompasses all these functionalities.

    Rate this question:

  • 4. 

    Which one is lowest level data model ?

    • Physical data model

    • Logical data model

    • External data model

    • None of the above

    Correct Answer
    A. Physical data model
    Explanation
    The physical data model is the lowest level data model because it represents the actual implementation of the database on a physical storage medium, such as a hard drive. It defines the specific data types, storage structures, and indexing mechanisms used to store and retrieve data. The physical data model is closely tied to the hardware and software environment in which the database operates, and it is used by database administrators and developers to optimize performance and manage the physical storage of data.

    Rate this question:

  • 5. 

    The data dictionary tells the DBMS : 

    • What files are in the database

    • What attributes are possessed by the data

    • What these files contain

    • All of the above

    Correct Answer
    A. All of the above
    Explanation
    The data dictionary is a crucial component of a database management system (DBMS) as it provides information about the database. It includes details about the files present in the database, the attributes possessed by the data, and the contents of these files. By having this information, the DBMS can effectively manage the database, ensure data integrity, and facilitate data retrieval and manipulation. Therefore, the correct answer is "All of the above."

    Rate this question:

  • 6. 

    Data processing comprises of :

    • Capturing of data

    • Storing of data

    • Updating and retrieving data

    • All of the above

    Correct Answer
    A. All of the above
    Explanation
    Data processing comprises of capturing, storing, updating, and retrieving data. Capturing data refers to the process of collecting and inputting data into a system. Storing data involves saving the captured data in a structured manner for future use. Updating data means making changes or modifications to the stored data when required. Retrieving data involves accessing and extracting specific information from the stored data. Therefore, the correct answer is "All of the above" as it encompasses all the mentioned activities involved in data processing.

    Rate this question:

  • 7. 

    File is the collection of all related :

    • Database

    • Records

    • Fields

    • File

    Correct Answer
    A. Records
    Explanation
    A file is a collection of related records. Records are individual units of data that are organized within a file. Therefore, a file consists of multiple records that are related to each other in some way.

    Rate this question:

  • 8. 

    DBA stands for :

    • Data Bank Access

    • Database Access

    • Data Bank Administration

    • Database Administrator

    Correct Answer
    A. Database Administrator
    Explanation
    DBA stands for Database Administrator. A Database Administrator is responsible for managing and maintaining a database system. They ensure the security, performance, and availability of the database, as well as handle data backup and recovery. They also handle tasks such as database design, configuration, optimization, and troubleshooting. The role of a DBA is crucial in ensuring that the database operates efficiently and effectively to meet the needs of the organization.

    Rate this question:

  • 9. 

    The highest level in the hierarchy of data organization is called :

    • Data bank

    • Database

    • Data file

    • Data record

    Correct Answer
    A. Database
    Explanation
    The highest level in the hierarchy of data organization is called a database. A database is a collection of organized and structured data that can be accessed, managed, and manipulated. It is designed to store large amounts of information and provide efficient retrieval and storage mechanisms. A database can include multiple data files, data records, and data banks, but it is the overall structure that encompasses all these elements.

    Rate this question:

  • 10. 

    A top-to-bottom relationship among the items in a database is established by a :

    • Hierarchical schema

    • Network schema

    • Relational schema

    • All of the above

    Correct Answer
    A. Hierarchical schema
    Explanation
    A hierarchical schema establishes a top-to-bottom relationship among the items in a database. In this type of schema, data is organized in a tree-like structure with parent-child relationships. Each parent can have multiple children, but each child can only have one parent. This allows for easy navigation and retrieval of data, but it can be inflexible when it comes to representing complex relationships. Network and relational schemas, on the other hand, do not necessarily establish a top-to-bottom relationship among items in a database.

    Rate this question:

  • 11. 

    Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?

    • DML(Data Manipulation Langauge)

    • DDL(Data Definition Langauge)

    • Query

    • Relational Schema

    Correct Answer
    A. DML(Data Manipulation Langauge)
    Explanation
    DML (Data Manipulation Language) is the correct answer because it provides the ability to query information from the database and perform various operations such as inserting, deleting, and modifying tuples in the database. DML commands like SELECT, INSERT, UPDATE, and DELETE are used to manipulate data stored in the database. DDL (Data Definition Language) is used to define the structure and schema of the database, while a query is a request for data retrieval from the database. A relational schema represents the structure and organization of the database.

    Rate this question:

  • 12. 

    Create table employee (name varchar ,id integer) What type of statement is this 

    • DML

    • DDL

    • View

    • Integrity constraint

    Correct Answer
    A. DDL
    Explanation
    This statement is a Data Definition Language (DDL) statement. DDL statements are used to define or modify the structure of database objects, such as tables, views, and indexes. In this case, the statement is creating a new table called "employee" with two columns: "name" of type varchar and "id" of type integer. DDL statements are used to create, alter, or drop database objects, while Data Manipulation Language (DML) statements are used to retrieve, insert, update, or delete data from the database.

    Rate this question:

  • 13. 

    The logical data structure with a one-to-many relationship is a :

    • Network

    • Tree

    • Chain

    • Relationship

    Correct Answer
    A. Tree
    Explanation
    A tree is a logical data structure that represents a one-to-many relationship. In a tree, there is a single root node that has multiple child nodes, but each child node can only have one parent node. This hierarchical structure allows for easy navigation and organization of data, making it suitable for representing relationships such as parent-child or category-subcategory. Therefore, a tree is the correct answer for the given question.

    Rate this question:

  • 14. 

    The language which has recently become the defacto standard for interfacing application programs with relational database system is

    • . Oracle.

    • SQL.

    • DBase

    • 4GL

    Correct Answer
    A. SQL.
    Explanation
    SQL (Structured Query Language) is a programming language that is commonly used for managing and manipulating data in relational database systems. It has become the de facto standard for interfacing application programs with relational database systems due to its simplicity, flexibility, and wide support across different database platforms. SQL allows developers to write queries, perform data manipulation operations, and retrieve data from databases, making it an essential language for interacting with relational databases.

    Rate this question:

  • 15. 

    Data are :

    • Raw facts and figures

    • Information

    • Electronic representation of facts

    • None of the above

    Correct Answer
    A. Raw facts and figures
    Explanation
    Data refers to raw facts and figures that are collected or observed. It is the unprocessed and unorganized information that is typically in the form of numbers, text, or symbols. Data can be collected from various sources and can be used to derive meaningful insights and information through analysis and interpretation. Therefore, the answer "Raw facts and figures" accurately describes what data represents.

    Rate this question:

  • 16. 

     A set of objects that share a common structure and a common behavior is called :

    • Object

    • Class

    • Entity

    • None of these

    Correct Answer
    A. Class
    Explanation
    A class is a set of objects that share a common structure and behavior. It serves as a blueprint or template for creating objects. Objects created from a class have similar properties and methods defined in the class. They can also interact with each other through these methods. Therefore, a class is the correct answer in this context.

    Rate this question:

  • 17. 

    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, as it provides a user-friendly interface that allows users to easily interact with the database using familiar language. It also supports in the development of complex applications software, as it provides a set of commands and functions that can be used to manipulate and retrieve data from the database, allowing developers to build sophisticated applications. Additionally, it can specify the structure of a database, as it includes commands for creating, modifying, and deleting tables, indexes, and other database objects. Therefore, the correct answer is "All of the above."

    Rate this question:

  • 18. 

    Which database level is closest to the users?

    • External

    • Internal  

    • Physical  

    • Conceptual

    Correct Answer
    A. External
    Explanation
    The external database level is closest to the users. This level focuses on providing a user-friendly interface and presenting data in a format that is easily understandable by users. It involves defining views, which are customized representations of data, and controlling user access to the database. The external level allows users to interact with the database without needing to understand the underlying data structures and organization.

    Rate this question:

  • 19. 

    The level of data abstraction which describes how the data is actually stored is :

    • Conceptual level

    • Physical level

    •  file level

    • None of these

    Correct Answer
    A. Physical level
    Explanation
    The physical level of data abstraction describes how the data is actually stored. It deals with the physical representation of data on the storage media, such as the format, organization, and access methods used. This level is concerned with the low-level details of data storage, such as the arrangement of data blocks, file structures, and storage devices. It is responsible for translating the logical view of data into the physical representation that can be stored and manipulated by the computer system.

    Rate this question:

  • 20. 

    Collection of information stored in a database at a particular moment is :

    • View

    • Schema

    • Instance

    • None of the above

    Correct Answer
    A. Instance
    Explanation
    The term "instance" refers to a specific snapshot or representation of data stored in a database at a particular moment. It represents the actual collection of information that exists at a given time. A database can have multiple instances, each representing a different state or version of the data. This term is commonly used in database management systems to differentiate between the overall structure (schema) and the actual data (instance) stored within the database.

    Rate this question:

  • 21. 

     A schema describes :

    • Record Relationship

    • Data Elements

    • Record and files

    • All of the above

    Correct Answer
    A. Record and files
    Explanation
    A schema describes the structure and organization of data in a database. It includes information about the record and file formats, relationships between records, and the data elements within each record. Therefore, the correct answer is "Record and files."

    Rate this question:

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

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

  • Current Version
  • Mar 20, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Feb 07, 2019
    Quiz Created by
    Gshivani554
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.