Question
In a spreadsheet like MS Excel, the function used to
calculate the net present value (NPV) of an investment is:Solution
The =NPV () function in Excel calculates the net present value of an investment by using a discount rate and a series of future cash flows. =IRR () calculates the internal rate of return, =PV () calculates the present value of a single lump sum or annuity, =FV () calculates the future value, and =RATE () calculates the interest rate per period.
A PL/SQL `TRIGGER` is a stored program that automatically executes in response to:
Which SQL command is used to retrieve data from a table?
Which SQL clause is used to group rows based on one or more columns?
Which type of attack exploits software bugs to execute arbitrary code on a system?
A system is in a safe state when:
A "diamond" shape in an E-R Diagram typically represents a:
Which of the following is a significant disadvantage of using a traditional file system compared to an RDBMS?
What is a page fault?
What will re.findall(r'\d+', 'abc123def45ghi') return?Â
Which of the following is a type of phishing attack?