Tag Archives: number

The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE.

The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE.NLS_DATE_FORMAT is set to DD-MON-RR.Which two are true about data type conversions involving these columns in query expressions? (Choose two.) A. invoice_date=”15-march-2019″ : uses implicit conversion B. qty_sold = ‘0554982’ uses implicit conversion C. CONCAT (qty_sold, invoice_date) : requires explicit… Read More »

Table ORDER_ITEMScontains columns ORDER_ID, UNIT_PRICEand QUANTITY, of data type NUMBER. Examine these

Table ORDER_ITEMScontains columns ORDER_ID, UNIT_PRICEand QUANTITY, of data type NUMBER.Examine these SQL statements:Statement 1:SELECT MAX(unit_price * quantity) “Maximum Order”FROM order_items;Statement 2:SELECT MAX(unit_price * quantity) “Maximum Order”FROM order_itemsGROUP BY order_id;Which two statements are true? A. Both the statements give the same output. B. Statement 1 returns only one row of output. C. Statement 2 returns only one row of… Read More »

The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE.

The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE.NLS_DATE_FORMAT is set to DD-MON-RR.Which two are true about data type conversions involving these columns in query expressions? (Choose two.) A. qty_sold BETWEEN ‘101’ AND ‘110’ : uses implicit conversion B. qty_sold = ‘0554982’ uses implicit conversion C. invoie_date >… Read More »

The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER. Which two queries execute successfully?

The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.Which two queries execute successfully? (Choose two.) A. SELECT TO_CHAR(NVL(cust_credit_limit * .15, `Not Available’)) FROM customers; B. SELECT NVL(cust_credit_limit * .15, `Not Available’) FROM customers; C. SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), `Not Available’) FROM customers; D. SELECT NVL(TO_CHAR(cust_credit_limit * .15), `Not Available’) FROM customers; E. SELECT NVL2(cust_credit_limit *… Read More »

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE. You

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE.You want to display the date of the first Monday after the completion of six months since hiring.The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day on the week.Which query can be used? A. SELECT… Read More »

A customer has requested an interview that will create an incident in Service Cloud along with a number

A customer has requested an interview that will create an incident in Service Cloud along with a number of tasks (linked to the incident).From a data mapping perspective at the entity level, how can this be achieved with the minimum number of steps? A. Map the global entity to the Incident object and create an entity for Task… Read More »

You have a number attribute "the child's age in years". In an interview, you want to ensure that the

You have a number attribute “the child’s age in years”. In an interview, you want to ensure that the user is only able to enter ages between 0 and 15.What are the three methods to achieve this? A. Write an error event rule. B. Use a regular expression within the Edit Attribute dialog box. C. Create a number… Read More »

The service provider must make sure that the Area 2 routing database limits the number of IP addresses in the routing table Which two configurations must be implemented to meet the requirements? (Choose two)

Refer to the exhibit. A network engineer must meet these requirements to provide a connects, solution: The customer connected to Area 2 needs to access the application in Area 1 on the 10.10.10.0/24 subnet The Customer must not have access to the 20.10 30.0/24 subnet. The service provider must make sure that the Area 2 routing database limits… Read More »