It will execute successfully and produce the required output. SELECT months_between (to_date ('29-feb-2008'), to_date ('29-feb-2008 12:00:00', 'dd-mon-yyyy hh24:mi:ss'))*31 FROM dual; - Approximately 0. If they are equal the function returns a null, else it returns the first of the two terms tested. Cerebral aqueduct passes through the: 1. Answer and Explanation: a. Which of the following will fulfill the requirement? FROM dual; - Hi World!!! Which of the following statements is true regarding an IP address? Columns of data type date, character, and number can use NVL to provide alternate values.
Which of the following is a Case-Conversion Character function? Enjoy live Q&A or pic answer. The sort is in descending order by default. Of ventricular contraction. They must either be of the same type, or it must be possible to convert arg3 to the type of the arg2 parameter. Answer: D. The CONCAT function accepts arguments of all types. It finds the numeric position of a named character. ORA error as the TRUNC function can't have an input parameter when used with dates. SELECT SUBSTR('Life is Calling', 1) FROM dual; - ORA error as there should be minimum 3 arguments to the SUBSTR function. Our experts can answer your tough homework and study a question Ask a question.
The noninteger part of the result represents a portion of the month. What is true about Number functions? Which of the following receptors are specifically responsible for maintenance of balance of body and posture? Rational numbers can be decimals, fractions, and even negative. SELECT CONCAT ('Today is:', SYSDATE) FROM dual; - Today is: 20-feb-13. The vertical line test is used to determine whether or not a curve in a graph represents a function or not. Type ----------------------- -------- ---------------- EMPLOYEE_ID NOT NULL NUMBER(6) FIRST_NAME VARCHAR2(20) LAST_NAME NOT NULL VARCHAR2(25) EMAIL NOT NULL VARCHAR2(25) PHONE_NUMBER VARCHAR2(20) HIRE_DATE NOT NULL DATE JOB_ID NOT NULL VARCHAR2(10) SALARY NUMBER(8, 2) COMMISSION_PCT NUMBER(2, 2) MANAGER_ID NUMBER(6) DEPARTMENT_ID NUMBER(4). What is an IP address actually associated with? If they are identical, then NULL is returned. Assuming the last names of the employees are in a proper case in the table employees, what will be the outcome of the following query? SQL - The SQL SELECT Statement. Answer: C. Any arithmetic operation with NULL results in a NULL. To know more about function follow.
00, '$99G999D99') FROM dual; Answer: A, D. The format model $99G999D99 formats given number into numeric, group separator, and decimals. What will be returned as a result of the following query? Which of the following functions are used to differentiate between even or odd numbers in Oracle DB? Note that 01-JAN-2013 occurs on a Tuesday.
The TRIM function literally trims off leading or trailing (or both) character strings from a given source string. SELECT replace(9999. Feedback from students. SELECT lower (100+100) FROM dual; - 100+100. The iris __________. Similarly, it can be done for year also. Questions and Answers. SELECT lpad (1000 +300. This explains why red blood cells are capsule shaped and white blood cells have no definite shape. Therefore the answers are:-. Although specific evidence from randomized clinical trials are lacking when the. Zero, one or more of the following statements is true).
It will list the job IDs for all employees from EMPLOYEES table. Number functions can't be nested. If the first expression is not null, the NVL2 function returns the second expression. TRIM function cannot be applied on expressions and NUMBERS. Mod(divisor, dividend). Statement 1: It is a device that performs a variety of functions that would otherwise be carried out by separate peripheral devices. Paired with at least one value of the output variable. "Date2 = Date1-Num1". The value of 'x' must be an integer and can be negative. An NVL function cannot be used with arguments of DATE datatype.
Modify individual data items. Rods are very sensitive and contribute to daylight vision. Answer: C. The CONCAT, SUBSTR and REPLACE are Character-manipulation Character functions while INITCAP, LOWER and UPPER are case conversion character functions. What is the number of arguments Single Row functions accept? Assuming the sysdate is 10-JUN-13, What will be the outcome of the following query? SELECT INSTR('1#3#5#7#9#', -3, 2) FROM dual; - #5. Answer: C. The DUAL table has one column named DUMMY and one row which has a value 'X'. Sometimes sequences are defined as functions with a domain of natural numbers. The LTRIM and RTRIM functions can be used in combination with each other. SELECT trunc (sysdate, 'mon') FROM dual; - 10-JUN-13. Gives an error because NULL cannot be explicitly specified to NVL function.
Also, Solve Python Functions Exercise. SELECT SUBSTR(first_name, 2) FROM employees; SELECT SUBSTR(first_name, -2) FROM employees; SELECT RTRIM(first_name, 2) FROM employees; SELECT TRIM(first_name, 2) FROM employees; Answer: B. Hence the correct answer is option 'B'. On changing the value of the independent variable the value of the dependent variable also changes. It aligns character strings to the left and number strings to right of a column.
NVL2 (arg1, arg2, arg3). Unlimited access to all gallery answers. Answer: C. The LOWER function converts a string to lower case characters. The number of days between them. Does the answer help you? Answer: D. The LPAD(string, length after padding, padding string) and RPAD(string, length after padding, padding string) functions add a padding string of characters to the left or right of a string until it reaches the specified length after padding.
Gauthmath helper for Chrome.