Scribd
Upload
16 views1 page

2nd Year Computer-18

This document is an examination paper for a 2nd-year Computer Science class at the National Educational Complex Karampur, consisting of multiple-choice questions, short answer questions, and long questions. It covers topics such as data storage strategies, database design, data definitions, and relationships in databases. The total marks for the exam are 50, with specific sections allocated for different types of questions.

Uploaded by

Jamshed ali
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
16 views1 page

2nd Year Computer-18

This document is an examination paper for a 2nd-year Computer Science class at the National Educational Complex Karampur, consisting of multiple-choice questions, short answer questions, and long questions. It covers topics such as data storage strategies, database design, data definitions, and relationships in databases. The total marks for the exam are 50, with specific sections allocated for different types of questions.

Uploaded by

Jamshed ali
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

National Educational Complex Karampur

Subject: Computer Science Class: 2nd year


Name ______________________ Roll No ____________ Total Marks: 50
Q1. Choose the correct answer. 08

No Multiple Choice Questions A B C D

1 Data is stored at single site while following Centralized Distributed Hybrid Partitioned
Strategy Strategy Strategy Strategy

2 The relationship between entities is represented E-R Context Level Decision Table Data Flow
graphically by using: Diagrams Diagram
Diagram

3 Which of the following is responsible for designing Data End User Database Database
the database system? Administrator Administrator Manager

4 ______ contain data definitions used in the Utilities Data Database All of these
database: Dictionary integrity

_________ problem occurs when same Homonyms Synonyms Redundant Mutually


information is stored in two different ways: Information Exclusive data
5

6 ___ is wildcard character: > < + *

7 In Access, the structure of a table can be created Design View Datasheet Both (a) and None
in: View (b)

8 The extension for a video file is: .avi .mpg Both a & b .txt

Q.2: Write short answers of given questions. 18


1. Differentiate between candidate key and primary key.
2. Differentiate between data redundancy and data inconsistency.
3. Why is it important to specify data type and size of a field?
4. Write the names of files storage point of view?
5. Write the names of files regarding usage point of view?
6. What types of problems may exist in the relations before normalization?
7. What is removed when a relation is converted from 2NF to 3NF?
8. Differentiate between an application window and a database window?
9. What do you mean by IDE?
Q.3: Attempt given long questions. 24

1. What are relationships and what are their types?


2. Write a note on data types available in MS Access.
3. What elements combined produce physical database design? Explain.

You might also like