Finance Systems Engineer Test

Consider the following financial data for 3 companies (in millions) for the year 2022:

Which company has the highest Earnings Per Share (EPS) if each company has 50 million outstanding shares?

Gajni Inc. issued 2000 $100 9% bonds on May 1 (year 1). These bonds are issued at 103 plus accrued interest. The bonds are dated Jan 1 (year 1) and mature on Jan 1 (year 5). Interest needs to be paid twice a year (Jan 1 and July 1). The cost of issuing the bonds, $5000 was paid by Gajni Inc. to the investment bank. What would be the net cash receipt realized by Gajni Inc. from the issuance of these bonds?

Consider the following financial data for five companies for the year 2022:

Which company has the highest Return on Capital Employed (ROCE)?

Phenomenal Pte. Ltd., a Singapore based company secured a new client in Germany for their SaaS business, and is expecting to receive a payment of EUR 1.3 million after 6 weeks. They want to be certain of the amount they receive and plan on using the derivates market to hedge the risk. What action would you recommend?

What does the following pseudo code print?

Here are three pseudocodes for calculating the Nth Fibonacci number. Which of the following statements about these codes are true?

A: Time complexity/efficiency of CODE 1, CODE 2, CODE 3 is the same.
B: CODE 2 is more space-efficient than CODE 3.
C: CODE 3 is more space-efficient than CODE 2.
D: CODE 2 is more time-efficient than CODE 1.
E: CODE 3 is more time-efficient than CODE 1.

Go through the following faulty palindrome detection pseudocode and test cases. For which of the test cases would the code return true?

Testcases
A: a
B: aba
C: aaa
D: aac

A new popular app tracks the activities performed by its users and grants them rewards based on each individual's total activities performed in a year. This data is maintained in a database table (activitesinfo), with the following columns: userid, totalactivities, reward. This year, due to fundraising activity, the company has decided to further reward its users by enhancing the reward as per the following formula: If reward < = 4000, increase it by 2%, If 4000 < reward <= 8000, increase it by 4%, If reward > 8000, increase it by 6%.
The tech team has written three different scripts to calculate increment for each slab, each script is to run as a separate transaction. Here are the three scripts:

Script 1:
For users with reward <= 4000, set reward = reward * 1.02

Script 2:
For users with reward > 4000 and reward <= 8000, set reward = reward * 1.04

Script 3:
For users with reward > 8000, set reward = reward * 1.06

Each script is to be executed separately. Which of the following options will update the rewards as expected:

A: Execute Script 1 followed by Script 2 followed by Script 3
B: Execute Script 2 followed by Script 3; Script 1 running concurrently throughout
C: Execute Script 3 followed by Script 2; Script 1 running concurrently throughout
D: Execute Script 3 followed by Script 2 followed by Script 1
E: Execute Script 2 followed by Script 3 followed by Script 1

Consider the following SQL table:

How many rows does the following SQL query return?

Consider the following SQL table:

Which of the following SQL commands will find the ‘nth highest Sales’ if it exists (returns null otherwise)?

Consider the following SQL table:

Which of the following SQL queries would return the year when neither a football or cricket winner was chosen?

Consider the following SQL table:

What will be the first two tuples resulting from the following SQL command?

Consider the following SQL table:

How many tuples does the following query return?

You are designing a data model for a healthcare system with the following requirements:

A: A separate table for each entity with foreign keys as specified, and a DoctorPatient table linking Doctors to Patients.
B: A separate table for each entity with foreign keys as specified, without additional tables.
C: A combined PatientDoctor table replacing Patient and Doctor, and separate tables for Appointment and Prescription.
D: A separate table for each entity with foreign keys, and a PatientPrescription table to track prescriptions directly linked to patients.
E: A single table combining Patient, Doctor, Appointment, and Prescription into one.
F: A separate table for each entity with foreign keys as specified, and an AppointmentDetails table linking Appointments to Prescriptions.

Look at the given ER diagram. What do you think is the least number of tables we would need to represent M, N, P, R1 and R2?

Consider a healthcare database with a table named PatientRecords that stores patient visit information. The table has the following attributes:

- VisitID
- PatientID
- PatientName
- DoctorID
- DoctorName
- VisitDate
- Diagnosis
- Treatment
- TreatmentCost

In this table:

- Each VisitID uniquely identifies a patient's visit and is associated with one PatientID.
- PatientID is associated with exactly one PatientName.
- Each DoctorID is associated with a unique DoctorName.
- TreatmentCost is a fixed cost based on the Treatment.

Evaluating the PatientRecords table, which of the following statements most accurately describes its normalization state and the required actions for higher normalization?

A: The table is in 1NF. To achieve 2NF, remove partial dependencies by separating Patient information (PatientID, PatientName) and Doctor information (DoctorID, DoctorName) into different tables.
B: The table is in 2NF. To achieve 3NF, remove transitive dependencies by creating separate tables for Patients (PatientID, PatientName), Doctors (DoctorID, DoctorName), and Visits (VisitID, PatientID, DoctorID, VisitDate, Diagnosis, Treatment, TreatmentCost).
C: The table is in 3NF. To achieve BCNF, adjust for functional dependencies such as moving DoctorName to a separate Doctors table.
D: The table is in 1NF. To achieve 3NF, create separate tables for Patients, Doctors, and Visits, and remove TreatmentCost as it is a derived attribute.
E: The table is in 2NF. To achieve 4NF, address any multi-valued dependencies by separating Visit details and Treatment details.
F: The table is in 3NF. To achieve 4NF, remove multi-valued dependencies related to VisitID.

Based on the ER diagram, which of the following statements is accurate and requires specific knowledge of the ER diagram's details?

A: A Student can major in multiple Departments.
B: An Instructor can belong to multiple Departments.
C: A Course can be offered by multiple Departments.
D: Enrollment records can link a Student to multiple Courses in a single semester.
E: Each Course must be associated with an Enrollment record.
F: A Department can offer courses without having any instructors.

You are working on a Linux system and have recently installed a new program named myprogram. The executable is located in /opt/myprogram/bin/. You want to be able to run this program from any directory in your shell without specifying the full path.

You executed the following command:
export PATH="/opt/myprogram/bin"

However, when you try to run the program using myprogram, you get the following error message:
-bash: myprogram: command not found

Which of the following commands can fix this issue and allow you to run the program?

A: export PATH=$PATH:/opt/myprogram/bin/
B: export PATH="/opt/myprogram:$PATH"
C: export PATH="/opt/myprogram/bin:$PATH"
D: ln -s /opt/myprogram/bin/myprogram /usr/local/bin/myprogram

Consider the following directory structure:

You start at /home/user and execute the following commands:

What will be the resulting directory structure?

How many times will the following code will print "Mellow Yellow"?

Our software engineering intern, Wu is looking to use port 4545 on localhost to connect to a remote server called woot.bananas.com on port 80. Which command would you recommend for this?