Page 282 - Information_Practice_Fliipbook_Class11
P. 282

Solved Exercises


        A.  Multiple Choice Questions
           1.   Which of the following deals with modification and retrieval of data?
              a.  Database definition
              b.  Database Construction
              c.  Database manipulation
              d.  Database deletion

           2.  Who, among the following, analyses the data requirements of the end users and designs the structure of the database?
              a.  Database Administrator   b. Systems Analyst   c. Database Designers   d. Application Programmers

           3.   Which of the following is the advantage of DBMS?
              a.  Increases data redundancy
              b.  Ensures shared access and integrity of data
              c.  Backup and recovery of data is not possible
              d.  Any person can access data from a database.

           4.  Which of the following describes the characteristics of an entity
              a.  Attribute            b. Degree              c. Cardinality         d. constraint
           5.  Which of the following specifies the restrictions imposed on the data stored in a database?
              a.  Attribute            b. Degree              c. Cardinality         d. constraint
           6.  Which of the following is NOT included in the relational schema?
              a.  Attributes of table
              b.  Queries used to retrieve data
              c.  Data types of attributes
              d.  Constraints on the attributes
           7.  Which of the following represents an entity’s instance?
              a.  Attribute            b. Degree              c. Tuple               d. cardinality
           8.  Which of the following defines the cardinality of a relation?
              a.  Number of rows       b. Number of columns   c. Name of the relation   d. Constraints in a relation
           9.   Which of the following is used if the value for an attribute in a relation is not known?
              a.  None                 b. Unknown             c. N-A                 d. NULL
          10.  A key that is a set of one or more columns and can identify a record uniquely is called ______________.
              a.  Natural Key          b. Candidate Key       c. Alternate Key       d. Primary Key
          11.  Which key accepts multiple null values?
              a.  Foreign Key          b. Candidate Key       c. Primary Key         d. None of these
          12.  What is the full form of DBMS?
              a.  Data Backup Management System               b. Data of Binary Management System
              c.  Database Management System                  d. Database Management Service
          13.  Which of the following is the correct statement about DBMS?
              a.  DBMS is a collection of queries
              b.  DBMS is a high-level programming language
              c.  DBMS is a web development platform
              d.  DBMS is an application that stores, modifies, and retrieves records
          14.  In which of the following formats data is stored in the database management system?
              a.  Image                b. Text                c. Table               d. Graph


          268  Touchpad Informatics Practices-XI
   277   278   279   280   281   282   283   284   285   286   287