Exam Questions on Database Management Systems (DBMS) - Set 01 - ObjectiveBooks

Exam Questions on Database Management Systems (DBMS) - Set 01

Practice Test: Question Set - 01


1. Which view is used to arrange table data in different graphical layouts to summarize data?
    (A) Table view
    (B) Design view
    (C) Data sheet view
    (D) Pivot chart view

2. Which combination of key zooms the content of active cell in Access table?
    (A) Ctrl + F2
    (B) Ctrl + F5
    (C) Shift + F2
    (D) Shift + F5

3. Which validation rule allows only positive numbers for fields in?
    (A) Is Null or > = 0
    (B) Is Null or Positive
    (C) Is Null or < 0
    (D) None of the above

4. Write the output when the data 'Primary Key' is set to the text < in Access?
    (A) Primary key
    (B) primary key
    (C) PRIMARY KEY
    (D) Primary Key

5. What is the maximum number of characters allowed in text field is access?
    (A) 255
    (B) 256
    (C) 64000
    (D) 65000

6. Which combination of key allows user to move to the first field in the first record in Access table?
    (A) Ctrl + Tab
    (B) Shift +Tab
    (C) Shift + Home
    (D) Ctrl + Home

7. Which validation rule allows exactly digits for number fields in Access?
    (A) Is Null or Between 100000 and 99999
    (B) Is Null or Like ??????
    (C) Is Null or >= 0 AND< = 99999
    (D) Is Null or < = 99999

8. What is the reason for not accepting zero in the fields of Access tables?
    (A) Fields is set with is Null or > 0
    (B) Fields is set with is Null or < = 0
    (C) Fields is set with is Null or! [0]
    (D) Fields is set with is Null or like ???

9. What is the expansion of OLE in Access?
    (A) Object linking and embedding
    (B) Object linking and encrypting
    (C) Object linking and editing
    (D) Object linking

10. Which object stores information about related data?
    (A) Document
    (B) Table
    (C) Page
    (D) Screen

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests:

    Blogger Comment
    Facebook Comment
adplus-dvertising