1z0-061 Exam Dumps | Examine the data in the CUST_NAME column of the CUSTOMERS table. CUST

<< Prev Question Next Question >>

Question 164/300

Examine the data in the CUST_NAME column of the CUSTOMERS table.
CUST_NAME
---------------------
Lex De Haan
Renske Ladwig
Jose Manuel Urman
Jason Mallin
You want to extract only those customer names that have three names and display the * symbol in place of the
first name as follows:
CUST NAME
---------------------
*** De Haan
**** Manuel Urman
Which two queries give the required output? (Choose two.)

A. SELECT LPAD(SUBSTR(cust_name, INSTR(cust_name, ' ')), LENGTH(cust_name), '*') "CUST NAME" FROM customers
WHERE INSTR(cust_name, ' ', 1, 2)<>0;

B. SELECT LPAD(SUBSTR(cust_name, INSTR(cust_name, ' ')), LENGTH(cust_name)- INSTR (cust_name, ' '), '*') "CUST NAME"
FROM customers
WHERE INSTR(cust_name, ' ', 1, 2)<>0 ;

C. SELECT LPAD(SUBSTR(cust_name, INSTR(cust_name, ' ')), LENGTH(cust_name), '*') "CUST NAME" FROM customers
WHERE INSTR(cust_name, ' ', -1, 2)<>0;

D. SELECT LPAD(SUBSTR(cust_name, INSTR(cust_name, ' ')), LENGTH(cust_name)- INSTR (cust_name, ''), '*') "CUST NAME"
FROM customers
WHERE INSTR(cust_name, ' ', -1, -2)<>0;

Question List (300q): Question 1: Which two statements are true regarding the USING and ON cla...; Question 2: View the Exhibit and examine the structure of the customers ...; Question 3: The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMB...; Question 4: Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three...; Question 5: You issue the following command to alter the country column ...; Question 6: View the Exhibit and examine the structure of the PRODUCTS, ...; Question 7: What is true of using group functions on columns that contai...; Question 8: Examine the structure of the PROMOTIONS table: (Exhibit) The...; Question 9: View the Exhibit and examine the structure of the products t...; Question 10: You need to generate a list of all customer last names with ...; Question 11: The STUDENT_GRADES table has these columns: (Exhibit) Which ...; Question 12: View the Exhibit and examine the data in the PROJ_TASK_DETAI...; Question 13: Examine the structure of the employees table. (Exhibit) You ...; Question 14: Evaluate the following two queries: Exhibit: (Exhibit) Exhib...; 1 commentQuestion 15: In the customers table, the CUST_CITY column contains the va...; Question 16: See the Exhibit and examine the structure of ORD table: Exhi...; Question 17: View the Exhibit and examine the structure of the products t...; Question 18: You issued the following command: SQL> DROP TABLE employe...; Question 19: Examine the statement: GRANT select, insert, update ON stude...; Question 20: View the Exhibit and examine the structure of the customers ...; Question 21: Which one is a system privilege?...; Question 22: Which statement is true regarding the COALESCE function?...; Question 23: Examine this statement: SELECT student_id, gpa FROM student_...; Question 24: Examine the types and examples of relationships that follow:...; Question 25: View the Exhibit and examine the description of SALES and PR...; Question 26: View the Exhibit and examine the structure of the customers ...; Question 27: You want to create a table employees in which the values of ...; Question 28: You need to write a SQL statement that returns employee name...; Question 29: Examine the structure and data of the CUSTJTRANS table: CUST...; Question 30: Examine the structure of the EMP_DEPT_VU view: (Exhibit) Whi...; Question 31: Which two statements are true regarding views? (Choose two.)...; Question 32: A data manipulation language statement _____....; Question 33: Which two statements are true regarding working with dates? ...; Question 34: View the Exhibit for the structure of the student and facult...; Question 35: View the Exhibit and examine the structure of the PROMOTIONS...; Question 36: You issue the following command to drop the products table: ...; Question 37: You need to display the date 11-Oct-2007 in words as 'Eleven...; Question 38: You want to display 5 percent of the employees with the high...; Question 39: Top N analysis requires _____ and _____. (Choose two.)...; Question 40: Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NU...; Question 41: Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tab...; Question 42: Examine the structure and data in the PRICE_LIST table: Name...; Question 43: View the Exhibit and examine the structure of ORDERS and CUS...; Question 44: View the Exhibit and examine the structure of the PROMOTIONS...; Question 45: You work as a database administrator at ABC.com. You study t...; Question 46: The PART_CODE column in the SPARES table contains the follow...; Question 47: See the Exhibit and examine the structure and data in the IN...; Question 48: You need to design a student registration database that cont...; Question 49: You need to list the employees in DEPARTMENT_ID 30 in a sing...; Question 50: What is true about sequences?; Question 51: Examine the data in the PROMO_BEGIN_DATE column of the promo...; Question 52: Which four are attributes of single row functions? (Choose f...; Question 53: View the Exhibit and examine the structure of the CUSTOMERS ...; Question 54: Evaluate the following SQL statements: Exhibit: (Exhibit) Wh...; Question 55: You work as a database administrator at ABC.com. You study t...; Question 56: View the Exhibit and examine the data in the costs table. (E...; Question 57: You work as a database administrator at ABC.com. You study t...; Question 58: The user Sue issues this SQL statement: GRANT SELECT ON sue....; Question 59: View the Exhibit and examine the structure of the PRODUCTS t...; Question 60: View the Exhibit and examine the structure of the PRODUCTS t...; Question 61: Examine the structure of the orders table: (Exhibit) You wan...; Question 62: Examine the structure and data of the CUST_TRANS table: (Exh...; Question 63: Which view should a user query to display the columns associ...; Question 64: View the Exhibit and examine the structure of the CUSTOMERS ...; Question 65: View the Exhibit and examine the data in the PROMO_CATEGORY ...; Question 66: The user Alice wants to grant all users query privileges on ...; Question 67: Which two statements are true regarding indexes? (Choose two...; Question 68: Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NU...; Question 69: View the Exhibit and examine the structure of the SALES and ...; Question 70: You created an ORDERS table with the following description: ...; Question 71: Which SQL statement would you use to remove a view called EM...; Question 72: View the Exhibit and examine the structure of the product, c...; Question 73: In which two cases would you use an outer join? (Choose two....; Question 74: Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tab...; Question 75: View the Exhibit and examine the description for the PRODUCT...; Question 76: Which three SQL statements would display the value 1890.55 a...; Question 77: In which four clauses can a sub query be used? (Choose four....; Question 78: What is true about updates through a view?...; Question 79: You need to produce a report for mailing labels for all cust...; Question 80: The EMPLOYEES table has these columns: LAST NAME. VARCHAR2(3...; Question 81: Which two statements about sub queries are true? (Choose two...; Question 82: View the Exhibits and examine the structures of the PROMOTIO...; Question 83: Which two statements are true regarding tables? (Choose two....; Question 84: Examine the data in the CUST_NAME column of the customers ta...; Question 85: Which statements are true regarding the FOR UPDATE clause in...; Question 86: Which two statements are true regarding single row functions...; Question 87: You want to display the date for the first Monday of the nex...; Question 88: View the Exhibit and examine the data in the PROMOTIONS tabl...; Question 89: View the Exhibit and examine the structure of the promotions...; Question 90: Which SQL statement returns a numeric value?...; Question 91: See the Exhibit and examine the structure of the PROMOTIONS ...; Question 92: The CUSTOMERS table has these columns: The CUSTOMER_ID colum...; Question 93: Examine the structure of the transactions table: (Exhibit) Y...; Question 94: Which statement adds a constraint that ensures the CUSTOMER_...; Question 95: Evaluate these two SQL statements: SELECT last_name, salary,...; Question 96: You need to extract details of those products in the SALES t...; Question 97: Which two statements about creating constraints are true? (C...; Question 98: You need to calculate the number of days from 1st January 20...; Question 99: Evaluate the following query: SELECT INTERVAL '300' MONTH, I...; Question 100: Which constraint can be defined only at the column level?...; Question 101: Evaluate the following SQL statement: SQL> SELECT cust_id...; Question 102: Which two statements are true regarding constraints? (Choose...; Question 103: View the Exhibit and evaluate the structure and data in the ...; 1 commentQuestion 104: Examine the data in the ename and hiredate columns of the em...; Question 105: View the Exhibit and examine the structure of the PROMOTIONS...; Question 106: View the exhibit and examine the description for the SALES a...; Question 107: You are currently located in Singapore and have connected to...; Question 108: You need to modify the STUDENTS table to add a primary key o...; Question 109: Evaluate this SQL statement: SELECT e.emp_name, d.dept_name ...; Question 110: View the Exhibit and examine the structure of the PRODUCTS t...; Question 111: You need to create a table named ORDERS that contain four co...; Question 112: Which three tasks can be performed using SQL functions built...; 1 commentQuestion 113: Examine the structure proposed for the TRANSACTIONS table: (...; Question 114: You want to display 5 percent of the rows from the sales tab...; Question 115: Examine the structure of the INVOICE table: Exhibit: (Exhibi...; Question 116: Using the customers table, you need to generate a report tha...; Question 117: Which two statements are true regarding single row functions...; Question 118: Which three statements are true regarding sub queries? (Choo...; Question 119: YOU need to display the date ll-oct-2007 in words as 'Eleven...; Question 120: View the Exhibit and examine the structure of the CUSTOMERS ...; Question 121: Which SQL statements would display the value 1890.55 as $1, ...; Question 122: Which object privileges can be granted on a view?...; Question 123: You are currently located in Singapore and have connected to...; Question 124: Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tab...; Question 125: EMPLOYEES and DEPARTMENTS data: EMPLOYEES (Exhibit) DEPARTME...; Question 126: Which three statements are true about multiple-row sub queri...; Question 127: You own a table called EMPLOYEES with this table structure: ...; Question 128: Which statement is true regarding the INTERSECT operator?...; Question 129: Evaluate the SQL statement: SELECT LPAD (salary, 10, '*') FR...; Question 130: You are the DBA for an academic database. You need to create...; Question 131: Which statement correctly describes SQL and /SQL*Plus?...; Question 132: Which three statements/commands would cause a transaction to...; Question 133: Which two statements complete a transaction? (Choose two)...; Question 134: Which substitution variable would you use if you want to reu...; Question 135: Which two statements are true about constraints? (Choose two...; Question 136: Examine the structure of the EMPLOYEES table: (Exhibit) Whic...; Question 137: Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tab...; Question 138: Which statements are correct regarding indexes? (Choose all ...; Question 139: Examine the structure of the sales table: (Exhibit) Evaluate...; Question 140: Evaluate the following query: (Exhibit) What would be the ou...; Question 141: The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4)...; Question 142: The customers table has the following structure: (Exhibit) Y...; Question 143: You want to display the date for the first Monday of the nex...; Question 144: View the Exhibits and examine products and sales tables. (Ex...; Question 145: Examine the data in the LIST_PRICE and MIN_PRICE columns of ...; Question 146: Which two statements are true regarding the count function?...; Question 147: See the Exhibit and examine the structure of the PROMOSTIONS...; Question 148: You need to create a table for a banking application. One of...; Question 149: Which object privileges can be granted on a view?...; Question 150: Examine the structure of the EMPLOYEES and DEPARTMENTS table...; Question 151: Examine the structure of the SHIPMENTS table: (Exhibit) You ...; Question 152: Examine the structure of the customers table: (Exhibit) CUST...; Question 153: What is true about the WITH GRANT OPTION clause?...; Question 154: Examine the structure of the PROMOS table: (Exhibit) You wan...; Question 155: You want to create an ORD_DETAIL table to store details for ...; Question 156: Which two statements are true regarding the DELETE and TRUNC...; Question 157: View the Exhibit and examine the structure of the products t...; Question 158: Evaluate the following CREATE SEQUENCE statement: CREATE SEQ...; Question 159: Which SQL statement accepts user input for the columns to be...; Question 160: Examine the structure proposed for the transactions table: (...; Question 161: Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(...; Question 162: View the Exhibit and examine the description for the CUSTOME...; Question 163: View the Exhibits and examine the structures of the products...; Question 164: Examine the data in the CUST_NAME column of the CUSTOMERS ta...; Question 165: Which describes the default behavior when you create a table...; Question 166: Evaluate the following SQL statement: (Exhibit) Which statem...; Question 167: See the Exhibits and examine the structures of PRODUCTS, SAL...; Question 168: Examine the structure of the PROMOS table: (Exhibit) You wan...; Question 169: Which three statements are true regarding subqueries? (Choos...; Question 170: Examine the structure of the employees table: (Exhibit) Ther...; Question 171: View the Exhibit and examine the structure of CUSTOMERS tabl...; Question 172: Which two are true about aggregate functions? (Choose two.)...; Question 173: Which normal form is a table in if it has no multi-valued at...; Question 174: Which SQL statement displays the date March 19, 2001 in a fo...; Question 175: Examine the statement: Create synonym emp for hr.employees; ...; Question 176: See the exhibit and examine the structure of the CUSTOMERS a...; Question 177: You want to create a sales table with the following column s...; Question 178: Examine the structure of the TRANSACTIONS table: Name Null T...; Question 179: Which are iSQL*Plus commands? (Choose all that apply.)...; Question 180: View the Exhibit and examine the structure of the CUSTOMERS ...; Question 181: View the Exhibits and examine the structures of the products...; Question 182: Evaluate the following SQL statements: Exhibit: (Exhibit) Yo...; Question 183: View the Exhibit and examine the structure and data in the I...; Question 184: Where can sub queries be used? (Choose all that apply)...; Question 185: Evaluate the following SQL commands: (Exhibit) The command t...; Question 186: Examine the structure of the STUDENTS table: (Exhibit) You n...; Question 187: What is true regarding sub queries?...; Question 188: Examine the description of the EMPLOYEES table: EMP_ID NUMBE...; Question 189: Which best describes an inline view?...; Question 190: View the Exhibit and examine the data in the products table....; Question 191: Evaluate this SQL statement: SELECT ename, sal, 12*sal+100 F...; Question 192: Which four are valid Oracle constraint types? (Choose four.)...; Question 193: Which three are true? (Choose three.)...; Question 194: Which two statements are true about sequences created in a s...; Question 195: Which two statements are true regarding the ORDER BY clause?...; Question 196: A SELECT statement can be used to perform these three functi...; Question 197: View the Exhibit and examine the structure of the CUSTOMERS ...; Question 198: Examine the following SQL commands: (Exhibit) Which statemen...; Question 199: Examine the structure of the products table: (Exhibit) You w...; Question 200: View the Exhibit and examine the structure of the CUSTOMERS ...; Question 201: SLS is a private synonym for the SH.SALES table. The user SH...; Question 202: The DBA issues this SQL command: CREATE USER Scott IDENTIFIE...; Question 203: Here is the structure and data of the CUST_TRANS table: Exhi...; Question 204: Which is an iSQL*Plus command?; Question 205: Which is the valid CREATE [TABLE statement?...; Question 206: See the structure of the PROGRAMS table: (Exhibit) Which two...; Question 207: You issue the following query: SQL> SELECT AVG(MAX(qty)) ...; Question 208: Examine the description of the CUSTOMERS table: (Exhibit) Th...; Question 209: Which are /SQL*Plus commands? (Choose all that apply.)...; Question 210: View the Exhibit and examine the data in the EMPLOYEES table...; Question 211: View the Exhibit and examine the structure of the PRODUCTS t...; Question 212: The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMB...; Question 213: Which two statements are true about WHERE and HAVING clauses...; Question 214: View the Exhibit and examine the structure of the PROMOTIONS...; Question 215: Examine the structure and data in the PRIC E_LIST table: Nam...; Question 216: Which is an iSQL*Plus command?; Question 217: You are granted the CREATE VIEW privilege. What does this al...; Question 218: Which four are types of functions available in SQL? (Choose ...; Question 219: User Mary has a view called EMP_DEPT_LOC_VU that was created...; Question 220: Which two statements are true regarding constraints? (Choose...; Question 221: Which statement is true regarding sub queries?...; Question 222: Examine the data in the CUSTOMERS table: (Exhibit) You want ...; Question 223: View the Exhibit and examine the structure of the CUSTOMERS ...; Question 224: Which two statements are true regarding subqueries?...; Question 225: Evaluate the following query: SQL> SELECT TRUNC(ROUND(156...; Question 226: Which two statements are true regarding sub queries? (Choose...; Question 227: View the Exhibit and examine the structure of the ORDERS and...; Question 228: View the Exhibit and examine the structure of the promotions...; Question 229: Which statement is true regarding the UNION operator?...; Question 230: The following data exists in the PRODUCTS table: PROD_ID PRO...; Question 231: You work as a database administrator at ABC.com. You study t...; Question 232: View the Exhibit and examine the data in the PROMO_NAME and ...; Question 233: The SQL statements executed in a user session as follows: Ex...; Question 234: Which three statements are true regarding sub queries? (Choo...; Question 235: What does the FORCE option for creating a view do?...; Question 236: Exhibit contains the structure of PRODUCTS table: (Exhibit) ...; Question 237: Evaluate the following SQL statements: DELETE FROM sales; Th...; Question 238: View the Exhibit to examine the description for the SALES ta...; Question 239: Which is a valid CREATE TABLE statement?...; Question 240: The STUDENT_GRADES table has these columns: STUDENT_ID NUMBE...; Question 241: What is true about sequences?; Question 242: Evaluate the following SQL statement: (Exhibit) Which statem...; Question 243: You work as a database administrator at ABC.com. You study t...; Question 244: View the Exhibit and examine the data in the PROMOTIONS tabl...; Question 245: Examine the data in the ORD_ITEMS table: (Exhibit) Evaluate ...; Question 246: You need to display the first names of all customers from th...; Question 247: Which three statements are true regarding the data types in ...; Question 248: View the Exhibit and evaluate structures of the SALES, PRODU...; Question 249: The DBA issues this SQL command: CREATE USER scott IDENTIFIE...; Question 250: Evaluate the following SQL statements: Exhibit: (Exhibit) Ex...; Question 251: View the Exhibit and examine the structure of the PRODUCTS t...; Question 252: Which statement is true regarding the default behavior of th...; Question 253: View the Exhibit and examine the structure of ORDERS and CUS...; Question 254: View the Exhibit and examine the data in the employees table...; Question 255: The PRODUCTS table has these columns: PRODUCT_ID NUMBER(4) P...; Question 256: You need to produce a report where each customer's credit li...; Question 257: Which statements are true regarding the WHERE and HAVING cla...; Question 258: View the Exhibit and examine the structure of the PROMOTIONS...; Question 259: View the Exhibit and examine the description for the CUSTOME...; Question 260: View the Exhibit and examine the structure of the SALES tabl...; Question 261: Which statement adds a column called salary to the employees...; Question 262: Examine the structure of the MARKS table: Exhibit: (Exhibit)...; Question 263: You execute the following commands: (Exhibit) For which subs...; Question 264: Which three statements are true regarding views? (Choose thr...; Question 265: You need to perform these tasks: 1. Create and assign a MANA...; Question 266: Which tasks can be performed using SQL functions that are bu...; Question 267: See the Exhibit and examine the structure of the SALES, CUST...; Question 268: View the Exhibit and examine the structure of the PROMOTIONS...; Question 269: View the Exhibit; examine the structure of the PROMOTIONS ta...; Question 270: Which constraint can be defined only at the column level?...; Question 271: The STUDENT_GRADES table has these columns: STUDENT_ID. NUMB...; Question 272: The CUSTOMERS table has these columns: (Exhibit) A promotion...; Question 273: You need to create a table with the following column specifi...; Question 274: For which action can you use the TO_DATE function?...; Question 275: Which statement is true regarding synonyms?...; Question 276: The STUDENT_GRADES table has these columns: STUDENT_ID NUMBE...; Question 277: What are two reasons to create synonyms? (Choose two.)...; Question 278: The PRODUCTS table has the following structure: (Exhibit) Ev...; Question 279: View the Exhibit and examine the structure and data in the I...; Question 280: View the Exhibit and examine the data in the promotions tabl...; Question 281: Which statement describes the ROWID data type?...; Question 282: Which statement is true regarding transactions? (Choose all ...; Question 283: Examine the create table statements for the stores and sales...; Question 284: Examine the description of the EMP_DETAILS table given below...; Question 285: View the Exhibit and examine the structure of the CUSTOMERS ...; Question 286: The ORDERS TABLE belongs to the user OE. OE has granted the ...; Question 287: View the Exhibit and examine the structure of the PROMOTIONS...; Question 288: Evaluate the SQL statement DROP TABLE DEPT: Which four state...; Question 289: Which arithmetic operations can be performed on a column by ...; Question 290: Examine the data in the ORD_ITEMS table: ORD_NO ITEM_NO QTY ...; Question 291: Which two statements are true regarding savepoints? (Choose ...; Question 292: View the Exhibit and examine the structure of the CUSTOMERS ...; Question 293: Examine the SQL statement that creates ORDERS table: CREATE ...; Question 294: View the Exhibit and examine the structures of the employees...; Question 295: Which create table statement is valid? (Exhibit)...; Question 296: Which two statements are true regarding constraints?...; Question 297: Examine these statements: CREATE ROLE registrar; GRANT UPDAT...; Question 298: You need to calculate the number of days from 1st Jan 2007 t...; Question 299: View the Exhibit and examine the structure of CUSTOMERS and ...; Question 300: Examine the structure of the EMPLOYEES table: (Exhibit) Whic...

Question 164/300

LEAVE A REPLY

Download PDF File