10th Class Computers Science Database Concepts Question Bank

done Database Management System Total Questions - 15

• question_answer1)
  What do you mean by query with respect to database system?
  A)
  Command that is used to interact with a database. done clear
  B)
  Table which is created but never used. done clear
  C)
  The element which describes the architecture of DBMS. done clear
  D)
  All of these done clear
  View Solution play_arrow

• question_answer2)
  Which of the following fields is NOT suitable for a primary key?
  A)
  An autonumber field        done clear
  B)
  A student's registration number done clear
  C)
  Bank account number     done clear
  D)
  Date of birth done clear
  View Solution play_arrow

• question_answer3)
  Which of the following statements is INCORRECT about a database?
  A)
  Fields are organised in columns in a database. done clear
  B)
  Each field may contain several records. done clear
  C)
  Collection of fields which represent a complete unit of information is called record. done clear
  D)
  A database is a repository of information needed for running certain functions in an organisation. done clear
  View Solution play_arrow

• question_answer4)
  A database system in which relationships among data are established in such a way that one data item is present as a child of another, is said to be a/an _________ DBMS.
  A)
  Relational          done clear
  B)
  Isolated done clear
  C)
  Hierarchical                    done clear
  D)
  Virtual done clear
  View Solution play_arrow

• question_answer5)
  A system in which database is maintained in the form of tables and in which all records are stored in rows is called _________.
  A)
  Relational database         done clear
  B)
  Object oriented database done clear
  C)
  Flat database                 done clear
  D)
  Varied database done clear
  View Solution play_arrow

• question_answer6)
  Design view in MS-Access does NOT allow you to _______.
  A)
  Edit field values done clear
  B)
         Change data type done clear
  C)
  Assign validation rule       done clear
  D)
  Change field name done clear
  View Solution play_arrow

• question_answer7)
  Which of the following MS-Access object will help you to create a blank table in Design view?
  A)
                        done clear
  B)
    done clear
  C)
                        done clear
  D)
    done clear
  View Solution play_arrow

• question_answer8)
  A piece of code or a statement that gives you filtered data according to some conditions and specifications is called a _________.
  A)
  Table                done clear
  B)
  Form done clear
  C)
  Query         done clear
  D)
  Report done clear
  View Solution play_arrow

• question_answer9)
  Multiple mismatching copies of the same data is known as _________.
  A)
  Data standardisation       done clear
  B)
  Data sharing done clear
  C)
  Data inconsistency          done clear
  D)
  Data dependency done clear
  View Solution play_arrow

• question_answer10)
  Which of the following is/are the advantages of database management?
  A)
  Enforcement of standards done clear
  B)
  Data sharing done clear
  C)
  Enhanced data security done clear
  D)
  All of these done clear
  View Solution play_arrow

• question_answer11)
  Given below is a snapshot of two files maintained by a college and the hostel separately, for keeping records of their students. Which of the following problem occurs in the records?

  File-1
  S_Id	Name	Course	Contact No.
  FET-001	Shikha	IT	000000000
  FET-002	Anirudh	CSE	000000000
  FET-003	Priyanka	CSE	000000000
  FET-004	Abhishek	IT	000000000
  File-2
  S_Id	Name	Course	Contact No.
  FET-001	Shikha	301	000000000
  FET-002	Anirudh	302	000000000
  FET-003
  FET-004

   
  A)
  Data Duplicacy done clear
  B)
  Data Inconsistency done clear
  C)
  Data Consistency done clear
  D)
  Both [A] and [B] done clear
  View Solution play_arrow

• question_answer12)
  Which of the following options is used to keep an area of a datasheet visible while scrolling to another area in MS-Access 2010?
  A)
  Freeze width                   done clear
  B)
  Freeze fields done clear
  C)
  Mark width                     done clear
  D)
  Mark column done clear
  View Solution play_arrow

• question_answer13)
  Given below is a snapshot of a table. Identify which fields can be designated as primary key and unique keys?

  Emp-id	Fname	Lname	Email
  MK101	Vikas	Kumar	arvind@mkworld.com
  MK102	Bhanu	Sharma	Bhanu@mkworld.com
  MK103	Vinay	Kapoor	vinay@mkworld.com
  MK104	Nitin	Arya	Nitin@mkworld.com

   
  A)

  Primary key - Fname

  Unique keys - Emp-id, Fname

  done clear
  B)

  Primary key - Emp-id

  Unique keys - Emp-id, Email

  done clear
  C)

  Primary key - Email

  Unique keys - Fname, Lname

  done clear
  D)

  Primary key - Fname

  Unique keys - Emp-id, Email

  done clear
  View Solution play_arrow

• question_answer14)
  Which of the following data types is suitable for storing alpha-numeric information, that contain more than 255 characters in MS-Access?
  A)
  Number done clear
  B)
  Text done clear
  C)
  Memo   done clear
  D)
  Yes/No done clear
  View Solution play_arrow

• question_answer15)

  Rearrange the given steps in a CORRECT order to design a database.

  (i) Determine the fields you need.

  (ii) Determine the tables you need.

  (iii) Determine the purpose of your database.

  (iv) Identify the fields with unique values in each record.

  (v) Determine the relationships between tables.

  A)
  (i) \[\to \] (ii) \[\to \] (iii)\[\to \] (iv) \[\to \](v) done clear
  B)
  (i)\[\to \] (ii) \[\to \] (iv) \[\to \](iii) \[\to \](v) done clear
  C)
  (iii) \[\to \](ii) \[\to \](i)\[\to \] (iv) \[\to \] (v) done clear
  D)
  (iii) \[\to \](v) \[\to \](iv)\[\to \](ii) \[\to \] (i) done clear
  View Solution play_arrow