Scribd Logo
Upload

Welcome to Scribd!

  • 83 views

    Pacific Group of Colleges: Multan Campus

    Uploaded by

    Areesha Naeem
    This document contains a practice test for the subject of Computer Science. It has 3 questions with multiple choice and short answer questions about database concepts and Microsoft Access. Question 1 has 10 multiple choice questions testing knowledge about database fundamentals and MS Access features. Question 2 has 5 short answer questions asking to define and differentiate database terms. Question 3 asks to discuss field properties in databases in detail.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Pacific Group of Colleges: Multan Campus

    Uploaded by

    Areesha Naeem
    83 views1 page
    This document contains a practice test for the subject of Computer Science. It has 3 questions with multiple choice and short answer questions about database concepts and Microsoft Access. Question 1 has 10 multiple choice questions testing knowledge about database fundamentals and MS Access features. Question 2 has 5 short answer questions asking to define and differentiate database terms. Question 3 asks to discuss field properties in databases in detail.

    Original Title

    2nd Year Test 4

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains a practice test for the subject of Computer Science. It has 3 questions with multiple choice and short answer questions about database concepts and Microsoft Access. Question 1 has 10 multiple choice questions testing knowledge about database fundamentals and MS Access features. Question 2 has 5 short answer questions asking to define and differentiate database terms. Question 3 asks to discuss field properties in databases in detail.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    83 views1 page

    Pacific Group of Colleges: Multan Campus

    Uploaded by

    Areesha Naeem
    This document contains a practice test for the subject of Computer Science. It has 3 questions with multiple choice and short answer questions about database concepts and Microsoft Access. Question 1 has 10 multiple choice questions testing knowledge about database fundamentals and MS Access features. Question 2 has 5 short answer questions asking to define and differentiate database terms. Question 3 asks to discuss field properties in databases in detail.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 1

    PACIFIC GROUP OF COLLEGES

    MULTAN CAMPUS
    SERIES TEST NO 4 (Intermediate Part-II)
    NAME:__________________________________ ROLL NO: _______________SECTION:________________

    SUBJECT: COMPUTER SCIENCE MAXIMUM NUMBER: 30 TIME ALLOWED: 60 MIN

    Q. No. 1: Choose the best option from the following. (10)


    1. Every table must have a:
    (a) Foreign key (b) Composite key (c) Primary key (d) Sort key
    2. The degree of relation refers to the number of:
    (a) Rows (b) Tables (c) Field (d) Columns
    3. What is the default field size of a text data-type in MS-Access?
    (a) 2 (b) 5 (c) 20 (d)50
    4. How many query view are available in MS-Access?
    (a) 2 (b) 3 (c) 4 (d) 5
    5. Which symbol indicates that you are editing a record?
    (a) Pencil (b) Black arrow (c) key (d) Asterisk
    6. In the MS Access, tables contains:
    (a) Fields (b) Records (c) Characters (d) File
    7. A database consists of various components called:
    (a) Tools (b) Properties (c) Entities (d) Object
    8. The extension of image file is:
    (a) .exe (b) .doc (c) .bmp (d) .ppt
    9. The example of popular DBMS is:
    (a) MS-Word (b) MS-Access (c) MS-Excel (d) MS-PowerPoint
    10. Which is shortcut key is used to open an existing database in MS-Access?
    (a) CTRL + N (b) CTRL + S (c) CTRL + O (d) CTRL + Z
    Q. No.2 Answer the short questions: (12)
    1. Differentiate between degree and cardinality of a relation?

    2. Define join?

    3. List any four properties of a good relational database management system?

    4. Differentiate between query and report in MS-Access.

    5. Describe action query?

    6. Which two database objects can be used to create a report?

    Q. No. 3 What is field property? Discuss different field properties in detail. (8)

    You might also like