Computer 1 Past Papers

[OBJECTIVE]

Subject: Computer-I

Time Allowed: 15 Min

Maximum Marks: 10

NOTE: Attempt this Paper on this Question Sheet only. Please encircle the correct option. Division of marks is given in front of each question. This Paper will be collected back after expiry of time limit mentioned above.

 

Part-I Encircle the right answer, cutting and overwriting is not allowed. (1×10=10)

1. A word processor can be used to: :

Write Text B. Edit Text

Print Text D. All

2. Is copyrighted software that is free for a trial period.

System Software B. Application Software

Shareware D. None

3. Which of the following is a correct row address?

AA B. 25

C.3B                                                       D.C5

4. Which one is faster?

RAM B. Cache

Register D. Hard Disk

5. A mouse, trackball and joystick are examples of:

Pointing Devices B. Output Devices

Storage Devices D. None

6. The amount of space between pixels in a CRE display is called:

Dot Pitch B. Pixel Width

Resolution D. Gap Factor

7. A connection fur similar networks uses:

Bridge B. Gateway

Both D. None

8. The actual working area in Microsoft Excel is

Workbook B. Worksheet

Spreadsheet D. Note sheet

9. Which of the following function is used to get the current date?

Exact B. Today

Month D. Year

10. In MS Excel a formula begins with

– B. %

= D. $

 

 

[SUBJECTIVE]

Subject: Computer-I

Time Allowed: 2 Hrs. 45 Min

Maximum Marks: 50

NOTE: ATTEMPT THIS (SUBJECTIVE) ON THE SEPARATE ANSWER SHEET PROVIDED

 

Part-II Give short answers! (20)

Q#1. What are Digital Computers?

Q#2. Differentiate between Data and Information?

Q#3. What is Line Printer?

Q#4. What are Pointing Devices?

Q#5. Differentiate between Hard Copy and Soft Copy?

Q#6. What is Search Engine?

Q#7. What is Slide Animation in MS Power Point?

Q#8. What is Primary Key iu MS Access?

Q#9. What is Solid State memory?

Q#10. What is word Art in MS Word?

 

Part-III Answer following Long Questions. (10 x 3) =30

Q#1. Define Output Devices. Explain Printers in Detail.

Q#2. Describe If-Else formula in MS Excel With example. Also write any two features of MS Word with their uses?

Q#3. What is Memory? Describe ROM and its types?

 

 

[OBJECTIVE]

Subject: Computer-I

Time Allowed: 15 Minutes

Max Marks: 10

NOTE: Attempt this Paper on this Question Sheet only. Please encircle the correct option. Division of marks is given in front of each question. This Paper will be collected back after expiry of time limit mentioned above.

 

Part-I Encircle the right answer, cutting and overwriting are not allowed. (10)

Which of the following is not an Aggregate function?

Min B. Max

Select. D. Avg

2. The attribute that can be divided into other attributes is called

Simple Attribute B. Composite Attribute

Multi-valued Attribute D. Derived Attribute

3. In an Entity-Relationship Diagram “Ellipses” represents

Attributes B. Weak entity set

Relationship sets D. Multi-valued attributes

4. In an Entity-Relationship Diagram “Diamonds” represents:

Attributes B. Multi-valued attributes

Weak entity set D. Relationship sets

5. What is ACID properties of Transactions?

Atomicity, Consistency, Isolation, Database

Atomicity, Consistency, Isolation, Durability

Atomicity, Consistency, Inconsistent, Durability

Automatically, Concurrency, Isolation, Durability

6. If every non-key attribute is functionally dependent on the primary key, the relation will be in

First Normal Form B. Second Normal Form

Third Normal! Form D. Fourth Formal Form

7. Database locking concept is used to solve the problem of

Lost Update B. Uncommitted Dependency

Inconsistent Data D. All of the above

8. UML stands for

Universal Modeling Language B. Unified Modeling Language

United Modeling Language D. Uni Modeling Language

9. Data Manipulation Language (DML) is not to

Create information table in the Database

Insertion of new information into the Database

Deletion of information in the Database

Modification of information in the Database

10. Which of the following is true regarding Referential Integrity?

Every primary-key value must match a primary-key value in an associated table

Every primary-key value must match a foreign-key value in an associated table

Every foreign-key value must match a primary-key value in an associated table

Every foreign-key value must match a foreign-key value in an associated table

 

[SUBJECTIVE]

Subject: Computer-I

Time Allowed: 2 Hours 45 Minutes

Max Marks: 50

NOTE: ATTEMPT THIS (SUBJECTIVE) ON SEPARATE ANSWER SHEET PROVIDED

 

Part-II  Give Short Answers, Each question carries equal marks. (20)

Q#1: What do you understand by ‘Database’?

Q#2: Define DBMS?

Q#3: Define RDBMS?

Q#4: Enlist the advantages of DBMS?

Q#5: What do you understand by Data Redundancy?

Q#6: What do you understand by Data Independence? What are its two types?

Q#7: Explain Normalization and De-Normalization?

Q#8: How many SQL statements are used? Define them.?

Q#9: What is BCNF?

Q#10: What is SQL?

 

Part-III  Give Short Answers, Each question carries equal marks. (30)

Q#3: What is ERD? Draw and explain ERD for Bank Management System?

Q#4: Discuss 3- schema architecture in detail?

Q#5: Discuss database development process in detail?