Inf3703 Exam Pack 2023

What are the most important security goals database designers should meet? a. Integrity; Confidentiality; Availability b. Availability; Integrity; Accuracy c. Confidentiality; Accuracy; Integrity d. Accuracy; Confidentiality; Availability {Ans: a. Integrity; Confidentiality; Availability}The _____ cache is a shared, reserved memory area that stores the most recently executed SQL statements or PL/SQL procedures, including triggers and functions. a) Data or buffer b) System c) Sort d) SQL {Ans: d) SQL}____ is a measurement of the density of the data held in the data cube. A. Compactness B. Concentration C. Mass D. Sparsity {Ans: D. Sparsity}What does it mean that indexes are physically and logically independent of the data in the associated table? a. Indexes are placed on unique field b. Indexes require own storage space c. Indexes pointer are created for some the records d. Indexes are only used to access a table {Ans: b. Indexes require own storage space}Which of the following does the Feasibility Study NOT address? 1- Replacement of existing system 2- Operational cost 3- System cost 4- The technical aspect of hardware and software requirements {Ans: 1- Replacement of existing system}System support activities cover all tasks directly related to the day-to-day operations of