Data Base Management System (dbms)(Computer ) Questions and Answers

Question 1. What is a fast way to adjust the width of a column?
  1.    Right click the left side of the column heading
  2.    Double click the left side of the column heading
  3.    Double click the right side of the column heading
  4.    Select tools>adjust column width from the menu
Explanation:-
Answer: Option C. -> Double click the right side of the column heading
Answer: (c)
Question 2. In a large DBMS
  1.    each user can “see” only a small part of the entire database
  2.    each user can access every subschema
  3.    each subschema contains every field in the logical schema
  4.    none of the above is true
Explanation:-
Answer: Option A. -> each user can “see” only a small part of the entire database
Answer: (a)
Question 3. If you are entering data in a form, a quick way to copy a value from the previous record is to press
  1.    Ctrl+’
  2.    F6
  3.    Ctrl+D
  4.    None of the above
Explanation:-
Answer: Option A. -> Ctrl+’
Answer: (a)
Question 4. The following command is used for inserting records
  1.    INSERT
  2.    ADD
  3.    Both of the above
  4.    None of the above
Explanation:-
Answer: Option A. -> INSERT
Answer: (a)
Question 5. Which of the following is NOT a type of Microsoft Access database object?
  1.    Queries
  2.    Workbooks
  3.    Forms
  4.    Tables
Explanation:-
Answer: Option B. -> Workbooks
Answer: (b)
Question 6. What are the columns in a Microsoft Access table called?
  1.    Rows
  2.    Fields
  3.    Cells
  4.    Records
Explanation:-
Answer: Option B. -> Fields
Answer: (b)
Question 7. When you save an Access project, what file format do you use?
  1.    .adp
  2.    .xm.
  3.    .mdb
  4.    All of above
Explanation:-
Answer: Option A. -> .adp
Answer: (a)
Question 8. Users who store data about real people for marketing purposes must register the data and its potential use with
  1.    The computer misuse controller
  2.    The data protection controller
  3.    HM customs and excise
  4.    None of above
Explanation:-
Answer: Option B. -> The data protection controller
Answer: (b)
Question 9. A command that lets you change one or more fields in a record is
  1.    Insert
  2.    Modify
  3.    Look up
  4.    All of the above
Explanation:-
Answer: Option B. -> Modify
Answer: (b)
Question 10. The purpose of the Add-in Manager is to
  1.    Create macros and automate data processing
  2.    Add or remove data in an existing database
  3.    Add or remove templates, macros, and wizards
  4.    All of above
Explanation:-
Answer: Option C. -> Add or remove templates, macros, and wizards
Answer: (c)
© Lakshya_Education.com, All Right Reserved.
Contact Us services