All Topics
Topic10 questions
6. Function-Scalar & AggregateQuestions & Answers
Practice 10 6. Function-Scalar & Aggregate questions with detailed answers and explanations. Tap any question below to study the full solution.
6. Function-Scalar & Aggregate question list
What will be the output for the below query: select ceil(5.3) from dual;Single row functions can be nested to any level. State true or False.All columns in the SELECT list that are not in group functions must be in the GROUP-BY clause. State True or False.Group functions can be used in the where clause. State True or False.We need to create a report to display the order id, ship date and order total of your ORDER table. If the order has not been shipp…Select the suitable option for fetching the output of the following query. select substr("Oracle World",1,6) from dual;To display the names of employees that are not assigned to a department. Evaluate this SQL statement: SELECT last_name, first_name…ABC company wants to give each employee a $100 salary increment. You need to evaluate the results from the EMP table prior to the …To generate a report that shows an increase in the credit limit by 15% for all customers. Customers whose credit limit has not bee…Which statement is true regarding the default behavior of the ORDER BY clause?Practice more topics
PrimerPrep has independently reviewed practice questions and coding exercises — all free.