Blog

Questions 10 to 15: Standalone String Functions   Question 13 What will the following command return? SELECT SUBSTRING(SUBSTRING_INDEX(‘apple-banana-cherry’, ‘-‘, -2), 1, 6);

Questions 10 to 15: Standalone String Functions   Question 14 What will the following command return? SELECT CONCAT(‘Code ‘, LENGTH(‘Data’), LENGTH(‘Base’));

Questions 19 to 20: Evaluating 1NF Compliance   Question 19 Below is a table description and its data: mysql> DESC courses; +——-+————-+——+—–+———+—————-+ | Field | Type | Null | Key | Default | Extra | +——-+————-+——+—–+———+—————-+ | id      | int     | NO  | PRI | NULL     | auto_increment | | name | varchar(50) | YES |    | NULL |    | +——-+————-+——+—–+———+—————-+   mysql> SELECT* FROM courses; +—-+———————–+ | id | name | +—-+———————–+ | 1 | Database Systems | | 2 | Web Development | | 3 | Software Engineering | +—-+———————–+ Is the above table in First Normal Form (1NF)?

How many rows will be returned by the following query? SELECT name FROM student WHERE gpa > 3.8 OR gpa < 3.2;

McKee uses the term DIMENSION primarily to refer to:

A story whose events are arranged so that the audience can follow their temporal order is told in [BLANK-1] time.

McKee argues that True Character is revealed through choice under pressure. Explain what he means. Why does pressure make a character’s choices more revealing?

McKee calls the sum of a character’s observable qualities—such as appearance, mannerisms, personality, occupation, attitudes, and style of speech—[BLANK-1].

Using the case information above answer the following question. Choose one of the four ethical issues you identified in the previous question. You have been asked to advise RICA’s Board to help fill in the following analysis for the chosen ethical issue. Apply the Seven-Step Ethical Analysis Framework below by filling in the Explanation/Analysis column below: Step Explanation/Analysis Issue State the dilemma and competing interests precisely. Authority Identify law, governing documents, donor terms and policy. Stakeholders Explain who benefits, who may be harmed and whose trust is at stake. Ethical analysis Apply duties, fairness, consequences, mission and public trust etc. Alternatives Consider 2-3 realistic options. Recommendation Choose and defend the most appropriate action and support your choice. Safeguards Recommend disclosure, recusal, documentation, controls or monitoring etc.

Using the case information above answer the following question. Identify the type of fraud that occurred and explain the scenario in terms of the three elements of the Fraud Triangle: Pressure/Incentive, Opportunity, and Rationalization.