CSC 310 Database Design Exam 2023
About this paper
A Second Semester Examination 2022/2023 for CSC 310 Database Design at the University of Buea Faculty of Science, dated 16/06/2023, instructed by Nyanga B., Achankeng P., and Tabo D., worth a maximum of 70 marks. Section A is a 30-item multiple-choice question covering denormalization, functional dependencies, atomic domains, metadata, DBMS components and architecture, locking and transactional integrity, data models, SQL GRANT/REVOKE and role-based privilege inheritance, schema types, data redundancy and inconsistency, transactions, COMMIT/ROLLBACK/Flashback semantics, and further relational-database concepts.
Opens this paper in the app on your phone.
University of Buea
Faculty of Science - FS
Computer Science - CSC
Database Design
Exam · Second Semester · Level 300
From this paper
SECTION A: Answer all Questions. Write the letter of the correct Answer
1.Designers use which of the following to tune the performance of systems to support timecritical operations? a) Denormalization b) Redundant optimization c) Optimization d) Realization
- 2.
In the schema (dept_name, size) we have relations total_inst_2007, total_inst_2008. Which dependency have led to this relation? a) Dept_name, year->size b) Year->size c) Dept_name>size d) Size->year
At a glance
- Course code
- CSC310 (CSC 310)
- Type
- Exam
- Year
- 2023
- Level
- Level 300
- Semester
- Second Semester
- Proposed solution
- Included
Where it's from
University
University of BueaFaculty
Faculty of Science - FSDepartment
Computer Science - CSC
Read CSC310 2023 in Shoracy.
- Every page, with zoom for diagrams and small print
- The proposed solution, one tap away
- Stays on your phone after the first open, even offline
Don't have the app yet?