Assume a variable having value, position="MADAM', what is the expected value of the function trim (Both 'M' from position)? a. ADA b. MADA c. MADAM O d. ADAM Consider two variables m1 and m2 both has value 'SQL' . What is the possible output of the function NULLIF (m1, m2)? O a. 0 O b. SQL O c. NULL (-) O d. No output Which of the possible names will be returned from the given query? Select name from student where name like '%d%' ; O a. Fredrick O b. Green O c. Brian O d. Mary

Assume a variable having value, position="MADAM', what is the expected value of the function trim (Both 'M' from position)? a. ADA b. MADA c. MADAM O d. ADAM Consider two variables m1 and m2 both has value 'SQL' . What is the possible output of the function NULLIF (m1, m2)? O a. 0 O b. SQL O c. NULL (-) O d. No output Which of the possible names will be returned from the given query? Select name from student where name like '%d%' ; O a. Fredrick O b. Green O c. Brian O d. Mary

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

write XPath expressions in an R Notebook that evaluate the following queries; display the results in your R Notebook. What are the titles of all books written by "Galos, Mike"? List the titles and the prices. In what genre is the book with id "bk109". What are the titles of the books that sell for the lowest price? (Use the min aggregation function) List the title and prices of all books in the "Computer" genre. What is the number of all books that cost less than $5? (Use the count aggregation function)
Write a function that determines the number of missing entries for a specified column in the dataset. The function should return a string detailing the number of missing values.Function Specifications: Should take a pandas DataFrame and a column_name as input and return a string as output. The string should detial the number of missing entries in the column. Should be generalised to be able to work on ANY dataframe. ### START FUNCTION def total_missing(df,column_name): #code total_missing(df,'Age') Expected Outputs: total_missing(df,'Age') == "Age has 177 missing values" total_missing" (df,'Survived') == "Survived has 0 missing values"
The question is attached Write a SQL function that accepts a principal mortgage amount, an annual percentagerate (APR), and the number of years a mortgage will be paid back over. Calculate theassociated monthly mortgage payment according to the following annuity formula:A = P (i + i(1+i)n −1 )where:A = Monthly Payment AmountP = Principle (Initial) Mortgage Amounti = APR / 12 = Monthly Interest Raten = years * 12 = Total Number of PaymentsBe sure to specify that data types of the input arguments have enough significant digits toaccount for realistic mortgage amounts (as large as in the millions of dollars) and APRs(down to the sixth decimal place will be sufficient).
The question is attached Write a SQL function that accepts a principal mortgage amount, an annual percentagerate (APR), and the number of years a mortgage will be paid back over. Calculate theassociated monthly mortgage payment according to the following annuity formula:A = P (i + i(1+i)n −1 )where:A = Monthly Payment AmountP = Principle (Initial) Mortgage Amounti = APR / 12 = Monthly Interest Raten = years * 12 = Total Number of PaymentsBe sure to specify that data types of the input arguments have enough significant digits toaccount for realistic mortgage amounts (as large as in the millions of dollars) and APRs(down to the sixth decimal place will be sufficient). CREATE OR REPLACE FUNCTION monthly_Payment('250000.00', '0.04125', '30')RETURNS @A.LANGUAGE PL/pgsqlAS$$beginDeclare @p money = 250000.00Declare @i decimal (20,8) = 0.04125Declare @n int = 360SELECT Monthly payment = @p * ( (@i/12 * power (1 + @i/12, @n)) / ((power (1 + @i/12, @n) -1)));end;$$;
For the following function, specify the type of its return. You can assume each function is called with an appropriate argument, as specified by its docstring. def f(x, y): """ x: int or float. y: int or float """ x + y - 2 a. float b. int c. int or float d. NoneType e. boolean
Write a SQL function that accepts a principal mortgage amount, an annual percentage rate (APR), and the number of years a mortgage will be paid back over. Calculate the associated monthly mortgage payment according to the following annuity formula: ? = ? ? + ? (1+?) ? ( −1 ) where: A = Monthly Payment Amount P = Principle (Initial) Mortgage Amount i = APR / 12 = Monthly Interest Rate n = years * 12 = Total Number of Payments Be sure to specify that data types of the input arguments have enough significant digits to account for realistic mortgage amounts (as large as in
Write a SQL function that accepts a principal mortgage amount, an annual percentage rate (APR), and the number of years a mortgage will be paid back over. Calculate the associated monthly mortgage payment according to the following annuity formula: ? = ? ? + ? (1+?) ? ( −1 ) where: A = Monthly Payment Amount P = Principle (Initial) Mortgage Amount i = APR / 12 = Monthly Interest Rate n = years * 12 = Total Number of Payments Be sure to specify that data types of the input arguments have enough significant digits to account for realistic mortgage amounts (as large as in the millions of dollars) and APRs (down to the sixth decimal place will be sufficient). You must name your function: __monthlyPayment Where is your last name and is the day of the month you were born. This naming convention is merely meant to make the grading process easier, so that all of the functions, procedures, and triggers have unique names. How would I invoke this function? Below is an example of my function…
Hello, I am having an error and cannot figure out how to solve this question. Could someone please assist? Please be advised, I am using PostgreSQL as that is what was used in class. Thus, I must use PLPGSQL Code CREATE OR REPLACE FUNCTION Moreno_03_bankTriggerFunction()RETURNS TRIGGERLANGUAGE PLPGSQLAS$$CREATE TRIGGER Wise_12_bankTriggerAFTER DELETE ON accountFOR EACH ROW EXECUTE PROCEDURE Moreno_15_bankTriggerFunction();
Write a script that creates and calls a function named fnStudentUnits that calculates the total course units of a student in the StudentCourses table. To do that, this function should accept one parameter for the student ID, and it should return the sum of the course units for the student. The SELECT statement that calls the function should return the StudentID from the StudentCourses table, the CourseNumber and CourseUnits from the Courses table, and the value return by the fnStudentUnits function for that student.
1. Write a SQL function that accepts a principal mortgage amount, an annual percentage rate (APR), and the number of years a mortgage will be paid back over. Calculate the associated monthly mortgage payment according to the following annuity formula: ? = ?( ? + (? /((1+?)^? ( −1 )) where: A = Monthly Payment Amount P = Principle (Initial) Mortgage Amount i = APR / 12 = Monthly Interest Rate n = years * 12 = Total Number of Payments Be sure to specify that data types of the input arguments have enough significant digits to account for realistic mortgage amounts (as large as in the millions of dollars) and APRs (down to the sixth decimal place will be sufficient).
1-int fx(char &x) is a function with parameter passed by value(False/True) 2-int fx(char x) is a function with int return value(False/True) 3-void fx(char ch) is a function with no return value(False/True) 4-char fx( int x) is a function with int return value(False/True)
write one line of code ONLY.Given list below: myNums = [-2, 28, 4, -2, 36, 2] Using the built-in functions, print the smallest value and the largest value in the list, myNums. Just make sure to precisely match the output format below.Write your code in the ANSWER area provided below (must include comments if using code is not covered in the course). Example OutputSmallest = -2Largest = 36