[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?
