Basic Computer Application Exam Paper

Only available on StudyMode
  • Download(s) : 103
  • Published : May 20, 2013
Open Document
Text Preview
UNIVERSITY OF MAURITIUS
FACULTY OF LAW AND MANAGEMENT

SECOND SEMESTER EXAMINATIONS MAY 2011 PROGRAMME BSC (HONS) ACCOUNTING (MINOR : FINANCE) BSC (HONS) ACCOUNTING (MINOR : MANAGEMENT) BSC (HONS) FINANCE BSC (HONS) FINANCE (MINOR : LAW) BSC (HONS) MANAGEMENT BSC (HONS) MANAGEMENT WITH FINANCE BSC (HONS) MARKETING MANAGEMENT BSC (HONS) HUMAN RESOURCE MANAGEMENT BSC (HONS) BUSINESS STUDIES (PART-TIME) MODULE NAME DATE May 2011 TIME Hours NO. OF QUESTIONS SET 4 BASIC COMPUTER APPLICATION MODULE CODE CSE 1021

DURATION NO. OF QUESTIONS TO BE ATTEMPTED

2 Hours 4

INSTRUCTIONS TO CANDIDATES This question paper has 4 questions. Answer ALL questions. This paper has an attached answer sheet to answer multiple choice questions. Detach the answer sheet and tie it with your answer booklet.

BASIC COMPUTER APPLICATION – CSE 1021

MULTIPLE CHOICE QUESTIONS [30 marks]

Question 1
Answer the MCQs in the attached Answer sheet provided at the end of the exam paper. 1. Which of the following is NOT a level at which data can be described in the database? A. External B. Schematic C. Conceptual D. Internal E. None of the above 2. Which of the following should always be TRUE for a primary key in a relational model? A. The primary key of a table serves to uniquely identify individual rows of the table. B. The primary key of a table is allowed to be null. C. Non-key columns are not dependent on the primary key. D. A primary key may not consist of more than one column. E. It is a key that is used as a reference to relate one entity to another entity. 3. __________ is the software that manages and controls access to the database. A. Database B. Database Application C. Database System D. DBMS E. None of the above 4. DDL allows A. Users to define a database B. Users to delete data C. Users to insert data in a database D. Users to update data from a database E. None of the above 5. Dependency based on only part of a composite primary key is called A. B. C. D. E. Functional dependency. Partial dependency. Transitive dependency. Primary key dependency. Foreign key dependency. Page 1 of 11

BASIC COMPUTER APPLICATION – CSE 1021

6. In a relation schema, the degree of a relation defined as the number of A. Tuples. B. Attributes. C. Data types. D. Relationships. E. Tables. 7. Which of the following acts as the bridge between Human and Machine in a DBMS Environment? A. People B. Hardware C. Software D. Procedures E. None of the above 8. Internal view of the database architecture is the A. Users’ view of the database B. Community view of the database. C. Physical representation of the database on the computer D. Logical representation of the database on the computer E. All of the above 9. Which of the following is an advantage of the client-server architecture? A. Reduced network traffic B. Hardware cost may be reduced C. Increased consistency D. Increased performance E. All of the above 10. One of the benefits of normalisation is that it A. B. C. D. E. Increase the number of attributes Increases data redundancy Increases update anomalies Increases the stability of the relational data model Increases the application maintenance cost

11. Which of the following is TRUE for an Entity Relational Diagram (ERD)? A. B. C. D. E. Represents data view of a system Provides a high level, conceptual view of the database structure Specify the data to be stored Shows the relationship that exists between data items All of the above

Page 2 of 11

BASIC COMPUTER APPLICATION – CSE 1021

12. Which of the following is NOT part of an Entity Relationship Diagram (ERD)? A. Entity B. Relationship C. Actor D. Attributes E. Cardinality 13. The different kinds of requirements include: A. B. C. D. E. Functional, non-functional, semi-functional and data requirements. Functional, non-functional, semi-functional and physical requirements. Functional, non-functional, semi-functional and social requirements. Functional, non-functional, semi-functional and...
tracking img