DATABASES AUGUST 2022 PAST PAPER

MONDAY: 1 August 2022. Morning paper. Time Allowed: 3 hours.

This paper has two sections. SECTION I has twenty (20) Multiple Choice Questions. SECTION II has three practical questions of sixty (60) marks. All questions are compulsory. Marks allocated to each question are shown at the end of the question.

SECTION I

1. Which of the following correctly defines a database? (2 marks)
A. Organised collection of information organised in a text file
B. Collection of data without organising it
C. Organised collection of data that cannot be updated
D. Organised collection of data or information that can be accessed, updated, and managed

2. An in -built language in DBMS for all data operations is known as? (2 marks)
A. Python
B. Visual basics
C. Jython
D. SQL

3. Which type of data can be stored in the database? (2 marks)
A. Image oriented data only
B. Text, files containing data and many others
C. Data in the form of audio or video only
D. Text only

4. A database object that stores data extracted from a database is known as? (2 marks)
A. Tables
B. Views
C. Materialised views
D. Query

5. Which of the following is type of license in DBMS software? (2 marks)
A. Number of users
B. Number of rows
C. Number of tables
D. Number of fields

6. Which of the following is the odd one out? (2 marks)
A. MySQL
B. Dbase IV
C. IBM DB2
D. Excel

7. The command “create” in DBMS can be classified as? (2 marks)
A. DML(Data Manipulation Language)
B. Query
C. DDL(Data Definition Language)
D. Relational Schema

8. Which of the following is the correct term for database model in which the data in tables are connected with relationships? (2 marks)
A. Relational
B. Hierarchical
C. Object oriented
D. Flat file

9. The statement “SELECT course_id, name,FROM course, registered WHERE course_id= registered_ID” can be replaced with? (2 marks)
A. Select * from instructor
B. Select * from registered
C. Select name, course_id from course natural join registered;
D. Select name, course_id from course;

10. Which database object is used to cause another action to take place? (2 marks)
A. Trigger
B. Form
C. Query
D. Report

11. The command used to show the table structure is? (2 marks)
A. Select
B. DESC
C. Alter
D. Update

12. The files that keep track of database updates are known as? (2 marks)
A. Reports
B. Trails
C. Data files
D. Logs

13. The act of ensuring that a database performs optimally by configuration is known as? (2 marks)
A. Adapting
B. Tuning
C. Backing up
D. Triggering

14. Which of the following statements is correct based on databases?
A. A database stores only the current data in use
B. It is not necessary to backup data if it is replicated
C. It is sometimes necessary to have redundancy in databases
D. Redundancy is not completely necessary in DBMS

15. A hot backup cannot be used directly. Is this statement TRUE or FALSE? (2 marks)
A) TRUE
B) FALSE

16. Which of the following statements is correct?
A. Sample databases in a DBMS are not useful
B. Sample databases may be used by a user to create tables
C. Sample databases should not be used directly by users
D. We should delete sample databases

17. What is the name given to a large collection of the information or data accumulated form several different sources? (2 marks)

A. Data Management
B. Data Mining
C. Data Warehouse
D. Backup

18. The extraction of data and information from the data warehouse is known as? (2 marks)
A. Data mining
B. Data redundancy
C. Data recovery tool
D. Data selection

19. Data about data is also known as? (2 marks)
A. Directory
B. Sub Data
C. Warehouse
D. Meta Data

20. Which of following terms does NOT describe a row of table in a relational database? (2 marks)
A. Record
B. Tuple
C. Entity
D. Column

SECTION II

21. Create a word processor document named Question 21 and use it to save answers to questions 1 to 5 in form of screenshots:
Using a DBMS of your choice, answer the questions below:

1. Create a database called exams. (3 marks)

2. In exams create a table shown below.

3. Input the following data:

4. Add a field called teachercode. (4 marks)

5. Input teachercode of your choice. (3 marks)

Upload Question 21 document.

(Total: 20 marks)

22. Create a word processor document and name it Question 22. Use Question 22 document to save answers to questions 1 to 5 below in form of screenshots.

Using a DBMS tools and perform the following:

1. Create a database called secure (3 marks)

2. Create a table plants with the following fields (plantid, plantname) (5 marks)

3. Set encryption on for the table (5 marks)

4. Create a user James for the database (3 marks)

5. Set password as “Eun45@” (3 marks)

Upload Question 22 document.

(Total: 20 marks)

23. Create a word processor document named Question 23 and use it to save answers to questions 1 to 6 below in form of screenshots.
Perform the following database activities:

1. Create a database called “publishing” . (3 marks)

2. Create a table publisher with the following fields(pubid, pubname) (3 marks)

3. Input three rows of data of your choice. (3 marks)

4. Backup the database. (3 marks)

5. Delete the database. (3 marks)

6. Restore the database. (5 marks)

Upload Question 23 document.

(Total: 20 marks)

(Visited 79 times, 1 visits today)
Share this:

Written by