CPS 510 FINAL PRACTICE EXAMINATION
2026 QUESTIONS WITH ANSWERS
GRADED A+
◍ What is the basic philosophy of Gestalt Therapy?.
Answer: The person strives for wholeness and integration of thinking,
feeling, and behaving.
◍ What does the 'Animus' represent in Jungian archetypes?.
Answer: The natural and primitive masculine aspect of the psyche.
◍ What is a variable ratio schedule of reinforcement?.
Answer: A reinforcement schedule where rewards are given after an
unpredictable number of responses, like in slot machines.
◍ QUESTION 14 - SECTION 2In QBE, if you want to perform an
aggregation like counting records, which operator is used?Choices:A)
`COUNT()`B) `CNT.`C) `SUM.`D) `AGG.`.
Answer: Answer: B) `CNT.`[cite_start]Explanation: QBE supports standard
aggregate functions like `CNT.` (for count), `SUM.`, `MIN.`, `MAX.`,
etc.[cite: 3502].
◍ ### *SECTION 5 - DISK & INDEXING (Topic 8)*QUESTION 33 -
SECTION 5The time it takes for the hard disk arm to move to the correct
cylinder is called:Choices:A) Rotational DelayB) Seek TimeC) Transfer
TimeD) Latency.
Answer: Answer: B) Seek Time[cite_start]Explanation: Seek time is the
time needed to place the read/write head on the target track (cylinder)[cite:
3985].
◍ What is the first stage of personality development according to Freud?.
Answer: Oral Stage (1st year)
,◍ ### *SECTION 4 - ALGORITHMIC NORMALIZATION*QUESTION 25
- SECTION 4Bernstein's Algorithm is primarily used to synthesize relations
into which Normal Form?Choices:A) 1NFB) 2NFC) 3NFD) BCNF.
Answer: Answer: C) 3NF[cite_start]Explanation: Bernstein's algorithm
(Synthesis Algorithm) is used to find a lossless-join and
dependency-preserving decomposition into 3NF[cite: 3135].
◍ What is Sand Play Therapy?.
Answer: A dynamic interpersonal relationship between a person and a
therapist that uses sand play as a medium for expression.
◍ QUESTION 2 - SECTION 1Consider the table `Student(id, name, gpa,
major)`. You want to find the number of students in each major, but only for
majors where the average GPA is greater than 3.0. Which query is
correct?Choices:A) `SELECT major, COUNT(*) FROM Student WHERE
AVG(gpa) > 3.0 GROUP BY major`B) `SELECT major, COUNT(*)
FROM Student GROUP BY major HAVING AVG(gpa) > 3.0`C) `SELECT
major, COUNT(*) FROM Student GROUP BY major WHERE AVG(gpa)
> 3.0`D) `SELECT major, COUNT(*) FROM Student HAVING AVG(gpa)
> 3.0`.
Answer: Answer: B) `SELECT major, COUNT(*) FROM Student GROUP
BY major HAVING AVG(gpa) > 3.0`[cite_start]Explanation: The
`WHERE` clause filters rows before grouping, while `HAVING` filters
groups after the aggregation (like `AVG`) has been performed[cite: 2033].
◍ What are the phases of the existential process in therapy?.
Answer: Initial phase: identification of client assumptions; Middle phase:
source and authority of value system; Final phase: action.
◍ What does Skinner's quote 'A person does not act upon the world, the world
acts upon him' imply?.
Answer: It suggests that behavior is a response to environmental stimuli
rather than an independent action.
◍ QUESTION 27 - SECTION 4A decomposition of relation $R$ into $R_1$
, and $R_2$ is *lossless* if:Choices:A) $R_1 \cup R_2 = R$B) $(R_1 \cap
R_2) \rightarrow R_1$ or $(R_1 \cap R_2) \rightarrow R_2$ (The common
attributes form a key for at least one relation).C) $R_1$ and $R_2$ have no
common attributes.D) The number of tuples in $R_1$ equals the number of
tuples in $R$..
Answer: Answer: B) $(R_1 \cap R_2) \rightarrow R_1$ or $(R_1 \cap R_2)
\rightarrow R_2$[cite_start]Explanation: For a decomposition to be lossless
(allowing reconstruction of the original table via join), the intersection of
attributes must be a superkey of either $R_1$ or $R_2$[cite: 3127, 3193].
◍ How does modeling function in therapy?.
Answer: It involves observational learning where clients learn behaviors by
watching others.
◍ What is the main premise of the phrase 'Perception is reality'?.
Answer: It suggests that an individual's perception of events shapes their
reality.
◍ QUESTION 21 - SECTION 3Which Normal Form is considered strict
enough for most relational database designs to avoid redundancy and
anomalies?Choices:A) 1NFB) 2NFC) BCNF (Boyce-Codd Normal Form)D)
5NF.
Answer: Answer: C) BCNF (Boyce-Codd Normal
Form)[cite_start]Explanation: BCNF is a stronger form of 3NF where every
determinant must be a candidate key, eliminating most redundancy[cite:
3217].
◍ What is 'personalization' in cognitive distortions?.
Answer: Taking an unrelated event and making it about oneself.
◍ What is meant by 'playing the projection'?.
Answer: Encouraging clients to act out their projections to gain insight.
◍ What does Adler mean by social interest?.
Answer: An individual's attitude toward and awareness of being part of the
human community
2026 QUESTIONS WITH ANSWERS
GRADED A+
◍ What is the basic philosophy of Gestalt Therapy?.
Answer: The person strives for wholeness and integration of thinking,
feeling, and behaving.
◍ What does the 'Animus' represent in Jungian archetypes?.
Answer: The natural and primitive masculine aspect of the psyche.
◍ What is a variable ratio schedule of reinforcement?.
Answer: A reinforcement schedule where rewards are given after an
unpredictable number of responses, like in slot machines.
◍ QUESTION 14 - SECTION 2In QBE, if you want to perform an
aggregation like counting records, which operator is used?Choices:A)
`COUNT()`B) `CNT.`C) `SUM.`D) `AGG.`.
Answer: Answer: B) `CNT.`[cite_start]Explanation: QBE supports standard
aggregate functions like `CNT.` (for count), `SUM.`, `MIN.`, `MAX.`,
etc.[cite: 3502].
◍ ### *SECTION 5 - DISK & INDEXING (Topic 8)*QUESTION 33 -
SECTION 5The time it takes for the hard disk arm to move to the correct
cylinder is called:Choices:A) Rotational DelayB) Seek TimeC) Transfer
TimeD) Latency.
Answer: Answer: B) Seek Time[cite_start]Explanation: Seek time is the
time needed to place the read/write head on the target track (cylinder)[cite:
3985].
◍ What is the first stage of personality development according to Freud?.
Answer: Oral Stage (1st year)
,◍ ### *SECTION 4 - ALGORITHMIC NORMALIZATION*QUESTION 25
- SECTION 4Bernstein's Algorithm is primarily used to synthesize relations
into which Normal Form?Choices:A) 1NFB) 2NFC) 3NFD) BCNF.
Answer: Answer: C) 3NF[cite_start]Explanation: Bernstein's algorithm
(Synthesis Algorithm) is used to find a lossless-join and
dependency-preserving decomposition into 3NF[cite: 3135].
◍ What is Sand Play Therapy?.
Answer: A dynamic interpersonal relationship between a person and a
therapist that uses sand play as a medium for expression.
◍ QUESTION 2 - SECTION 1Consider the table `Student(id, name, gpa,
major)`. You want to find the number of students in each major, but only for
majors where the average GPA is greater than 3.0. Which query is
correct?Choices:A) `SELECT major, COUNT(*) FROM Student WHERE
AVG(gpa) > 3.0 GROUP BY major`B) `SELECT major, COUNT(*)
FROM Student GROUP BY major HAVING AVG(gpa) > 3.0`C) `SELECT
major, COUNT(*) FROM Student GROUP BY major WHERE AVG(gpa)
> 3.0`D) `SELECT major, COUNT(*) FROM Student HAVING AVG(gpa)
> 3.0`.
Answer: Answer: B) `SELECT major, COUNT(*) FROM Student GROUP
BY major HAVING AVG(gpa) > 3.0`[cite_start]Explanation: The
`WHERE` clause filters rows before grouping, while `HAVING` filters
groups after the aggregation (like `AVG`) has been performed[cite: 2033].
◍ What are the phases of the existential process in therapy?.
Answer: Initial phase: identification of client assumptions; Middle phase:
source and authority of value system; Final phase: action.
◍ What does Skinner's quote 'A person does not act upon the world, the world
acts upon him' imply?.
Answer: It suggests that behavior is a response to environmental stimuli
rather than an independent action.
◍ QUESTION 27 - SECTION 4A decomposition of relation $R$ into $R_1$
, and $R_2$ is *lossless* if:Choices:A) $R_1 \cup R_2 = R$B) $(R_1 \cap
R_2) \rightarrow R_1$ or $(R_1 \cap R_2) \rightarrow R_2$ (The common
attributes form a key for at least one relation).C) $R_1$ and $R_2$ have no
common attributes.D) The number of tuples in $R_1$ equals the number of
tuples in $R$..
Answer: Answer: B) $(R_1 \cap R_2) \rightarrow R_1$ or $(R_1 \cap R_2)
\rightarrow R_2$[cite_start]Explanation: For a decomposition to be lossless
(allowing reconstruction of the original table via join), the intersection of
attributes must be a superkey of either $R_1$ or $R_2$[cite: 3127, 3193].
◍ How does modeling function in therapy?.
Answer: It involves observational learning where clients learn behaviors by
watching others.
◍ What is the main premise of the phrase 'Perception is reality'?.
Answer: It suggests that an individual's perception of events shapes their
reality.
◍ QUESTION 21 - SECTION 3Which Normal Form is considered strict
enough for most relational database designs to avoid redundancy and
anomalies?Choices:A) 1NFB) 2NFC) BCNF (Boyce-Codd Normal Form)D)
5NF.
Answer: Answer: C) BCNF (Boyce-Codd Normal
Form)[cite_start]Explanation: BCNF is a stronger form of 3NF where every
determinant must be a candidate key, eliminating most redundancy[cite:
3217].
◍ What is 'personalization' in cognitive distortions?.
Answer: Taking an unrelated event and making it about oneself.
◍ What is meant by 'playing the projection'?.
Answer: Encouraging clients to act out their projections to gain insight.
◍ What does Adler mean by social interest?.
Answer: An individual's attitude toward and awareness of being part of the
human community
