Myraa Technologies Pharmacist Interview Questions and Answers

NAV stands for Net Asset Value.

• NAV is a financial term used to describe the value of an investment fund's assets minus its liabilities.

• It is calculated by dividing the total value of the fund's assets by the number of outstanding shares.

• NAV is used to determine the price at which shares in the fund are bought and sold.

• It is also used to calculate the performance of the fund over time.

• For example, if a mutual fund has a...read more

I wish to switch to leverage my skills in a new environment and pursue growth opportunities that align with my career goals.

• Career Growth: I am seeking a position that offers more opportunities for advancement, such as leadership roles or specialized projects.

• Skill Development: I want to work in a dynamic environment where I can learn new technologies and methodologies, enhancing my expertise.

• Cultural Fit: I believe th...read more

I believe my combination of experience, skills, and leadership qualities make me well-suited for the role.

• I have a proven track record of successfully managing teams and projects

• I possess strong communication and problem-solving skills

• I am adaptable and able to handle challenging situations effectively

I have 5 years of experience in the retail industry, where I successfully implemented a new inventory management system resulting in a 20% increase in efficiency.

• Implemented a new inventory management system in the retail industry

• Achieved a 20% increase in efficiency

• Led a team to streamline processes and improve customer satisfaction

Handled a tough situation by resolving a major project delay with a client, resulting in positive feedback.

• Identified the root cause of the project delay and communicated transparently with the client

• Developed a revised project timeline with clear milestones and deadlines

• Regularly updated the client on the progress and addressed any concerns promptly

• Client appreciated the proactive communication and efforts to rectify ...read more

I have managed teams of up to 50 members in my current and previous roles. Key challenges include communication, motivation, and conflict resolution.

• Managed a team of 50 members in my current role as a Senior Manager

• Previously managed a team of 30 members as a Team Lead

• Challenges include effective communication to ensure everyone is on the same page, motivating team members to achieve goals, and resolving conflicts amo...read more

Seeking new challenges and growth opportunities

• Desire for career advancement

• Looking for a new challenge

• Seeking opportunities for professional growth

• Want to broaden my skill set

• Company restructuring leading to uncertain future

To replace male with female in Oracle, use the UPDATE statement with the SET clause.

• Use the UPDATE statement with the SET clause to replace male with female in Oracle

• Example: UPDATE employees SET gender='female' WHERE gender='male'

• Make sure to specify the table name and column name correctly

• Use WHERE clause to specify the condition for replacement

Query to display 3rd highest salary

• Use the ORDER BY clause to sort the salaries in descending order

• Use the LIMIT clause to limit the result to the third row

• Use a subquery to exclude the top two salaries

Delete removes specific rows while truncate removes all rows from a table.

• Delete is a DML command while truncate is a DDL command.

• Delete is slower than truncate as it logs each row deletion while truncate does not.

• Delete can be rolled back while truncate cannot be rolled back.

• Delete can have a WHERE clause to specify which rows to delete while truncate removes all rows.

• Delete does not reset the identity of the table wh...read more

A cursor is a database object used to manipulate data in a result set.

• A cursor is used to traverse through a result set one row at a time.

• There are two types of cursors: static and dynamic.

• Static cursors are read-only and scroll forward only.

• Dynamic cursors are updatable and can scroll in any direction.

• Cursors can be used in stored procedures, triggers, and functions.

Display second last line of a file using command line.

• Use the tail command with -n option to display last two lines of the file.

• Then use head command with -n option to display the second last line.

• Example: tail -n 2 file.txt | head -n 1

Command to replace Sam with vam on 5th line

• sed '5s/Sam/vam/' filename.txt

• awk 'NR==5 {sub(/Sam/, "vam")} 1' filename.txt

Command to display blank line in file

• Use echo command with empty quotes to create a blank line in a file

• Syntax: echo '' >> filename

• Alternatively, use printf command with newline character

• Syntax: printf ' ' >> filename

Use the 'du' command to display biggest file on server.

• Open terminal or SSH into server

• Navigate to directory to search from

• Run 'du -a . | sort -n -r | head -n 1' command

• The output will display the biggest file on the server