Queries can be used within statement(s): update delete All of the answers Insert

None

Select name from instructor where name like '%Math' order by name; By default, the order by clause lists item in order. O Descending O Ascending Same O Any

Number of mappers can be configured in the job config Select one: O True False Return to: General +)

Computer engineering question Write in APEX - Anonymous window Please design an Aggregate query over the  Opportunity Records by grouping the Compaign Id  and the avg amount. Loop over the fetched records and display the records

You should use an Oracle function to calculate the number of days that have gone between your birthday and the current date.

What are the benefits of sub queries?

"Delete from customer" will result * O nothing happen empty the customer table no where condition so error message delete the customer table O O O

Row trigger that gives the sum total before insert or update using sql

calculate_new_balance Given a starting balance (a number), and a list of transaction tuples, calculate the final balance for an account. Transaction tuples are of the shape ("description", amount, "withdrawal")  , or ("description", amount, "deposit").  The last entry in the tuple will be either "withdrawal" or "deposit". Every withdrawal decreases the balance of the account by the specified amount, and every deposit increases the balance. The return value is the new account balance, as a number. (which could be negative) Sample calls should look like: >>> calculate_new_balance(100, [("payday", 20, "deposit"), ("new shoes", 50, "withdrawal"), ("illicit winnings", 200, "deposit")])270>>> calculate_new_balance(100, [])100