Tag Archives: Customers

Your organization makes mlib.jar available to your cloud customers. While working on a code cleanup project

Your organization makes mlib.jar available to your cloud customers. While working on a code cleanup project for mlib.jar, you see this method by customers:What security measures should be added to this method so that it meets the requirements for a customer accessible method? A. Make enableService private. B. Create a method that validates the hostName and portNumber parameters… Read More »

Examine the description of the CUSTOMERS table: (Exhibit) For customers whose income level has a value,

Examine the description of the CUSTOMERS table:For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.Which query should be used? A. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level <> NULL… Read More »

Examine the description of the CUSTOMERS table: (Exhibit) For customers whose income level has a value,

Examine the description of the CUSTOMERS table:For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.Which query should be used? A. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level <> NULLAND due_amount <>… Read More »

Your organization makes mlib.jar available to your cloud customers. While working on a code cleanup project

Your organization makes mlib.jar available to your cloud customers. While working on a code cleanup project for mlib.jar, you see this method by customers:What security measures should be added to this method so that it meets the requirements for a customer accessible method? A. Create a method that validates the hostName and portNumber parameters before opening the socket.… Read More »

Examine the description of the CUSTOMERS table: (Exhibit) For customers whose income level has a value,

Examine the description of the CUSTOMERS table:For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.Which query should be used? A. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_incoms_level IS NOT NULLAND due_amount… Read More »

Examine this SQL statement: SELECT cust_id, cust_last_name "Last Name" FROM customers WHERE country_id

Examine this SQL statement:SELECT cust_id, cust_last_name “Last Name”FROM customersWHERE country_id = 10UNIONSELECT cust_id CUST_NO, cust_last_nameFROM customersWHERE country_id = 30Identify three ORDER BY clauses, any one of which can complete the query successfully.(Choose three.) A. ORDER BY 2, cust_id B. ORDER BY “CUST_NO” C. ORDER BY “Last Name” D. ORDER BY 2, 1 E. ORDER BY CUST_NO Correct Answer:… Read More »

Examine the description of the CUSTOMERS table: (Exhibit) You want to display details of all customers

Examine the description of the CUSTOMERS table:You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.Which query can be used? A. SELECT * FROM customers WHERE city LIKE `D_’; B. SELECT * FROM customers WHERE city = `%D_’; C. SELECT * FROM customers WHERE city… Read More »

Examine this SQL statement: SELECT cust_id, cust_last_name "Last Name" FROM customers WHERE country_id

Examine this SQL statement:SELECT cust_id, cust_last_name “Last Name”FROM customersWHERE country_id = 10UNIONSELECT cust_id CUST_NO, cust_last_nameFROM customersWHERE country_id = 30Identify three ORDER BY clauses, any one of which can complete the query successfully.(Choose three.) A. ORDER BY “Last Name” B. ORDER BY CUST_NO C. ORDER BY “CUST_NO” D. ORDER BY 2, 1 E. ORDER BY 2, cust_id Correct Answer:… Read More »

Examine the description of the CUSTOMERS table: (Exhibit) You want to display details of all customers

Examine the description of the CUSTOMERS table:You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.Which query can be used? A. SELECT * FROM customers WHERE city = `D_%’; B. SELECT * FROM customers WHERE city LIKE `D_%’; C. SELECT * FROM customers WHERE city… Read More »

Examine the description of the CUSTOMERS table: (Exhibit) You want to display details of all customers

Examine the description of the CUSTOMERS table:You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.Which query can be used? A. SELECT * FROM customers WHERE city LIKE ‘D_’; B. SELECT * FROM customers WHERE city = ‘%D_’; C. SELECT * FROM customers WHERE city… Read More »