DBMS Questions

1. A table is the primary unit of physical storage of data in a database.State True or False.
        True
        False


2. Which one of the following is a large database from which information can be extracted and analyzed?
        Database
       Sysbase
       Datawarebase
       DBMS


3. Which one of the following data model resembles like a tree structure?
        Network model
        Database model
        Relational model
        Hierarchical model


4. Which of the given option is true regarding the database?
        Data Sharing
        Data concurrency
        All the listed options
        Data Integrity
        Data security


5. DBMS can replace a file processing system. State True or False.
           True
           False


6. What is the advantage of minimizing the data redundancy?
           Avoid inaccuracies and inconsistencies in the data
           Save Time in processing the data
           All the above
       To free up the storage space


7. Which of the following are the types of data models
           All of the listed option
           Network Model
           Hierarchial Model
           Relational Model
   


8. Database system is used to restrict the user from unauthorized access.State True or False
           True
           False


9. Which one of the following is true about RDBMS?
     1. It has relations data integrity
     2. It can maintain many users at the same time
     3. It doesn’t support client/server based application
     4. It is a relational database system
     5. It cant maintain many user at the same time.
           1,3
           2,4
           3,4,5
           1,2,4
           4,5
   


10. What is the main component of DBMS?
            Data Modelling
            Data Dictionary
            OLAP Database
            Data Sharing


11. In which form does the data gets stored in the database?
            Electronic form
            Rich text form
            Non Electronic form
            None of the listed options
    


12. Which of the given term refers to Data about the data?
            Data Abstraction
            Views
            Metadata
            Program
    


13. DBMS controls redundancy.State True or False.
            False
            True


14. DBMS helps us to?
      1. Define Schemas and Subschemas in a database and establish relationships between different data elements
      2. Enter Data Into Database
      3. Manipulate and Process Data
      4. None of the listed options
            1&2
            1&3
            4
            1&2&3


15. The traditional storage of data which is organized by the customers by storing it in separate folders. This is the example of which type of database system?
            Object oriented
            Hierarchical
            Relational
            Network


16. Arena is married to Vasu and she has a unique SSN. This is an example of a (an):
            Unary Relationship
            Binary Relationship
            Hierarchical Relationship
            Ternary Relationship


17. In DBMS, what will be the outcome when we map a multivalued attribute for any entity from the ER model to the relational model?
            None of the above
            Many relations, one for each of the distinct values of the attribute
            A column in the relation that represents the entity E
            One relation that contains a foreign key and a column for the attribute


18. The efficient performance of the database is based on which of the following factors?
      1. Database Design
      2. Application Design
      3. Network Speed
      4. None of the listed option
           1,2,3
            1,3
            1,2
            4


19. There are two tables Customers and Orders. The customers table would include information about the names , addresses and phone numbers of customers, the order table would include information about the products ordered , the customers,order dates and sales prices ,the Sales manager wants to view only the number of orders placed by each customer on a given date, A Finance Manager in the same company can group the table entries to view only the names and addresses of customers with pending payments.This Grouping of data is possible in?
           Hierarchical Database
            Relational Databse
            Network Database
            Object Oriented Database

Note: If any of the answer is wrong please post a comment. I will update it.